DBA Data[Home] [Help]

APPS.IGS_FI_PRC_FEE_ASS dependencies on IGS_FI_ER_ORD_DTLS

Line 750: l_n_order_num igs_fi_er_ord_dtls.order_num%TYPE;

746: ***************************************************************/
747:
748: j NUMBER;
749: l_rec_index_row r_s_fee_as_items_typ;
750: l_n_order_num igs_fi_er_ord_dtls.order_num%TYPE;
751: l_v_order_attr_val igs_fi_er_ord_dtls.order_attr_value%TYPE;
752:
753: CURSOR cur_order_num (cp_n_unit_type_id igs_fi_fee_as_items.unit_type_id%TYPE) IS
754: SELECT order_num, order_attr_value

Line 751: l_v_order_attr_val igs_fi_er_ord_dtls.order_attr_value%TYPE;

747:
748: j NUMBER;
749: l_rec_index_row r_s_fee_as_items_typ;
750: l_n_order_num igs_fi_er_ord_dtls.order_num%TYPE;
751: l_v_order_attr_val igs_fi_er_ord_dtls.order_attr_value%TYPE;
752:
753: CURSOR cur_order_num (cp_n_unit_type_id igs_fi_fee_as_items.unit_type_id%TYPE) IS
754: SELECT order_num, order_attr_value
755: FROM igs_fi_er_ord_dtls

Line 755: FROM igs_fi_er_ord_dtls

751: l_v_order_attr_val igs_fi_er_ord_dtls.order_attr_value%TYPE;
752:
753: CURSOR cur_order_num (cp_n_unit_type_id igs_fi_fee_as_items.unit_type_id%TYPE) IS
754: SELECT order_num, order_attr_value
755: FROM igs_fi_er_ord_dtls
756: WHERE elm_rng_order_name = p_v_elm_rng_order_name
757: AND order_attr_value = TO_CHAR(cp_n_unit_type_id);
758:
759: BEGIN