APPS.IGS_FI_WAV_DTLS_WF dependencies on HZ_PARTIES

Line 23: PROCEDURE raise_wavtrandtlstofa_event( p_n_person_id IN hz_parties.party_id%TYPE,

19: END IF;
20:
21: END log_to_fnd;
22:
23: PROCEDURE raise_wavtrandtlstofa_event( p_n_person_id IN hz_parties.party_id%TYPE,
24: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
25: p_c_fee_cal_type IN igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
26: p_n_fee_ci_seq_number IN igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,
27: p_n_waiver_amount IN igs_fi_inv_int_all.invoice_amount%TYPE) AS

Line 49: CURSOR cur_person_details(c_n_person_id IN hz_parties.party_id%TYPE) IS

45: FROM IGS_CA_INST_ALL
46: WHERE cal_type = c_cal_load_cal_type
47: AND sequence_number = c_n_load_ci_seq_number;
48:
49: CURSOR cur_person_details(c_n_person_id IN hz_parties.party_id%TYPE) IS
50: SELECT person_number, full_name
51: FROM IGS_PE_PERSON_BASE_V
52: WHERE person_id = c_n_person_id;
53:

Line 54: CURSOR cur_alt_person_id (c_n_person_id IN hz_parties.party_id%TYPE) IS

50: SELECT person_number, full_name
51: FROM IGS_PE_PERSON_BASE_V
52: WHERE person_id = c_n_person_id;
53:
54: CURSOR cur_alt_person_id (c_n_person_id IN hz_parties.party_id%TYPE) IS
55: SELECT api_person_id, person_id_type
56: FROM igs_pe_person_id_type_v
57: WHERE pe_person_id = c_n_person_id;
58:

Line 176: PROCEDURE raise_stdntwavassign_event(p_n_person_id IN hz_parties.party_id%TYPE,

172: /**
173: Procedure for raising student waiver assignment event
174: */
175:
176: PROCEDURE raise_stdntwavassign_event(p_n_person_id IN hz_parties.party_id%TYPE,
177: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
178: p_c_fee_cal_type IN igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
179: p_n_fee_ci_seq_number IN igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE) AS
180:

Line 181: CURSOR cur_person_details(c_n_person_id IN hz_parties.party_id%TYPE) IS

177: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
178: p_c_fee_cal_type IN igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
179: p_n_fee_ci_seq_number IN igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE) AS
180:
181: CURSOR cur_person_details(c_n_person_id IN hz_parties.party_id%TYPE) IS
182: SELECT person_number, full_name
183: FROM IGS_PE_PERSON_BASE_V
184: WHERE person_id = c_n_person_id;
185: