APPS.FV_IPAC dependencies on FV_FACTS_USSGL_ACCOUNTS

Line 902: FROM fv_facts_ussgl_accounts

898: BEGIN
899: --Check for the Validity of the SGL Account
900: SELECT ussgl_enabled_flag
901: INTO l_enabled_flag
902: FROM fv_facts_ussgl_accounts
903: WHERE ussgl_account = p_gl_account_num;
904: IF l_enabled_flag <> 'Y' THEN
905: -- SGL Account is not Enabled
906: p_valid_flag :='N' ;

Line 926: FROM fv_facts_ussgl_accounts

922: AND flex_value_set_id = gbl_gl_acc_value_set_id
923: AND parent_flex_value <> 'T'
924: AND parent_flex_value IN
925: (SELECT ussgl_account
926: FROM fv_facts_ussgl_accounts
927: WHERE ussgl_account = parent_flex_value
928: AND ussgl_enabled_flag ='Y'
929: )
930: ;