DBA Data[Home] [Help]

APPS.GMF_VALIDATIONS_PVT dependencies on GL_ACCT_MST

Line 1612: l_acct_no gl_acct_mst.acct_no%TYPE;

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

Line 1613: l_acct_id gl_acct_mst.acct_id%TYPE;

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

Line 1674: FROM gl_acct_mst

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