DBA Data[Home] [Help]

APPS.FV_GTAS_GL_PKG dependencies on FV_BE_TRX_SUB_TYPES

Line 1097: l_sub_type fv_be_trx_sub_types.sub_type%TYPE;

1093: AND xh.entity_id = xte.entity_id;
1094:
1095: l_be_trx_id NUMBER;
1096: l_trx_type_id NUMBER;
1097: l_sub_type fv_be_trx_sub_types.sub_type%TYPE;
1098: l_authority_type_code fv_gtas_attributes.authority_type1%TYPE;
1099: l_authority_type_code_sub fv_gtas_attributes.authority_type1%TYPE;
1100: l_authority_type_code_trx fv_gtas_attributes.authority_type1%TYPE;
1101: l_authority_type_code_tmp fv_gtas_attributes.authority_type1%TYPE;

Line 1158: FROM fv_be_trx_sub_types bs

1154:
1155: IF l_sub_type IS NOT NULL THEN
1156: SELECT authority_type
1157: INTO l_authority_type_code_sub
1158: FROM fv_be_trx_sub_types bs
1159: WHERE bs.be_tt_id = l_trx_type_id
1160: AND bs.sub_type = l_sub_type
1161: AND bs.ledger_id = gbl_sob_id;
1162: log(l_module_name,'Sub Type Authority Type: '||l_authority_type_code_sub);