APPS.PAY_ZA_IRP5_IT3A_XMLP_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 124: , pay_assignment_actions paa

120: ) return varchar2 is
121: CURSOR csr_prev_cert_num IS
122: select pai_1.action_information1 cert_num
123: from pay_payroll_actions ppa
124: , pay_assignment_actions paa
125: , pay_action_information pai_1
126: , pay_action_information pai_2
127: , hr_organization_information hoi
128: where ppa.business_group_id = P_BUSINESS_GROUP_ID

Line 185: , pay_assignment_actions paa

181: FUNCTION get_new_serial_num(p_paye_ref varchar2, p_year varchar2, p_payroll_ref varchar2) return varchar2 is
182: cursor csr_max_serial_num is
183: select max(substr(pai.action_information1,23,8)) max_serial_num
184: from pay_payroll_actions ppa
185: , pay_assignment_actions paa
186: , pay_action_information pai
187: , hr_organization_information hoi
188: where ppa.business_group_id = P_BUSINESS_GROUP_ID
189: and ppa.action_type='X'

Line 241: , pay_assignment_actions paa

237: -- and hence this cursor should return only one row
238: cursor csr_all_prev_cert_for_asg is
239: select distinct paa.assignment_action_id prev_assact
240: from pay_payroll_actions ppa
241: , pay_assignment_actions paa
242: , pay_action_information pai_1
243: , hr_organization_information hoi
244: where ppa.business_group_id = P_BUSINESS_GROUP_ID
245: and ppa.action_type='X'

Line 417: pay_assignment_actions paa,

413: pai.action_information18 DIRECTIVE_NUMBER1,
414: pai.action_information30 TEMP_CERTIFICATE_NUMBER
415: from pay_action_information pai,
416: pay_action_information pai2,
417: pay_assignment_actions paa,
418: hr_all_organization_units org,
419: per_all_assignments_f ass,
420: pay_payroll_actions ppa
421: where pai.action_context_id = paa.assignment_action_id