DBA Data[Home] [Help]

APPS.GML_ACCT_GENERATE dependencies on GL_ACCU_MST

Line 471: FROM gl_accu_mst

467: order by nvl(orgn_code, ' ') desc, nvl(whse_code, ' ') desc;
468:
469: CURSOR Cur_acctg_unit_no IS
470: SELECT acctg_unit_no
471: FROM gl_accu_mst
472: WHERE acctg_unit_id = P_acctg_unit_id;
473:
474: BEGIN
475:

Line 604: x_acctg_unit_no gl_accu_mst.acctg_unit_no%TYPE := NULL;

600: v_acct_id IN NUMBER,
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;

Line 628: FROM gl_accu_mst WHERE acctg_unit_id = p_acctg_unit_id;

624:
625: PrintLn('begin of gen_combination_id');
626:
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;