APPS.GML_PO_GLDIST dependencies on GL_ACCU_MST

Line 824: FROM gl_accu_mst

820: order by nvl(orgn_code, ' ') desc, nvl(whse_code, ' ') desc;
821:
822: CURSOR Cur_acctg_unit_no IS
823: SELECT acctg_unit_no
824: FROM gl_accu_mst
825: WHERE acctg_unit_id = P_acctg_unit_id;
826:
827: X_acctg_orgn VARCHAR2(10);
828: X_acctg_whse VARCHAR2(10);

Line 1806: v_acctg_unit_no gl_accu_mst.acctg_unit_no%TYPE := NULL;

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

Line 1829: FROM gl_accu_mst WHERE acctg_unit_id = p_acctg_unit_id;

1825:
1826: BEGIN
1827:
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;

Line 2029: gl_accu_mst acu,

2025: CURSOR cur_get_ccid(v_act_ttl_typ NUMBER,v_po_id NUMBER,v_line_id NUMBER) IS
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,