APPS.PAY_GB_EDI_P46_CAR dependencies on HR_ORGANIZATION_INFORMATION

Line 77: hr_organization_information hoi

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'
81: AND substr(pact.legislative_parameters,

Line 193: hr_organization_information hoi

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'
197: AND substr(pact.legislative_parameters,