APPS.PAY_GB_EDI_P46_CAR dependencies on HR_ORGANIZATION_INFORMATION

Line 177: hr_organization_information hoi

173: -to_date('06-04-'|| to_char(to_date(substr(pact.legislative_parameters,
174: instr(pact.legislative_parameters,'END_DATE=')+9, 10),'YYYY/MM/DD'),
175: 'YYYY'),'DD-MM-YYYY')), -1,0,1))
176: FROM pay_payroll_actions pact,
177: hr_organization_information hoi
178: WHERE pact.payroll_action_id = pay_magtape_generic.get_parameter_value
179: ('TRANSFER_PAYROLL_ACTION_ID')
180: AND hoi.org_information_context = 'Tax Details References'
181: AND substr(pact.legislative_parameters,

Line 296: hr_organization_information hoi

292: -to_date('06-04-'|| to_char(to_date(substr(pact.legislative_parameters,
293: instr(pact.legislative_parameters,'END_DATE=')+9, 10),'YYYY/MM/DD'),
294: 'YYYY'),'DD-MM-YYYY')), -1,0,1))
295: FROM pay_payroll_actions pact,
296: hr_organization_information hoi
297: WHERE pact.payroll_action_id = pay_magtape_generic.get_parameter_value
298: ('TRANSFER_PAYROLL_ACTION_ID')
299: AND hoi.org_information_context = 'Tax Details References'
300: AND substr(pact.legislative_parameters,

Line 336: hr_organization_information hoi

332: -to_date('06-04-'|| to_char(to_date(substr(pact.legislative_parameters,
333: instr(pact.legislative_parameters,'END_DATE=')+9, 10),'YYYY/MM/DD'),
334: 'YYYY'),'DD-MM-YYYY')), -1,0,1))
335: FROM pay_payroll_actions pact,
336: hr_organization_information hoi
337: WHERE pact.payroll_action_id = pay_magtape_generic.get_parameter_value
338: ('TRANSFER_PAYROLL_ACTION_ID')
339: AND hoi.org_information_context = 'Tax Details References'
340: AND substr(pact.legislative_parameters,