DBA Data[Home] [Help]

APPS.PAY_GB_PAYROLL_RULES dependencies on PAY_ASSIGNMENT_ACTIONS

Line 88: pay_assignment_actions act,

84: CURSOR csr_term_asg_future_act_exists(c_payroll_id number, c_effective_date date) is
85: SELECT 1
86: FROM per_all_assignments_f a,
87: per_assignment_status_types past,
88: pay_assignment_actions act,
89: pay_payroll_actions pact,
90: per_time_periods ptp
91: where a.payroll_id = c_payroll_id
92: and a.assignment_status_type_id = past.assignment_status_type_id

Line 519: pay_assignment_actions act,

515: CURSOR csr_term_asg_future_act_exists(c_payroll_id number, c_effective_date date) is
516: SELECT 1
517: FROM per_all_assignments_f a,
518: per_assignment_status_types past,
519: pay_assignment_actions act,
520: pay_payroll_actions pact,
521: per_time_periods ptp
522: where a.payroll_id = c_payroll_id
523: and a.assignment_status_type_id = past.assignment_status_type_id