DBA Data[Home] [Help]

APPS.IGS_FI_PRC_ACCT_PKG dependencies on IGS_FI_F_TYPE_ACCTS

Line 258: CURSOR cur_fi_f_type_accts (cp_fee_type igs_fi_f_type_accts.fee_type%TYPE,

254:
255: --
256: --Get the Segment Values for the Fee Type Entity
257: --
258: CURSOR cur_fi_f_type_accts (cp_fee_type igs_fi_f_type_accts.fee_type%TYPE,
259: cp_fee_cal_type igs_fi_f_type_accts.fee_cal_type%TYPE,
260: cp_fee_ci_sequence_number igs_fi_f_type_accts.fee_ci_sequence_number%TYPE)
261: IS
262: SELECT segment_num,segment_value

Line 259: cp_fee_cal_type igs_fi_f_type_accts.fee_cal_type%TYPE,

255: --
256: --Get the Segment Values for the Fee Type Entity
257: --
258: CURSOR cur_fi_f_type_accts (cp_fee_type igs_fi_f_type_accts.fee_type%TYPE,
259: cp_fee_cal_type igs_fi_f_type_accts.fee_cal_type%TYPE,
260: cp_fee_ci_sequence_number igs_fi_f_type_accts.fee_ci_sequence_number%TYPE)
261: IS
262: SELECT segment_num,segment_value
263: FROM igs_fi_f_type_accts

Line 260: cp_fee_ci_sequence_number igs_fi_f_type_accts.fee_ci_sequence_number%TYPE)

256: --Get the Segment Values for the Fee Type Entity
257: --
258: CURSOR cur_fi_f_type_accts (cp_fee_type igs_fi_f_type_accts.fee_type%TYPE,
259: cp_fee_cal_type igs_fi_f_type_accts.fee_cal_type%TYPE,
260: cp_fee_ci_sequence_number igs_fi_f_type_accts.fee_ci_sequence_number%TYPE)
261: IS
262: SELECT segment_num,segment_value
263: FROM igs_fi_f_type_accts
264: WHERE fee_type = cp_fee_type

Line 263: FROM igs_fi_f_type_accts

259: cp_fee_cal_type igs_fi_f_type_accts.fee_cal_type%TYPE,
260: cp_fee_ci_sequence_number igs_fi_f_type_accts.fee_ci_sequence_number%TYPE)
261: IS
262: SELECT segment_num,segment_value
263: FROM igs_fi_f_type_accts
264: WHERE fee_type = cp_fee_type
265: AND fee_cal_type = cp_fee_cal_type
266: AND fee_ci_sequence_number = cp_fee_ci_sequence_number;
267: