APPS.GML_VALIDATE_PO dependencies on GL_SRCE_MST

Line 637: (v_trans_source_type OUT gl_srce_mst.trans_source_type%TYPE)

633: | |
634: =========================================================================*/
635:
636: PROCEDURE get_gl_source
637: (v_trans_source_type OUT gl_srce_mst.trans_source_type%TYPE)
638: IS
639: err_num NUMBER;
640: err_msg VARCHAR2(100);
641:

Line 644: FROM gl_srce_mst

640: err_msg VARCHAR2(100);
641:
642: CURSOR gl_cur IS
643: SELECT trans_source_type
644: FROM gl_srce_mst
645: WHERE trans_source_code = 'PO';
646:
647: BEGIN
648: OPEN gl_cur;

Line 715: v_trans_source_type IN gl_srce_mst.trans_source_type%TYPE)

711: v_mul_div_sign OUT gl_xchg_rte.mul_div_sign%TYPE,
712: v_exchange_rate_date OUT gl_xchg_rte.exchange_rate_date%TYPE,
713: v_to_currency IN gl_xchg_rte.to_currency_code%TYPE,
714: v_from_currency IN gl_xchg_rte.from_currency_code%TYPE,
715: v_trans_source_type IN gl_srce_mst.trans_source_type%TYPE)
716:
717: IS
718: err_num NUMBER;
719: err_msg VARCHAR2(100);

Line 726: gl_srce_mst src

722: SELECT ex.exchange_rate,
723: ex.mul_div_sign,
724: ex.exchange_rate_date
725: FROM gl_xchg_rte ex,
726: gl_srce_mst src
727: WHERE ex.to_currency_code = v_to_currency AND
728: ex.from_currency_code = v_from_currency AND
729: ex.exchange_rate_date <= SYSDATE AND
730: ex.rate_type_code = src.rate_type_code AND