For Workflows on the P2K_AT_LEAVE_LINES table, users have access to these related tables:
- P2K_HR_IDENTITIES - for the identity that the leave line is tied to
- P2K_HR_EMPLOYMENTS - for the employment that the leave line is tied to
- P2K_HR_ASSIGNMENTS - for the prime assignment for that employment
- P2K_HR_ASSIGNMENT_DETAILS - for the effective record as of the Pay Period End (or SYSDATE if not in Payroll)
- P2K_CM_TIME_CODES - for the time code that the leave line is tied to
- P2K_AT_LEAVE_POLICY_TYPES - for the leave policy type that the leave line is tied to
Work Flow will only fire on inserted Leave Lines with an absence source of
- 10 (AT Data Entry)
- 20 (PR Data Entry)
- 30 (TE Data Entry)
- 40 (WS Data Entry)