DBA Data[Home] [Help]

APPS.PAY_CN_EXC dependencies on HR_ORGANIZATION_INFORMATION

Line 257: , hr_organization_information HOI

253:
254: CURSOR cur_beg_of_fiscal_year ( p_owner_payroll_action_id NUMBER ) IS
255: SELECT fnd_date.canonical_to_date(org_information11)
256: FROM pay_payroll_actions PACT
257: , hr_organization_information HOI
258: WHERE UPPER(HOI.org_information_context) = 'BUSINESS GROUP INFORMATION'
259: AND HOI.organization_id = PACT.business_group_id
260: AND PACT.payroll_action_id = p_owner_payroll_action_id;
261:

Line 391: , hr_organization_information HOI

387:
388: CURSOR cur_beg_of_fiscal_year ( p_owner_payroll_action_id NUMBER ) IS
389: SELECT fnd_date.canonical_to_date(org_information11)
390: FROM pay_payroll_actions PACT
391: , hr_organization_information HOI
392: WHERE UPPER(HOI.org_information_context) = 'BUSINESS GROUP INFORMATION'
393: AND HOI.organization_id = PACT.business_group_id
394: AND PACT.payroll_action_id = p_owner_payroll_action_id;
395: