DBA Data[Home] [Help]

APPS.IGS_PS_VALIDATE_LGCY_PKG dependencies on PER_PEOPLE_F

Line 3935: FROM PER_PERSON_TYPE_USAGES_F USG,PER_PEOPLE_F PEO,IGS_PE_PER_TYPE_MAP MAP,HZ_PARTIES HZ

3931: AND TRUNC(SYSDATE) BETWEEN TRUNC(PTI.START_DATE) AND TRUNC(NVL(PTI.END_DATE,SYSDATE))
3932: AND HZ.STATUS = 'A'
3933: UNION
3934: SELECT 'X'
3935: FROM PER_PERSON_TYPE_USAGES_F USG,PER_PEOPLE_F PEO,IGS_PE_PER_TYPE_MAP MAP,HZ_PARTIES HZ
3936: WHERE HZ.PARTY_ID = peo.party_id
3937: AND USG.PERSON_ID = PEO.PERSON_ID
3938: AND HZ.PARTY_ID = p_person_id
3939: AND USG.PERSON_TYPE_ID = MAP.PER_PERSON_TYPE_ID AND TRUNC(SYSDATE) BETWEEN