APPS.PAY_CA_T4_CANCEL_MAG dependencies on PER_ALL_ASSIGNMENTS_F

Line 14: from per_all_assignments_f paaf,

10:
11: hr_utility.trace('Inside Range Cursor');
12:
13: p_sqlstr := 'select distinct paaf.person_id
14: from per_all_assignments_f paaf,
15: pay_payroll_actions ppa,
16: pay_payroll_actions ppa1,
17: pay_assignment_actions paa
18: where ppa.payroll_action_id = paa.payroll_action_id

Line 50: from per_all_assignments_f paaf,

46: paa1.tax_unit_id,
47: paaf.effective_end_date,
48: paa.assignment_action_id,
49: ppa2.payroll_action_id
50: from per_all_assignments_f paaf,
51: pay_payroll_actions ppa,
52: pay_payroll_actions ppa1,
53: pay_payroll_actions ppa2,
54: pay_assignment_actions paa,

Line 78: from per_all_assignments_f paaf2

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

Line 91: per_all_assignments_f paaf,

87: paaf.effective_end_date,
88: paa.assignment_action_id,
89: ppa2.payroll_action_id
90: from
91: per_all_assignments_f paaf,
92: pay_payroll_actions ppa,
93: pay_payroll_actions ppa1,
94: pay_payroll_actions ppa2,
95: pay_assignment_actions paa,

Line 128: from per_all_assignments_f paaf2

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

Line 138: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

134: l_effective_end_date DATE;
135: l_report_type pay_payroll_actions.report_type%TYPE;
136: l_business_group_id pay_payroll_actions.business_group_id%TYPE;
137: l_person_id per_all_people_f.person_id%TYPE;
138: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
139: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
140: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
141: lockingactid pay_assignment_actions.assignment_action_id%TYPE;
142: lv_report_type pay_payroll_actions.report_type%TYPE ;