APPS.PAY_GB_PAYROLL_RULES dependencies on PER_ALL_ASSIGNMENTS_F

Line 60: l_assg_no per_all_assignments_f.assignment_number%type;

56: WHERE payroll_id = p_payroll_id;
57: --
58: l_found NUMBER;
59: /* Start Bug Fix 7343780 */
60: l_assg_no per_all_assignments_f.assignment_number%type;
61: /* End Bug Fix 7343780 */
62: --
63:
64: --

Line 72: FROM per_all_assignments_f a,

68: /* Start Bug Fix 7343780 */
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')

Line 86: FROM per_all_assignments_f a,

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

Line 491: l_assg_no per_all_assignments_f.assignment_number%type;

487: WHERE payroll_id = p_payroll_id;
488: --
489: l_found NUMBER;
490: /* Start Bug Fix 7343780 */
491: l_assg_no per_all_assignments_f.assignment_number%type;
492: /* End Bug Fix 7343780 */
493: --
494:
495: --

Line 503: FROM per_all_assignments_f a,

499: /* Start Bug Fix 7343780 */
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')

Line 517: FROM per_all_assignments_f a,

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