APPS.PAY_GB_PAYROLL_RULES dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 67: per_assignment_status_types past

63: --
64: CURSOR csr_term_asg_exists(c_payroll_id number, c_effective_date date) is
65: SELECT 1
66: FROM per_all_assignments_f a,
67: per_assignment_status_types past
68: where a.payroll_id = c_payroll_id
69: and a.assignment_status_type_id = past.assignment_status_type_id
70: and past.per_system_status IN ('TERM_ASSIGN')
71: and c_effective_date between a.effective_start_date and a.effective_end_date;

Line 81: per_assignment_status_types past,

77: --
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

Line 472: per_assignment_status_types past

468: --
469: CURSOR csr_term_asg_exists(c_payroll_id number, c_effective_date date) is
470: SELECT 1
471: FROM per_all_assignments_f a,
472: per_assignment_status_types past
473: where a.payroll_id = c_payroll_id
474: and a.assignment_status_type_id = past.assignment_status_type_id
475: and past.per_system_status IN ('TERM_ASSIGN')
476: and c_effective_date between a.effective_start_date and a.effective_end_date;

Line 486: per_assignment_status_types past,

482: --
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