eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGF_AP_GEN dependencies on HZ_PARTIES

Line 157: FROM igs_pe_hz_parties hz,

153: -- check person existence
154: CURSOR c_person_exist ( cp_person_number
155: igs_pe_person_base_v.person_number%TYPE ) IS
156: SELECT hz.party_id person_id
157: FROM igs_pe_hz_parties hz,
158: hz_parties hz1
159: WHERE hz1.party_number = cp_person_number
160: AND hz.party_id = hz1.party_id;
161: l_person_id c_person_exist%ROWTYPE;

Line 158: hz_parties hz1

154: CURSOR c_person_exist ( cp_person_number
155: igs_pe_person_base_v.person_number%TYPE ) IS
156: SELECT hz.party_id person_id
157: FROM igs_pe_hz_parties hz,
158: hz_parties hz1
159: WHERE hz1.party_number = cp_person_number
160: AND hz.party_id = hz1.party_id;
161: l_person_id c_person_exist%ROWTYPE;
162:

Line 899: FROM hz_parties hz,

895: CURSOR c_person_number(
896: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE
897: ) IS
898: SELECT hz.party_number
899: FROM hz_parties hz,
900: igf_ap_fa_base_rec_all fa
901: WHERE fa.person_id = hz.party_id
902: AND fa.base_id = cp_base_id;
903: l_person_number hz_parties.party_number%TYPE;

Line 903: l_person_number hz_parties.party_number%TYPE;

899: FROM hz_parties hz,
900: igf_ap_fa_base_rec_all fa
901: WHERE fa.person_id = hz.party_id
902: AND fa.base_id = cp_base_id;
903: l_person_number hz_parties.party_number%TYPE;
904:
905: -- Get item description
906: CURSOR c_td_item(
907: cp_item_sequence_number igf_ap_td_item_inst_all.item_sequence_number%TYPE