APPS.PAY_CA_T4A_CANCEL_MAG dependencies on PER_ALL_ASSIGNMENTS_F

Line 11: from per_all_assignments_f paaf,

7: IS
8: BEGIN
9:
10: p_sqlstr := 'select distinct paaf.person_id
11: from per_all_assignments_f paaf,
12: pay_payroll_actions ppa,
13: pay_payroll_actions ppa1,
14: pay_assignment_actions paa
15: where ppa.payroll_action_id = paa.payroll_action_id

Line 46: per_all_assignments_f paaf,

42: paaf.effective_end_date,
43: paa.assignment_action_id,
44: ppa2.payroll_action_id
45: from
46: per_all_assignments_f paaf,
47: pay_payroll_actions ppa,
48: pay_payroll_actions ppa1,
49: pay_payroll_actions ppa2,
50: pay_assignment_actions paa,

Line 75: from per_all_assignments_f paaf2

71: and paa2.payroll_action_id =
72: to_number(pay_ca_t4a_cancel_mag.get_parameter('PAY_ACT', ppa1.legislative_parameters))
73: )
74: and paaf.effective_start_date = (select max(paaf2.effective_start_date)
75: from per_all_assignments_f paaf2
76: where paaf2.assignment_id = paa.assignment_id
77: and paaf2.effective_start_date <= ppa.effective_date)
78: order by paaf.person_id;
79: -----

Line 88: per_all_assignments_f paaf,

84: paaf.effective_end_date,
85: paa.assignment_action_id,
86: ppa2.payroll_action_id
87: from
88: per_all_assignments_f paaf,
89: pay_payroll_actions ppa,
90: pay_payroll_actions ppa1,
91: pay_payroll_actions ppa2,
92: pay_assignment_actions paa,

Line 125: from per_all_assignments_f paaf2

121: and paa2.payroll_action_id =
122: to_number(pay_ca_t4a_cancel_mag.get_parameter('PAY_ACT', ppa1.legislative_parameters))
123: )
124: and paaf.effective_start_date = (select max(paaf2.effective_start_date)
125: from per_all_assignments_f paaf2
126: where paaf2.assignment_id = paa.assignment_id
127: and paaf2.effective_start_date <= ppa.effective_date)
128: order by paaf.person_id;
129: -----