DBA Data[Home] [Help]

APPS.FUN_TRX_PVT dependencies on GL_LEDGER_LE_BSV_SPECIFIC_V

Line 580: FROM GL_LEDGER_LE_BSV_SPECIFIC_V

576: x_valid_bsvs OUT NOCOPY VARCHAR2
577: ) IS
578: CURSOR valid_bsv_csr IS
579: SELECT segment_value
580: FROM GL_LEDGER_LE_BSV_SPECIFIC_V
581: WHERE ledger_id = p_ledger_id
582: AND (legal_entity_id = p_le_id or legal_entity_id is null);
583: l_bal_seg_value VARCHAR2(25);
584: l_first BOOLEAN;

Line 646: from GL_LEDGER_LE_BSV_SPECIFIC_V

642: using p_ccid;
643:
644: Select COUNT(*)
645: INTO l_count
646: from GL_LEDGER_LE_BSV_SPECIFIC_V
647: where segment_value = l_bal_seg_value
648: and ledger_id = p_ledger_id
649: and (legal_entity_id = p_le_id or legal_entity_id is null);
650: