APPS.IGF_GR_REPACKAGE dependencies on HZ_PARTIES

Line 75: FROM hz_parties parties,

71: CURSOR c_person_number(
72: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE
73: ) IS
74: SELECT party_number
75: FROM hz_parties parties,
76: igf_ap_fa_base_rec_all fabase
77: WHERE fabase.person_id = parties.party_id
78: AND fabase.base_id = cp_base_id;
79:

Line 80: l_person_number hz_parties.party_number%TYPE;

76: igf_ap_fa_base_rec_all fabase
77: WHERE fabase.person_id = parties.party_id
78: AND fabase.base_id = cp_base_id;
79:
80: l_person_number hz_parties.party_number%TYPE;
81:
82: -- Get alternate code
83: CURSOR c_alternate_code(
84: cp_cal_type igs_ca_inst_all.cal_type%TYPE,

Line 514: FROM hz_parties parties,

510: CURSOR c_person_number(
511: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE
512: ) IS
513: SELECT party_number
514: FROM hz_parties parties,
515: igf_ap_fa_base_rec_all fabase
516: WHERE fabase.person_id = parties.party_id
517: AND fabase.base_id = cp_base_id;
518:

Line 519: l_person_number hz_parties.party_number%TYPE;

515: igf_ap_fa_base_rec_all fabase
516: WHERE fabase.person_id = parties.party_id
517: AND fabase.base_id = cp_base_id;
518:
519: l_person_number hz_parties.party_number%TYPE;
520:
521: lv_msg_text VARCHAR2(2000);
522: ln_msg_index NUMBER;
523: