[Home] [Help]
72: 'TAX_DISTRICT=P', upper(nvl(substr(hoi.org_information2 ,1,40),' ')),
73: 'EMPLOYERS_ADDRESS_LINE=P',
74: upper(nvl(substr(hoi.org_information4,1,60),' ')),
75: 'EMPLOYERS_NAME=P', upper(nvl(substr(hoi.org_information3,1,36),' '))
76: FROM pay_payroll_actions pact,
77: hr_organization_information hoi
78: WHERE pact.payroll_action_id = pay_magtape_generic.get_parameter_value
79: ('TRANSFER_PAYROLL_ACTION_ID')
80: AND hoi.org_information_context = 'Tax Details References'
110: -- pay_action_interlocks pail,
111: -- pay_assignment_actions act,
112: ----------------------------------------------------------
113: -- Bug 4059844 - SQL Repository Perf
114: -- pay_payroll_actions pact,
115: pay_action_information pai
116: WHERE act_edi.payroll_action_id = pay_magtape_generic.get_parameter_value
117: ('TRANSFER_PAYROLL_ACTION_ID')
118: AND act_edi.assignment_action_id = pai.action_context_id
188: instr(pact.legislative_parameters,'END_DATE=')+9, 10),'YYYY/MM/DD')
189: -to_date('06-04-'|| to_char(to_date(substr(pact.legislative_parameters,
190: instr(pact.legislative_parameters,'END_DATE=')+9, 10),'YYYY/MM/DD'),
191: 'YYYY'),'DD-MM-YYYY')), -1,0,1))
192: FROM pay_payroll_actions pact,
193: hr_organization_information hoi
194: WHERE pact.payroll_action_id = pay_magtape_generic.get_parameter_value
195: ('TRANSFER_PAYROLL_ACTION_ID')
196: AND hoi.org_information_context = 'Tax Details References'
229: -- pay_action_interlocks pail,
230: -- pay_assignment_actions act,
231: ----------------------------------------------------------
232: -- Bug 4059844 - SQL Repository Perf
233: -- pay_payroll_actions pact,
234: pay_action_information pai
235: WHERE act_edi.payroll_action_id = pay_magtape_generic.get_parameter_value
236: ('TRANSFER_PAYROLL_ACTION_ID')
237: AND act_edi.assignment_action_id = pai.action_context_id