APPS.IGF_SL_DL_LI_IMP_PKG dependencies on IGS_PE_HZ_PARTIES

Line 1094: lv_person_id igs_pe_hz_parties.party_id%TYPE := NULL;

1090: */
1091: l_valid BOOLEAN;
1092: indx NUMBER := 0;
1093: l_error VARCHAR2(20);
1094: lv_person_id igs_pe_hz_parties.party_id%TYPE := NULL;
1095: lv_base_id igf_ap_fa_base_rec_all.base_id%TYPE := NULL;
1096:
1097: -- Get the details of
1098: CURSOR c_accepted_amt(p_award_id NUMBER)

Line 3130: lv_person_id igs_pe_hz_parties.party_id%TYPE := NULL;

3126: lv_flag_lo BOOLEAN := FALSE;
3127: l_batch_valid VARCHAR2(1) ;
3128: l_processing VARCHAR2(80);
3129: l_person_number VARCHAR2(80);
3130: lv_person_id igs_pe_hz_parties.party_id%TYPE := NULL;
3131: lv_base_id igf_ap_fa_base_rec_all.base_id%TYPE := NULL;
3132: l_valid_for_dml VARCHAR2(2);
3133: l_error_flag BOOLEAN := FALSE;
3134: l_award_id igf_aw_award_all.award_id%TYPE;

Line 3225: igs_pe_hz_parties pe,

3221: cp_b_person_number VARCHAR2)
3222: IS
3223: SELECT 'X'
3224: FROM hz_relationships pr,
3225: igs_pe_hz_parties pe,
3226: hz_parties br,
3227: hz_parties st
3228: WHERE
3229: br.party_number = cp_b_person_number