APPS.IGF_AW_PACKAGING dependencies on HZ_PARTIES

Line 7671: hz_parties pe

7667: -- Get the person Number for log
7668: CURSOR c_person_number( x_base_id igf_ap_fa_con_v.base_id%TYPE ) IS
7669: SELECT pe.party_number person_number, fa.packaging_status
7670: FROM igf_ap_fa_base_rec_all fa,
7671: hz_parties pe
7672: WHERE fa.base_id = x_base_id
7673: AND pe.party_id = fa.person_id;
7674:
7675: l_person_number c_person_number%ROWTYPE;

Line 8470: FROM hz_parties pe,

8466:
8467: --Cursor to fetch the Person Number for the base id.
8468: CURSOR c_person_number( cp_base_id igf_ap_fa_base_rec.base_id%TYPE ) IS
8469: SELECT pe.party_number person_number
8470: FROM hz_parties pe,
8471: igf_ap_fa_base_rec_all fabase
8472: WHERE fabase.base_id = cp_base_id
8473: AND pe.party_id = fabase.person_id;
8474:

Line 13089: FROM hz_parties parties,

13085: CURSOR c_person_number(
13086: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE
13087: ) IS
13088: SELECT party_number
13089: FROM hz_parties parties,
13090: igf_ap_fa_base_rec_all fabase
13091: WHERE fabase.person_id = parties.party_id
13092: AND fabase.base_id = cp_base_id;
13093: l_person_number hz_parties.party_number%TYPE;

Line 13093: l_person_number hz_parties.party_number%TYPE;

13089: FROM hz_parties parties,
13090: igf_ap_fa_base_rec_all fabase
13091: WHERE fabase.person_id = parties.party_id
13092: AND fabase.base_id = cp_base_id;
13093: l_person_number hz_parties.party_number%TYPE;
13094:
13095: -- Get DP details
13096: CURSOR c_dp(
13097: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE