DBA Data[Home] [Help]

APPS.PA_CC_TP_UTILS dependencies on HR_ORGANIZATION_INFORMATION

Line 69: hr_organization_information o2

65: cursor c_bg is
66: select '1' from dual
67: where exists (select 'Y'
68: from hr_organization_units o1,
69: hr_organization_information o2
70: where o1.organization_id=o2.organization_id
71: and o1.organization_id=p_organization_id
72: and o2.org_information_context||'' ='CLASS'
73: and o2.org_information1='HR_BG');

Line 420: hr_organization_information o2

416: cursor c_bg is
417: select '1' from dual
418: where exists (select 'Y'
419: from hr_organization_units o1,
420: hr_organization_information o2
421: where o1.organization_id=o2.organization_id
422: and o1.organization_id=p_organization_id
423: and o2.org_information_context||''='CLASS'
424: and o2.org_information1='HR_BG');