DBA Data[Home] [Help]

APPS.JG_ZZ_VAT_SELECTION_PKG dependencies on GL_LEDGER_LE_V

Line 3584: l_ledger_id GL_LEDGER_LE_V.ledger_id%TYPE;

3580: IS
3581: l_api_name CONSTANT VARCHAR2(30) := 'TAX_DATE_MAINTENANCE_PROGRAM';
3582: l_prim_acct_method VARCHAR2(15);
3583: l_num NUMBER := 0;
3584: l_ledger_id GL_LEDGER_LE_V.ledger_id%TYPE;
3585:
3586: -- Cursor to fecth all the invoices (Prepayments, Small Business Supplier
3587: -- Invoices ) for which the tax date is not present and not
3588: -- finally reported

Line 3694: FROM gl_ledger_le_v

3690:
3691: IF p_legal_entity_id IS NOT NULL THEN
3692: SELECT ledger_id
3693: INTO l_ledger_id
3694: FROM gl_ledger_le_v
3695: WHERE legal_entity_id = p_legal_entity_id
3696: AND LEDGER_CATEGORY_CODE = 'PRIMARY';
3697: ELSE
3698: l_ledger_id := p_ledger_id;