APPS.PAY_GB_PAYROLL_RULES dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 73: per_assignment_status_types past

69: -- SELECT 1
70: SELECT a.assignment_number
71: /* End Bug Fix 7343780 */
72: FROM per_all_assignments_f a,
73: per_assignment_status_types past
74: where a.payroll_id = c_payroll_id
75: and a.assignment_status_type_id = past.assignment_status_type_id
76: and past.per_system_status IN ('TERM_ASSIGN')
77: and c_effective_date between a.effective_start_date and a.effective_end_date;

Line 87: per_assignment_status_types past,

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

Line 504: per_assignment_status_types past

500: -- SELECT 1
501: SELECT a.assignment_number
502: /* End Bug Fix 7343780 */
503: FROM per_all_assignments_f a,
504: per_assignment_status_types past
505: where a.payroll_id = c_payroll_id
506: and a.assignment_status_type_id = past.assignment_status_type_id
507: and past.per_system_status IN ('TERM_ASSIGN')
508: and c_effective_date between a.effective_start_date and a.effective_end_date;

Line 518: per_assignment_status_types past,

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