APPS.IGF_SL_DL_LI_IMP_PKG dependencies on HZ_PARTIES

Line 341: FROM HZ_PARTIES HZ,

337: || (reverse chronological order - newest change first)
338: */
339: CURSOR c_get_dl_school IS
340: SELECT 'X'
341: FROM HZ_PARTIES HZ,
342: IGS_OR_ORG_ALT_IDS OLI,
343: IGS_OR_ORG_ALT_IDTYP OLT
344: WHERE OLI.ORG_STRUCTURE_ID = HZ.PARTY_NUMBER
345: AND OLI.ORG_ALTERNATE_ID_TYPE = OLT.ORG_ALTERNATE_ID_TYPE

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

Line 3226: hz_parties br,

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
3230: AND st.party_number = cp_person_number

Line 3227: hz_parties st

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
3230: AND st.party_number = cp_person_number
3231: AND pr.subject_id = st.party_id

Line 3316: p_party_type hz_parties.party_type%TYPE

3312: l_int_disb_rec c_int_disb_rec%ROWTYPE;
3313:
3314:
3315: CURSOR c_person_id(cp_person_number VARCHAR2,
3316: p_party_type hz_parties.party_type%TYPE
3317: )
3318: IS
3319: SELECT PARTY_ID
3320: FROM hz_parties

Line 3320: FROM hz_parties

3316: p_party_type hz_parties.party_type%TYPE
3317: )
3318: IS
3319: SELECT PARTY_ID
3320: FROM hz_parties
3321: WHERE party_number = cp_person_number and party_type = p_party_type;
3322:
3323:
3324: CURSOR c_atd_rep_comb(p_atd_entity_id_txt VARCHAR2, p_rep_entity_id_txt VARCHAR2)