APPS.FV_FACTS1_PKG dependencies on FV_FACTS_USSGL_ACCOUNTS

Line 1158: FROM fv_facts_ussgl_accounts

1154: AND flex_value_set_id = gbl_acc_value_set_id
1155: AND parent_flex_value <> 'T'
1156: AND parent_flex_value IN
1157: (SELECT ussgl_account
1158: FROM fv_facts_ussgl_accounts
1159: WHERE ussgl_account = parent_flex_value);
1160:
1161: -- fnd_file.put_line(fnd_file.log , 'Parent and USSGL found for ' || p_acct_num || ' as ' || l_ussgl_acct_num);
1162: -- Parent Found. Perform Validations

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

1343: END;
1344: END IF; -- End IF of l_exists
1345:
1346: ELSE -- Else for l_ussgl_enabled IS NOT NULL
1347: -- Parent not exist in FV_FACTS_USSGL_ACCOUNTS table.
1348: -- Raise the Exception NON_USSGL_ACCT
1349: --fnd_file.put_line(fnd_file.log , 'NO USSGL FOUND found for'
1350: --||p_acct_num||' So returning with NON_USSGL_ACCT');
1351:

Line 1486: FROM fv_facts_ussgl_accounts

1482: --FV_UTILITY.LOG_MESG('In '||l_module_name);
1483:
1484: SELECT ussgl_enabled_flag, reporting_type
1485: INTO p_enabled_flag, p_reporting_type
1486: FROM fv_facts_ussgl_accounts
1487: WHERE ussgl_account = p_ussgl_acct_num;
1488:
1489: EXCEPTION
1490: WHEN NO_DATA_FOUND THEN NULL;

Line 3250: FROM fv_facts_ussgl_accounts

3246: AND flex_value_set_id = gbl_acc_value_set_id
3247: AND parent_flex_value <> 'T'
3248: AND parent_flex_value IN
3249: (SELECT ussgl_account
3250: FROM fv_facts_ussgl_accounts
3251: WHERE ussgl_account = parent_flex_value);
3252:
3253: gbl_parent_flag := 'N';
3254: