[Home] [Help]
33: pay_magtape_generic.get_parameter_value('ARCH_PAYROLL_ACTION_ID'),'REQUEST_ID')),
34: 'SUBMITTER_REF_NO=P', pay_gb_p11d_magtape.get_parameters(
35: pay_magtape_generic.get_parameter_value('ARCH_PAYROLL_ACTION_ID'),'SUBMITTER_REF_NO',
36: action_information6)
37: from pay_assignment_actions paa,
38: pay_action_information pai
39: where paa.payroll_action_id = pay_magtape_generic.get_parameter_value('ARCH_PAYROLL_ACTION_ID')
40: and pai.action_context_id = paa.assignment_action_id
41: and pai.action_information_category = 'EMEA PAYROLL INFO'
65: cursor csr_p11d_employee is
66: select /*+ ORDERED use_nl(paa,pai)
67: use_index(pai,pay_action_information_n2)*/
68: 'PERSON_ID=P',pai.action_information10
69: from pay_assignment_actions paa,
70: pay_action_information pai
71: where paa.payroll_action_id = pay_magtape_generic.get_parameter_value('ARCH_PAYROLL_ACTION_ID')
72: and pai.action_context_id = paa.assignment_action_id
73: and pai.action_information_category = 'GB EMPLOYEE DETAILS'
105: 'OTHER ITEMS NON 1A', 'M',
106: 'EXPENSES PAYMENTS', 'N',
107: 'MARORS', 'U') cat
108: from per_all_assignments_f paf,
109: pay_assignment_actions paa,
110: pay_action_information pai,
111: pay_action_information pai_person
112: where paf.person_id = pay_magtape_generic.get_parameter_value('PERSON_ID')
113: and paf.effective_end_date = (select max(paf2.effective_end_date)
132: decode(pai.action_information_category,
133: 'CAR AND CAR FUEL 2003_04', 'F',
134: 'INT FREE AND LOW INT LOANS', 'H') cat
135: from per_all_assignments_f paf,
136: pay_assignment_actions paa,
137: pay_action_information pai,
138: pay_action_information pai_person
139: where paf.person_id = pay_magtape_generic.get_parameter_value('PERSON_ID')
140: and paf.effective_end_date = (select max(paf2.effective_end_date)