APPS.PAY_ZA_IRP5_IT3A_XMLP_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 22: token_val pay_payroll_actions.legislative_parameters%type;

18: ) return varchar2 is
19:
20: start_ptr number;
21: end_ptr number;
22: token_val pay_payroll_actions.legislative_parameters%type;
23: par_value pay_payroll_actions.legislative_parameters%type;
24:
25: begin
26: token_val := name || '=';

Line 23: par_value pay_payroll_actions.legislative_parameters%type;

19:
20: start_ptr number;
21: end_ptr number;
22: token_val pay_payroll_actions.legislative_parameters%type;
23: par_value pay_payroll_actions.legislative_parameters%type;
24:
25: begin
26: token_val := name || '=';
27:

Line 123: from pay_payroll_actions ppa

119: p_cert_type varchar2, p_directive_num varchar2
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

Line 184: from pay_payroll_actions ppa

180: -- -----------------------------------------------------------------------------
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

Line 240: from pay_payroll_actions ppa

236: -- This cursor should give the certificates created by a single assignment action
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

Line 420: pay_payroll_actions ppa

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
422: and paa.payroll_action_id = :1
423: and pai.action_context_type = ''AAP''
424: and pai.action_information_category = ''ZATYE_EMPLOYEE_INFO''

Line 451: from pay_payroll_actions

447:
448: -- Retrieve legislative parameters from the archiver payroll action
449: select legislative_parameters
450: into leg_param
451: from pay_payroll_actions
452: where payroll_action_id = l_archive_pact;
453:
454: l_legal_entity_id := get_parameter('LEGAL_ENTITY', leg_param);
455: l_tax_year := lpad(get_parameter('TAX_YEAR', leg_param),4,'0');