882: BEGIN
883: --Check for the Validity of the SGL Account
884: SELECT ussgl_enabled_flag
885: INTO l_enabled_flag
886: FROM fv_facts_ussgl_accounts
887: WHERE ussgl_account = p_gl_account_num;
888: IF l_enabled_flag <> 'Y' THEN
889: -- SGL Account is not Enabled
890: p_valid_flag :='N' ;
906: AND flex_value_set_id = gbl_gl_acc_value_set_id
907: AND parent_flex_value <> 'T'
908: AND parent_flex_value IN
909: (SELECT ussgl_account
910: FROM fv_facts_ussgl_accounts
911: WHERE ussgl_account = parent_flex_value
912: AND ussgl_enabled_flag ='Y'
913: )
914: ;