APPS.FV_GTAS_TRX_REGISTER dependencies on FV_FACTS_USSGL_ACCOUNTS

Line 1596: l_ussgl_enabled fv_facts_ussgl_accounts.ussgl_enabled_flag%TYPE;

1592: l_authority_type_val VARCHAR2(1);
1593: l_tp_agency_id VARCHAR2(3);
1594: l_tp_main_acct VARCHAR2(4);
1595: l_budget_impact_ind VARCHAR2(1);
1596: l_ussgl_enabled fv_facts_ussgl_accounts.ussgl_enabled_flag%TYPE;
1597: l_main_acct VARCHAR2(4);
1598:
1599:
1600: BEGIN

Line 2327: FROM fv_facts_ussgl_accounts

2323: --If it does not exist, get the parent account
2324: BEGIN
2325: SELECT 'X', ussgl_enabled_flag
2326: INTO l_exists, l_ussgl_enabled
2327: FROM fv_facts_ussgl_accounts
2328: WHERE ussgl_account = l_account_number;
2329:
2330: IF l_ussgl_enabled = 'N' THEN
2331: fv_utility.log_mesg(l_module,

Line 4379: FROM fv_facts_ussgl_accounts

4375: SELECT ussgl_enabled_flag,
4376: reporting_type
4377: INTO l_enabled_flag,
4378: l_reporting_type
4379: FROM fv_facts_ussgl_accounts
4380: WHERE ussgl_account = p_ussgl_acct_num;
4381:
4382: p_enabled_flag := l_enabled_flag;
4383: p_reporting_type := l_reporting_type;

Line 4746: FROM fv_facts_ussgl_accounts

4742: AND parent_flex_value <> 'T'
4743: AND flex_value_set_id = g_acc_value_set_id
4744: AND SUBSTR(parent_flex_value,1,6) IN
4745: (SELECT ussgl_account
4746: FROM fv_facts_ussgl_accounts
4747: WHERE ussgl_account = SUBSTR(parent_flex_value,1,6)
4748: AND ussgl_enabled_flag = 'Y')
4749: AND parent_flex_value IN
4750: (