APPS.IGS_PR_GEN_006 dependencies on IGS_EN_GEN_003

Line 2578: AND SUBSTR (igs_en_gen_003.get_staff_ind (p.party_id), 1, 1) = 'Y';

2574: FROM hz_parties p,
2575: fnd_user u
2576: WHERE u.user_id = FND_GLOBAL.USER_ID
2577: AND u.person_party_id = p.party_id
2578: AND SUBSTR (igs_en_gen_003.get_staff_ind (p.party_id), 1, 1) = 'Y';
2579: CURSOR c_pen IS
2580: SELECT pen.expiry_dt
2581: FROM IGS_PE_PERS_ENCUMB pen
2582: WHERE pen.person_id = p_person_id AND