DBA Data[Home] [Help]

APPS.IGS_FI_PRC_ACCT_PKG dependencies on IGS_FI_FEE_TYPE

Line 729: CURSOR c_sys_fee_type (cp_fee_type IN igs_fi_fee_type.fee_type%TYPE)

725: WHERE seg.flex_value_set_id = val.flex_value_set_id
726: ORDER BY segment_num;
727:
728: -- cursor for selecting system fee type attached to the fee type that is passed as input to this procedure
729: CURSOR c_sys_fee_type (cp_fee_type IN igs_fi_fee_type.fee_type%TYPE)
730: IS
731: SELECT s_fee_type
732: FROM igs_fi_fee_type
733: WHERE fee_type = cp_fee_type;

Line 732: FROM igs_fi_fee_type

728: -- cursor for selecting system fee type attached to the fee type that is passed as input to this procedure
729: CURSOR c_sys_fee_type (cp_fee_type IN igs_fi_fee_type.fee_type%TYPE)
730: IS
731: SELECT s_fee_type
732: FROM igs_fi_fee_type
733: WHERE fee_type = cp_fee_type;
734: l_v_s_fee_type igs_fi_fee_type.s_fee_type%TYPE;
735:
736: -- cursor for getting the Natural Account Segment for Application, Chart OF Accounts and

Line 734: l_v_s_fee_type igs_fi_fee_type.s_fee_type%TYPE;

730: IS
731: SELECT s_fee_type
732: FROM igs_fi_fee_type
733: WHERE fee_type = cp_fee_type;
734: l_v_s_fee_type igs_fi_fee_type.s_fee_type%TYPE;
735:
736: -- cursor for getting the Natural Account Segment for Application, Chart OF Accounts and
737: -- Segment Attribute Type of GL_ACCOUNT
738: CURSOR cur_seg_num (cp_n_coa_id NUMBER,