APPS.PAY_GB_PAYROLL_RULES dependencies on PER_ALL_ASSIGNMENTS_F

Line 66: FROM per_all_assignments_f a,

62: -- to check whether any terminated asg found on the cur. payroll at effective(start) date
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')

Line 80: FROM per_all_assignments_f a,

76: -- if found then no error, otherwise raise an error.
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

Line 471: FROM per_all_assignments_f a,

467: -- to check whether any terminated asg found on the cur. payroll at effective(start) date
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')

Line 485: FROM per_all_assignments_f a,

481: -- if found then no error, otherwise raise an error.
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