APPS.FV_GTAS_INTERFACE dependencies on FV_FACTS_USSGL_ACCOUNTS

Line 782: --Check if USSGL account is defined and enabled in FV_FACTS_USSGL_ACCOUNTS

778: -- number or parent for getting attributes.
779: -- Verify whether the account number exists in FV_GTAS_ATTRIBUTES table
780: -- Validate the USSGL Account Number
781: Gbl_Error_Code := 0;
782: --Check if USSGL account is defined and enabled in FV_FACTS_USSGL_ACCOUNTS
783: GET_USSGL_INFO(p_acct_num, l_ussgl_enabled,l_ussgl_not_found);
784:
785: IF L_Ussgl_Enabled Is Not Null and L_Ussgl_Enabled = 'N' THEN
786: p_exception_category:= 'USSGL_DISABLED';

Line 818: From Fv_Facts_Ussgl_Accounts

814: AND flex_value_set_id = gbl_acc_value_set_id
815: AND parent_flex_value <> 'T'
816: AND SUBSTR(parent_flex_value,1,6) IN
817: (SELECT ussgl_account
818: From Fv_Facts_Ussgl_Accounts
819: Where Ussgl_Account = SUBSTR(Parent_Flex_Value,1,6))
820: AND parent_flex_value IN
821: (
822: SELECT flex_value

Line 1663: FROM fv_facts_ussgl_accounts

1659: log(l_module_name, 'Inside get ussgl info p_ussgl_acct_num'|| p_ussgl_acct_num);
1660:
1661: SELECT ussgl_enabled_flag
1662: INTO p_enabled_flag
1663: FROM fv_facts_ussgl_accounts
1664: Where Ussgl_Account = P_Ussgl_Acct_Num;
1665: EXCEPTION
1666: When No_Data_Found Then
1667: p_acct_not_found := 'Y';

Line 2834: FROM fv_facts_ussgl_accounts

2830: AND flex_value_set_id = gbl_acc_value_set_id
2831: AND parent_flex_value <> 'T'
2832: AND SUBSTR(parent_flex_value,1,6) IN
2833: (SELECT ussgl_account
2834: FROM fv_facts_ussgl_accounts
2835: WHERE ussgl_account = SUBSTR(parent_flex_value,1,6))
2836: AND parent_flex_value IN
2837: (
2838: SELECT flex_value

Line 2987: FROM fv_facts_ussgl_accounts

2983: AND flex_value_set_id = gbl_acc_value_set_id
2984: AND parent_flex_value <> 'T'
2985: AND SUBSTR(parent_flex_value,1,6) IN
2986: (SELECT ussgl_account
2987: FROM fv_facts_ussgl_accounts
2988: WHERE ussgl_account = SUBSTR(parent_flex_value,1,6))
2989: AND parent_flex_value IN
2990: (
2991: SELECT flex_value