APPS.IGF_SL_CL_LI_IMP_PKG dependencies on HZ_PARTIES

Line 536: FROM hz_parties hz,

532:
533: CURSOR c_source_or_branch_id(cp_source_or_branch_id VARCHAR2, cp_source_type VARCHAR2)
534: IS
535: SELECT 1
536: FROM hz_parties hz,
537: igs_or_org_alt_ids oli,
538: igs_or_org_alt_idtyp olt
539: WHERE oli.org_structure_id = hz.party_number
540: AND oli.org_alternate_id_type = olt.org_alternate_id_type

Line 1261: igs_pe_hz_parties pe,

1257: )
1258: IS
1259: SELECT 'X'
1260: FROM hz_relationships pr,
1261: igs_pe_hz_parties pe,
1262: hz_parties br,
1263: hz_parties st
1264: WHERE
1265: br.party_number = cp_b_person_number

Line 1262: hz_parties br,

1258: IS
1259: SELECT 'X'
1260: FROM hz_relationships pr,
1261: igs_pe_hz_parties pe,
1262: hz_parties br,
1263: hz_parties st
1264: WHERE
1265: br.party_number = cp_b_person_number
1266: AND st.party_number = cp_person_number

Line 1263: hz_parties st

1259: SELECT 'X'
1260: FROM hz_relationships pr,
1261: igs_pe_hz_parties pe,
1262: hz_parties br,
1263: hz_parties st
1264: WHERE
1265: br.party_number = cp_b_person_number
1266: AND st.party_number = cp_person_number
1267: AND pr.subject_id = st.party_id

Line 1336: FROM hz_parties hz,

1332: -- Cursor to validate School Non Educational Branch Id.
1333: CURSOR c_source_or_branch_id(cp_sch_non_ed_brc_id VARCHAR2, cp_source_type VARCHAR2)
1334: IS
1335: SELECT 1
1336: FROM hz_parties hz,
1337: igs_or_org_alt_ids oli,
1338: igs_or_org_alt_idtyp olt
1339: WHERE oli.org_structure_id = hz.party_number
1340: AND oli.org_alternate_id_type = olt.org_alternate_id_type

Line 5088: lv_person_id igs_pe_hz_parties.party_id%TYPE;

5084: l_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE;
5085: l_seq_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE;
5086: l_award_id igf_aw_award_all.award_id%TYPE;
5087: l_fed_fund_cd igf_aw_fund_cat.fed_fund_code%TYPE;
5088: lv_person_id igs_pe_hz_parties.party_id%TYPE;
5089: lv_base_id igf_ap_fa_base_rec_all.base_id%TYPE;
5090:
5091: l_interface c_interface%ROWTYPE;
5092: l_disb_interface c_disb_interface%ROWTYPE;