DBA Data[Home] [Help]

APPS.PAY_GB_PAYROLL_RULES dependencies on PAY_ASSIGNMENT_ACTIONS

Line 82: pay_assignment_actions act,

78: CURSOR csr_term_asg_future_act_exists(c_payroll_id number, c_effective_date date) is
79: SELECT 1
80: FROM per_all_assignments_f a,
81: per_assignment_status_types past,
82: pay_assignment_actions act,
83: pay_payroll_actions pact,
84: per_time_periods ptp
85: where a.payroll_id = c_payroll_id
86: and a.assignment_status_type_id = past.assignment_status_type_id

Line 487: pay_assignment_actions act,

483: CURSOR csr_term_asg_future_act_exists(c_payroll_id number, c_effective_date date) is
484: SELECT 1
485: FROM per_all_assignments_f a,
486: per_assignment_status_types past,
487: pay_assignment_actions act,
488: pay_payroll_actions pact,
489: per_time_periods ptp
490: where a.payroll_id = c_payroll_id
491: and a.assignment_status_type_id = past.assignment_status_type_id