APPS.GML_PO_GLDIST dependencies on GL_ACCT_MST

Line 873: FROM gl_acct_mst

869: PROCEDURE get_acct_no(V_acct_no OUT NOCOPY VARCHAR2, V_acct_desc OUT NOCOPY VARCHAR2) AS
870:
871: CURSOR Cur_acct_no IS
872: SELECT acct_no, acct_desc
873: FROM gl_acct_mst
874: WHERE acct_id= P_acct_id;
875:
876: BEGIN
877: OPEN Cur_acct_no;

Line 1807: v_acct_no gl_acct_mst.acct_no%TYPE := NULL;

1803: v_acctg_unit_id IN NUMBER,
1804: v_combination_id IN OUT NOCOPY NUMBER) IS
1805:
1806: v_acctg_unit_no gl_accu_mst.acctg_unit_no%TYPE := NULL;
1807: v_acct_no gl_acct_mst.acct_no%TYPE := NULL;
1808: v_application_short_name VARCHAR2(50);
1809: v_key_flex_code VARCHAR2(50);
1810: v_chart_of_account_id NUMBER;
1811: v_validation_date DATE;

Line 1832: FROM gl_acct_mst

1828: SELECT acctg_unit_no INTO v_acctg_unit_no
1829: FROM gl_accu_mst WHERE acctg_unit_id = p_acctg_unit_id;
1830:
1831: SELECT acct_no INTO v_acct_no
1832: FROM gl_acct_mst
1833: WHERE acct_id = p_acct_id;
1834:
1835: /* SR dt 25-Jan-2001 B1530509 added select to get segment delimiter */
1836:

Line 2030: gl_acct_mst act,

2026: SELECT cc.code_combination_id
2027: FROM gl_code_combinations_kfv cc,
2028: cpg_oragems_mapping map,
2029: gl_accu_mst acu,
2030: gl_acct_mst act,
2031: po_dist_dtl pdd,
2032: po_distributions_all pod,
2033: gl_plcy_mst gpm,
2034: gl_sets_of_books gsob