DBA Data[Home] [Help]

APPS.GML_ACCT_GENERATE dependencies on GL_ACCT_MST

Line 502: FROM gl_acct_mst

498: PROCEDURE get_acct_no(V_acct_no OUT NOCOPY VARCHAR2, V_acct_desc OUT NOCOPY VARCHAR2) AS
499:
500: CURSOR Cur_acct_no IS
501: SELECT acct_no, acct_desc
502: FROM gl_acct_mst
503: WHERE acct_id= P_acct_id;
504:
505: BEGIN
506: OPEN Cur_acct_no;

Line 605: x_acct_no gl_acct_mst.acct_no%TYPE := NULL;

601: v_acctg_unit_id IN NUMBER,
602: v_combination_id IN OUT NOCOPY NUMBER) AS
603:
604: x_acctg_unit_no gl_accu_mst.acctg_unit_no%TYPE := NULL;
605: x_acct_no gl_acct_mst.acct_no%TYPE := NULL;
606: x_application_short_name VARCHAR2(50);
607: x_key_flex_code VARCHAR2(50);
608: x_chart_of_account_id NUMBER;
609: x_validation_date DATE;

Line 631: FROM gl_acct_mst

627: SELECT acctg_unit_no INTO x_acctg_unit_no
628: FROM gl_accu_mst WHERE acctg_unit_id = p_acctg_unit_id;
629:
630: SELECT acct_no INTO x_acct_no
631: FROM gl_acct_mst
632: WHERE acct_id = p_acct_id;
633:
634: SELECT segment_delimiter INTO x_segment_delimiter
635: FROM gl_plcy_mst