DBA Data[Home] [Help]

APPS.IGF_SP_GEN_001 dependencies on IGS_PS_UNIT_VER_ALL

Line 114: cp_v_unit_cd IN igs_ps_unit_ver_all.unit_cd%TYPE,

110: cp_n_person_id IN hz_parties.party_id%TYPE,
111: cp_v_fee_cal_type IN igs_ca_inst_all.cal_type%TYPE,
112: cp_n_fee_seq_number IN igs_ca_inst.sequence_number%TYPE,
113: cp_v_fee_class IN igs_fi_fee_type_all.fee_class%TYPE,
114: cp_v_unit_cd IN igs_ps_unit_ver_all.unit_cd%TYPE,
115: cp_n_unit_ver_num IN igs_ps_unit_ver_all.version_number%TYPE
116: ) IS
117: SELECT inv.invoice_id, inv.invoice_amount
118: FROM igs_fi_inv_int_all inv,

Line 115: cp_n_unit_ver_num IN igs_ps_unit_ver_all.version_number%TYPE

111: cp_v_fee_cal_type IN igs_ca_inst_all.cal_type%TYPE,
112: cp_n_fee_seq_number IN igs_ca_inst.sequence_number%TYPE,
113: cp_v_fee_class IN igs_fi_fee_type_all.fee_class%TYPE,
114: cp_v_unit_cd IN igs_ps_unit_ver_all.unit_cd%TYPE,
115: cp_n_unit_ver_num IN igs_ps_unit_ver_all.version_number%TYPE
116: ) IS
117: SELECT inv.invoice_id, inv.invoice_amount
118: FROM igs_fi_inv_int_all inv,
119: igs_fi_invln_int_all invln,