APPS.FUN_PERIOD_STATUS_PKG dependencies on FUN_TRX_TYPES_VL

Line 1417: select trx_type_id from fun_trx_types_vl v

1413: and trx_type_id = c_trx_type
1414: AND fps.inteco_calendar=nvl(fso.inteco_calendar,'~~')
1415: AND fps.inteco_period_type=nvl(fso.inteco_period_type,'~~');
1416: CURSOR c_inexist_fun_trx(c_per_year number,c_per_name varchar2 ) IS
1417: select trx_type_id from fun_trx_types_vl v
1418: where not exists
1419: ( select fps.trx_type_id from fun_period_statuses fps,fun_system_options fso
1420: WHERE fps.inteco_calendar=nvl(fso.inteco_calendar,'~~')
1421: AND fps.inteco_period_type=nvl(fso.inteco_period_type,'~~') and fps.period_year = c_per_year

Line 1541: fun_trx_types_vl ftt

1537: FROM fun_system_options fso;
1538: CURSOR c_select_status IS
1539: select fps.status
1540: from fun_period_statuses fps,fun_system_options fso,
1541: fun_trx_types_vl ftt
1542: where trunc(p_date) between fps.start_date and fps.end_date
1543: and fps.trx_type_id = ftt.trx_type_id
1544: and ftt.trx_type_id = p_trx_type_id
1545: AND fps.inteco_calendar=nvl(fso.inteco_calendar,'~~')