DBA Data[Home] [Help]

APPS.PAY_P45_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 85: hr_organization_information hoi

81: 'EMPLOYERS_ADDRESS_LINE=P',
82: upper(nvl(substr(hoi.org_information4,1,60),' ')),
83: 'EMPLOYERS_NAME=P', upper(nvl(substr(hoi.org_information3,1,36),' '))
84: FROM pay_payroll_actions pact,
85: hr_organization_information hoi
86: WHERE pact.payroll_action_id = pay_magtape_generic.get_parameter_value
87: ('TRANSFER_PAYROLL_ACTION_ID')
88: AND hoi.org_information_context = 'Tax Details References'
89: AND substr(pact.legislative_parameters,

Line 178: hr_organization_information hoi

174: 'TEST_ID=P' , nvl(pay_gb_eoy_archive.get_parameter
175: (legislative_parameters,
176: 'TEST_ID'),' ') /*added for P45PT1*/
177: FROM pay_payroll_actions pact,
178: hr_organization_information hoi
179: WHERE pact.payroll_action_id = pay_magtape_generic.get_parameter_value
180: ('TRANSFER_PAYROLL_ACTION_ID')
181: AND hoi.org_information_context = 'Tax Details References'
182: AND substr(pact.legislative_parameters,

Line 275: hr_organization_information hoi

271: 'TEST_ID=P' , nvl(pay_gb_eoy_archive.get_parameter
272: (legislative_parameters,
273: 'TEST_ID'),' ') /*added for P45PT1*/
274: FROM pay_payroll_actions pact,
275: hr_organization_information hoi
276: WHERE pact.payroll_action_id = pay_magtape_generic.get_parameter_value
277: ('TRANSFER_PAYROLL_ACTION_ID')
278: AND hoi.org_information_context = 'Tax Details References'
279: AND substr(pact.legislative_parameters,