APPS.FV_FACTS1_PKG dependencies on FV_FACTS_USSGL_ACCOUNTS

Line 1171: FROM fv_facts_ussgl_accounts

1167: AND flex_value_set_id = gbl_acc_value_set_id
1168: AND parent_flex_value <> 'T'
1169: AND parent_flex_value IN
1170: (SELECT ussgl_account
1171: FROM fv_facts_ussgl_accounts
1172: WHERE ussgl_account = parent_flex_value);
1173:
1174: -- fnd_file.put_line(fnd_file.log , 'Parent and USSGL found for ' || p_acct_num || ' as ' || l_ussgl_acct_num);
1175: -- Parent Found. Perform Validations

Line 1374: -- Parent not exist in FV_FACTS_USSGL_ACCOUNTS table.

1370: END;
1371: END IF; -- End IF of l_exists
1372:
1373: ELSE -- Else for l_ussgl_enabled IS NOT NULL
1374: -- Parent not exist in FV_FACTS_USSGL_ACCOUNTS table.
1375: -- Raise the Exception NON_USSGL_ACCT
1376: --fnd_file.put_line(fnd_file.log , 'NO USSGL FOUND found for'
1377: --||p_acct_num||' So returning with NON_USSGL_ACCT');
1378:

Line 1513: FROM fv_facts_ussgl_accounts

1509: --FV_UTILITY.LOG_MESG('In '||l_module_name);
1510:
1511: SELECT ussgl_enabled_flag, reporting_type
1512: INTO p_enabled_flag, p_reporting_type
1513: FROM fv_facts_ussgl_accounts
1514: WHERE ussgl_account = p_ussgl_acct_num;
1515:
1516: EXCEPTION
1517: WHEN NO_DATA_FOUND THEN NULL;

Line 3328: FROM fv_facts_ussgl_accounts

3324: AND flex_value_set_id = gbl_acc_value_set_id
3325: AND parent_flex_value <> 'T'
3326: AND parent_flex_value IN
3327: (SELECT ussgl_account
3328: FROM fv_facts_ussgl_accounts
3329: WHERE ussgl_account = parent_flex_value);
3330:
3331: gbl_parent_flag := 'N';
3332: