DBA Data[Home] [Help]

APPS.GMF_VALIDATIONS_PVT dependencies on GL_ACCT_MST

Line 1610: l_acct_no gl_acct_mst.acct_no%TYPE;

1606: AND type = decode(ptype, '', type, ptype)
1607: AND delete_mark = 0;
1608:
1609: l_segment_delimiter gl_plcy_mst.segment_delimiter%TYPE;
1610: l_acct_no gl_acct_mst.acct_no%TYPE;
1611: l_acct_id gl_acct_mst.acct_id%TYPE;
1612: l_acctg_unit gl_accu_mst.acctg_unit_no%TYPE ;
1613: l_acctg_unit_id gl_accu_mst.acctg_unit_id%TYPE ;
1614: l_cnt_acctg_unit NUMBER(10);

Line 1611: l_acct_id gl_acct_mst.acct_id%TYPE;

1607: AND delete_mark = 0;
1608:
1609: l_segment_delimiter gl_plcy_mst.segment_delimiter%TYPE;
1610: l_acct_no gl_acct_mst.acct_no%TYPE;
1611: l_acct_id gl_acct_mst.acct_id%TYPE;
1612: l_acctg_unit gl_accu_mst.acctg_unit_no%TYPE ;
1613: l_acctg_unit_id gl_accu_mst.acctg_unit_id%TYPE ;
1614: l_cnt_acctg_unit NUMBER(10);
1615: l_cnt_seg NUMBER(10);

Line 1672: FROM gl_acct_mst

1668: AND delete_mark = 0 ;
1669:
1670: SELECT acct_desc
1671: INTO l_acct_desc
1672: FROM gl_acct_mst
1673: WHERE acct_no = l_acct_no
1674: AND co_code = p_co_code
1675: AND delete_mark = 0 ;
1676: