APPS.FV_FACTS_TBAL_TRX dependencies on FV_BE_TRX_DTLS

Line 1548: FROM fv_be_trx_dtls

1544:
1545: BEGIN
1546: SELECT public_law_code
1547: INTO va_public_law_code_val
1548: FROM fv_be_trx_dtls
1549: WHERE transaction_id = vl_legis_ref
1550: AND set_of_books_id = vp_set_of_books_id ;
1551: If va_public_law_code_val is NULL Then
1552: -- Create Exception

Line 1596: FROM fv_be_trx_dtls

1592: IF vl_legis_ref IS NOT NULL THEN
1593: BEGIN
1594: SELECT advance_type
1595: INTO va_advance_type_val
1596: FROM fv_be_trx_dtls
1597: WHERE transaction_id = vl_legis_ref
1598: AND set_of_books_id = vp_set_of_books_id ;
1599: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1600: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

Line 1632: FROM fv_be_trx_dtls

1628: IF vl_legis_ref IS NOT NULL THEN
1629: BEGIN
1630: SELECT dept_id, main_account
1631: INTO va_transfer_dept_id, va_transfer_main_acct
1632: FROM fv_be_trx_dtls
1633: WHERE transaction_id = vl_legis_ref
1634: AND set_of_books_id = vp_set_of_books_id ;
1635: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1636: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,