DBA Data[Home] [Help]

APPS.IGS_EN_GEN_006 dependencies on IGS_PE_PERSON_BASE_V

Line 631: IGS_PE_PERSON_BASE_V pbv

627: --modified cursor for performance bug 4968380
628: CURSOR c_person IS
629: SELECT DECODE(Pbv.DATE_OF_DEATH,NULL,NVL(PE.DECEASED_IND,'N'),'Y') DECEASED_IND
630: FROM IGS_PE_HZ_PARTIES pe,
631: IGS_PE_PERSON_BASE_V pbv
632: WHERE pe.party_id = p_person_id AND
633: pbv.person_id = pe.party_id;
634:
635: CURSOR c_ci IS