DBA Data[Home] [Help]

APPS.CE_BANK_ACCT_BALANCE_REPORT dependencies on CE_LE_BG_OU_VS_V

Line 509: from CE_LE_BG_OU_VS_V

505: -- get legal entity name
506: if p_legal_entity_id is not null then
507: select name
508: into l_legal_entity_name
509: from CE_LE_BG_OU_VS_V
510: where legal_entity_id = p_legal_entity_id and organization_type = 'LEGAL_ENTITY';
511: end if;
512: CEP_STANDARD.init_security; -- Bug 8620223
513: -- loop through all currencies to generate the XML node BankAccttGroupByCurrency

Line 1091: from CE_LE_BG_OU_VS_V

1087:
1088: if p_legal_entity_id is not null then
1089: select name
1090: into l_legal_entity_name
1091: from CE_LE_BG_OU_VS_V
1092: where legal_entity_id = p_legal_entity_id and organization_type = 'LEGAL_ENTITY';
1093: end if;
1094:
1095: if (p_from_date is not null) and p_to_date is not null and p_from_date > p_to_date then

Line 1266: from CE_LE_BG_OU_VS_V

1262:
1263: if p_legal_entity_id is not null then
1264: select name
1265: into l_legal_entity_name
1266: from CE_LE_BG_OU_VS_V
1267: where legal_entity_id = p_legal_entity_id and organization_type = 'LEGAL_ENTITY';
1268: end if;
1269:
1270: if (p_from_date is not null) and p_to_date is not null and p_from_date > p_to_date then