DBA Data[Home] [Help]

APPS.PAY_P45_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 76: hr_organization_information hoi

72: 'EMPLOYERS_ADDRESS_LINE=P',
73: upper(nvl(substr(hoi.org_information4,1,60),' ')),
74: 'EMPLOYERS_NAME=P', upper(nvl(substr(hoi.org_information3,1,36),' '))
75: FROM pay_payroll_actions pact,
76: hr_organization_information hoi
77: WHERE pact.payroll_action_id = pay_magtape_generic.get_parameter_value
78: ('TRANSFER_PAYROLL_ACTION_ID')
79: AND hoi.org_information_context = 'Tax Details References'
80: AND substr(pact.legislative_parameters,

Line 169: hr_organization_information hoi

165: 'TEST_ID=P' , nvl(pay_gb_eoy_archive.get_parameter
166: (legislative_parameters,
167: 'TEST_ID'),' ') /*added for P45PT1*/
168: FROM pay_payroll_actions pact,
169: hr_organization_information hoi
170: WHERE pact.payroll_action_id = pay_magtape_generic.get_parameter_value
171: ('TRANSFER_PAYROLL_ACTION_ID')
172: AND hoi.org_information_context = 'Tax Details References'
173: AND substr(pact.legislative_parameters,