APPS.FV_GTAS_TRX_REGISTER dependencies on FV_BE_TRX_SUB_TYPES

Line 5768: l_sub_type fv_be_trx_sub_types.sub_type%TYPE;

5764: AND xh.entity_id = xte.entity_id;
5765:
5766: l_be_trx_id NUMBER;
5767: l_trx_type_id NUMBER;
5768: l_sub_type fv_be_trx_sub_types.sub_type%TYPE;
5769: l_authority_type_code fv_gtas_attributes.authority_type1%TYPE;
5770: l_authority_type_code_sub fv_gtas_attributes.authority_type1%TYPE;
5771: l_authority_type_code_trx fv_gtas_attributes.authority_type1%TYPE;
5772: l_authority_type_code_tmp fv_gtas_attributes.authority_type1%TYPE;

Line 5829: FROM fv_be_trx_sub_types bs

5825:
5826: IF l_sub_type IS NOT NULL THEN
5827: SELECT authority_type
5828: INTO l_authority_type_code_sub
5829: FROM fv_be_trx_sub_types bs
5830: WHERE bs.be_tt_id = l_trx_type_id
5831: AND bs.sub_type = l_sub_type
5832: AND bs.ledger_id = g_set_of_books_id;
5833: log(l_module,'Sub Type Authority Type: '||l_authority_type_code_sub);