714: || Added call to igs_en_unit_set_pkg.get_pk_for_validation
715: --------------------------------------------------------------------*/
716: CURSOR cur1(p_party_id IN NUMBER) IS
717: SELECT 'X'
718: FROM hz_parties HP,
719: igs_pe_hz_parties PHP
720: WHERE HP.party_id = p_party_id
721: AND PHP.inst_org_ind = 'O'
722: AND HP.party_id = PHP.party_id;
715: --------------------------------------------------------------------*/
716: CURSOR cur1(p_party_id IN NUMBER) IS
717: SELECT 'X'
718: FROM hz_parties HP,
719: igs_pe_hz_parties PHP
720: WHERE HP.party_id = p_party_id
721: AND PHP.inst_org_ind = 'O'
722: AND HP.party_id = PHP.party_id;
723: BEGIN