DBA Data[Home] [Help]

APPS.PAY_US_SQWL_ARCHIVE dependencies on HR_LEGAL_ENTITIES

Line 3411: FROM hr_legal_entities org

3407:
3408:
3409: CURSOR c_chk_gre_wp IS
3410: SELECT count(*) ct
3411: FROM hr_legal_entities org
3412: WHERE org.business_group_id = l_bus_group_id
3413: AND EXISTS (SELECT null
3414: FROM hr_organization_information orgi
3415: WHERE organization_id = org.organization_id

Line 3427: FROM hr_legal_entities org,

3423: AND org_information4 = 'Y');
3424:
3425: CURSOR c_dup_orgn_info IS
3426: SELECT count(*) ct
3427: FROM hr_legal_entities org,
3428: (select distinct
3429: a.organization_id,
3430: a.org_information1,
3431: a.org_information3