DBA Data[Home] [Help]

APPS.PA_CC_TP_UTILS dependencies on HR_ORGANIZATION_UNITS

Line 68: from hr_organization_units o1,

64:
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'

Line 419: from hr_organization_units o1,

415: IS
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'