DBA Data[Home] [Help]

APPS.PAY_P45_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 84: FROM pay_payroll_actions pact,

80: 'TAX_DISTRICT=P', upper(nvl(substr(hoi.org_information2 ,1,40),' ')),
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'

Line 141: pay_payroll_actions pact,

137: substr(fai.VALUE,1,35))),' '))
138: FROM pay_assignment_actions act_edi,
139: pay_action_interlocks pai,
140: pay_assignment_actions act,
141: pay_payroll_actions pact,
142: ff_archive_items fai,
143: ff_user_entities fue
144: WHERE act_edi.payroll_action_id = pay_magtape_generic.get_parameter_value
145: ('TRANSFER_PAYROLL_ACTION_ID')

Line 177: FROM pay_payroll_actions pact,

173: 'EMPLOYERS_NAME=P', upper(nvl(substr(hoi.org_information3,1,36),' ')),
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'

Line 238: pay_payroll_actions pact,

234: 'EFFECTIVE_DATE=P', fnd_date.date_to_canonical(pact.effective_date)
235: FROM pay_assignment_actions act_edi,
236: pay_action_interlocks pai,
237: pay_assignment_actions act,
238: pay_payroll_actions pact,
239: ff_archive_items fai,
240: ff_user_entities fue
241: WHERE act_edi.payroll_action_id = pay_magtape_generic.get_parameter_value
242: ('TRANSFER_PAYROLL_ACTION_ID')

Line 274: FROM pay_payroll_actions pact,

270: 'EMPLOYERS_NAME=P', upper(nvl(substr(hoi.org_information3,1,36),' ')),
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'

Line 335: pay_payroll_actions pact,

331: 'EFFECTIVE_DATE=P', fnd_date.date_to_canonical(pact.effective_date)
332: FROM pay_assignment_actions act_edi,
333: pay_action_interlocks pai,
334: pay_assignment_actions act,
335: pay_payroll_actions pact,
336: ff_archive_items fai,
337: ff_user_entities fue
338: WHERE act_edi.payroll_action_id = pay_magtape_generic.get_parameter_value
339: ('TRANSFER_PAYROLL_ACTION_ID')