DBA Data[Home] [Help]

APPS.FV_UPG_FACTS_EB_TO_GTAS dependencies on FV_FACTS_ATTRIBUTES

Line 677: l_authority_type_code fv_facts_attributes.authority_type%TYPE;

673: l_ussgl_acct_number fv_gtas_attributes.ussgl_acct_number%TYPE;
674: l_fed_non_fed VARCHAR2(1);
675: l_aid VARCHAR2(3);
676: l_main_account VARCHAR2(4);
677: l_authority_type_code fv_facts_attributes.authority_type%TYPE;
678:
679: l_module VARCHAR2(200) := g_module || 'PROCESS_FACTS2_EB.';
680: l_code_exists VARCHAR2(1) := 'N';
681: BEGIN

Line 721: FROM fv_facts_attributes

717: l_authority_type_code := NULL;
718:
719: SELECT authority_type
720: INTO l_authority_type_code
721: FROM fv_facts_attributes
722: WHERE set_of_books_id = fed_acct_rec.set_of_books_id
723: AND facts_acct_number = fed_acct_rec.account_number;
724:
725: EXCEPTION

Line 1065: FROM fv_facts_attributes

1061: BEGIN
1062:
1063: SELECT authority_type
1064: INTO l_authority_type_code
1065: FROM fv_facts_attributes
1066: WHERE set_of_books_id = acct_rec.set_of_books_id
1067: AND facts_acct_number = acct_rec.account_number;
1068:
1069: EXCEPTION