DBA Data[Home] [Help]

APPS.JG_ZZ_VAT_SELECTION_PKG dependencies on GL_LEDGER_LE_V

Line 3765: l_ledger_id GL_LEDGER_LE_V.ledger_id%TYPE;

3761: IS
3762: l_api_name CONSTANT VARCHAR2(30) := 'TAX_DATE_MAINTENANCE_PROGRAM';
3763: l_prim_acct_method VARCHAR2(15);
3764: l_num NUMBER := 0;
3765: l_ledger_id GL_LEDGER_LE_V.ledger_id%TYPE;
3766:
3767: -- Cursor to fecth all the invoices (Prepayments, Small Business Supplier
3768: -- Invoices ) for which the tax date is not present and not
3769: -- finally reported

Line 3881: FROM gl_ledger_le_v

3877:
3878: IF p_legal_entity_id IS NOT NULL THEN
3879: SELECT ledger_id
3880: INTO l_ledger_id
3881: FROM gl_ledger_le_v
3882: WHERE legal_entity_id = p_legal_entity_id
3883: AND LEDGER_CATEGORY_CODE = 'PRIMARY';
3884: ELSE
3885: l_ledger_id := p_ledger_id;