DBA Data[Home] [Help]

APPS.PAY_US_SQWL_ARCHIVE dependencies on HR_LEGAL_ENTITIES

Line 2474: FROM hr_legal_entities org

2470:
2471:
2472: CURSOR c_chk_gre_wp IS
2473: SELECT count(*) ct
2474: FROM hr_legal_entities org
2475: WHERE org.business_group_id = l_bus_group_id
2476: AND EXISTS (SELECT null
2477: FROM hr_organization_information orgi
2478: WHERE organization_id = org.organization_id

Line 2490: FROM hr_legal_entities org,

2486: AND org_information4 = 'Y');
2487:
2488: CURSOR c_dup_orgn_info IS
2489: SELECT count(*) ct
2490: FROM hr_legal_entities org,
2491: (select distinct
2492: a.organization_id,
2493: a.org_information1,
2494: a.org_information3