DBA Data[Home] [Help] [Dependency Information]


VIEW: APPS.IGF_AP_CSS_FNAR

Object Details
Object Name: IGF_AP_CSS_FNAR
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGF.IGF_AP_CSS_FNAR
Subobject Name:
Status: VALID

View Type

A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.


Retrieves the Financial Need Analysis Report related information.This comes along with college board's profile information.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
FNAR_ID NUMBER (15) Yes
CSSP_ID NUMBER (15) Yes
R_S_EMAIL_ADDRESS VARCHAR2 (30)
EPS_CODE VARCHAR2 (4)
COMP_CSS_DEPENDENCY_STATUS VARCHAR2 (30)
STU_AGE VARCHAR2 (2)
ASSUMED_STU_YR_IN_COLL VARCHAR2 (30)
COMP_STU_MARITAL_STATUS VARCHAR2 (30)
STU_FAMILY_MEMBERS NUMBER (15)
STU_FAM_MEMBERS_IN_COLLEGE NUMBER (15)
PAR_MARITAL_STATUS VARCHAR2 (30)
PAR_FAMILY_MEMBERS NUMBER (15)
PAR_TOTAL_IN_COLLEGE NUMBER (15)
PAR_PAR_IN_COLLEGE NUMBER (15)
PAR_OTHERS_IN_COLLEGE NUMBER (15)
PAR_AESA NUMBER (15)
PAR_CESA NUMBER (15)
STU_AESA NUMBER (15)
STU_CESA NUMBER (15)
IM_P_BAS_AGI_TAXABLE_INCOME NUMBER (15)
IM_P_BAS_UNTX_INC_AND_BEN NUMBER (15)
IM_P_BAS_INC_ADJ NUMBER (15)
IM_P_BAS_TOTAL_INCOME NUMBER (15)
IM_P_BAS_US_INCOME_TAX NUMBER (15)
IM_P_BAS_ST_AND_OTHER_TAX NUMBER (15)
IM_P_BAS_FICA_TAX NUMBER (15)
IM_P_BAS_MED_DENTAL NUMBER (15)
IM_P_BAS_EMPLOYMENT_ALLOW NUMBER (15)
IM_P_BAS_ANNUAL_ED_SAVINGS NUMBER (15)
IM_P_BAS_INC_PROT_ALLOW_M NUMBER (15)
IM_P_BAS_TOTAL_INC_ALLOW NUMBER (15)
IM_P_BAS_CAL_AVAIL_INC NUMBER (15)
IM_P_BAS_AVAIL_INCOME NUMBER (15)
IM_P_BAS_TOTAL_CONT_INC NUMBER (15)
IM_P_BAS_CASH_BANK_ACCOUNTS NUMBER (15)
IM_P_BAS_HOME_EQUITY NUMBER (15)
IM_P_BAS_OT_RL_EST_INV_EQ NUMBER (15)
IM_P_BAS_ADJ_BUS_FARM_WORTH NUMBER (15)
IM_P_BAS_ASS_SIBS_PRE_TUI NUMBER (15)
IM_P_BAS_NET_WORTH NUMBER (15)
IM_P_BAS_EMERG_RES_ALLOW NUMBER (15)
IM_P_BAS_CUM_ED_SAVINGS NUMBER (15)
IM_P_BAS_LOW_INC_ALLOW NUMBER (15)
IM_P_BAS_TOTAL_ASSET_ALLOW NUMBER (15)
IM_P_BAS_DISC_NET_WORTH NUMBER (15)
IM_P_BAS_TOTAL_CONT_ASSET NUMBER (15)
IM_P_BAS_TOTAL_CONT NUMBER (15)
IM_P_BAS_NUM_IN_COLL_ADJ NUMBER (12)
IM_P_BAS_CONT_FOR_STU NUMBER (15)
IM_P_BAS_CONT_FROM_INCOME NUMBER (15)
IM_P_BAS_CONT_FROM_ASSETS NUMBER (15)
IM_P_OPT_AGI_TAXABLE_INCOME NUMBER (15)
IM_P_OPT_UNTX_INC_AND_BEN NUMBER (15)
IM_P_OPT_INC_ADJ NUMBER (15)
IM_P_OPT_TOTAL_INCOME NUMBER (15)
IM_P_OPT_US_INCOME_TAX NUMBER (15)
IM_P_OPT_ST_AND_OTHER_TAX NUMBER (15)
IM_P_OPT_FICA_TAX NUMBER (15)
IM_P_OPT_MED_DENTAL NUMBER (15)
IM_P_OPT_ELEM_SEC_TUIT NUMBER (15)
IM_P_OPT_EMPLOYMENT_ALLOW NUMBER (15)
IM_P_OPT_ANNUAL_ED_SAVINGS NUMBER (15)
IM_P_OPT_INC_PROT_ALLOW_M NUMBER (15)
IM_P_OPT_TOTAL_INC_ALLOW NUMBER (15)
IM_P_OPT_CAL_AVAIL_INC NUMBER (15)
IM_P_OPT_AVAIL_INCOME NUMBER (15)
IM_P_OPT_TOTAL_CONT_INC NUMBER (15)
IM_P_OPT_CASH_BANK_ACCOUNTS NUMBER (15)
IM_P_OPT_HOME_EQUITY NUMBER (15)
IM_P_OPT_OT_RL_EST_INV_EQ NUMBER (15)
IM_P_OPT_ADJ_BUS_FARM_WORTH NUMBER (15)
IM_P_OPT_ASS_SIBS_PRE_TUI NUMBER (15)
IM_P_OPT_NET_WORTH NUMBER (15)
IM_P_OPT_EMERG_RES_ALLOW NUMBER (15)
IM_P_OPT_CUM_ED_SAVINGS NUMBER (15)
IM_P_OPT_LOW_INC_ALLOW NUMBER (15)
IM_P_OPT_TOTAL_ASSET_ALLOW NUMBER (15)
IM_P_OPT_DISC_NET_WORTH NUMBER (15)
IM_P_OPT_TOTAL_CONT_ASSET NUMBER (15)
IM_P_OPT_TOTAL_CONT NUMBER (15)
IM_P_OPT_NUM_IN_COLL_ADJ NUMBER (15)
IM_P_OPT_CONT_FOR_STU NUMBER (15)
IM_P_OPT_CONT_FROM_INCOME NUMBER (15)
IM_P_OPT_CONT_FROM_ASSETS NUMBER (15)
FM_P_ANALYSIS_TYPE VARCHAR2 (30)
FM_P_AGI_TAXABLE_INCOME NUMBER (15)
FM_P_UNTX_INC_AND_BEN NUMBER (15)
FM_P_INC_ADJ NUMBER (15)
FM_P_TOTAL_INCOME NUMBER (15)
FM_P_US_INCOME_TAX NUMBER (15)
FM_P_STATE_AND_OTHER_TAXES NUMBER (15)
FM_P_FICA_TAX NUMBER (15)
FM_P_EMPLOYMENT_ALLOW NUMBER (15)
FM_P_INCOME_PROT_ALLOW NUMBER (15)
FM_P_TOTAL_ALLOW NUMBER (15)
FM_P_AVAIL_INCOME NUMBER (15)
FM_P_CASH_BANK_ACCOUNTS NUMBER (15)
FM_P_OT_RL_EST_INV_EQUITY NUMBER (15)
FM_P_ADJ_BUS_FARM_NET_WORTH NUMBER (15)
FM_P_NET_WORTH NUMBER (15)
FM_P_ASSET_PROT_ALLOW NUMBER (15)
FM_P_DISC_NET_WORTH NUMBER (15)
FM_P_TOTAL_CONTRIBUTION NUMBER (15)
FM_P_NUM_IN_COLL NUMBER (15)
FM_P_CONT_FOR_STU NUMBER (15)
FM_P_CONT_FROM_INCOME NUMBER (15)
FM_P_CONT_FROM_ASSETS NUMBER (15)
IM_S_BAS_AGI_TAXABLE_INCOME NUMBER (15)
IM_S_BAS_UNTX_INC_AND_BEN NUMBER (15)
IM_S_BAS_INC_ADJ NUMBER (15)
IM_S_BAS_TOTAL_INCOME NUMBER (15)
IM_S_BAS_US_INCOME_TAX NUMBER (15)
IM_S_BAS_STATE_AND_OTH_TAXES NUMBER (15)
IM_S_BAS_FICA_TAX NUMBER (15)
IM_S_BAS_MED_DENTAL NUMBER (15)
IM_S_BAS_EMPLOYMENT_ALLOW NUMBER (15)
IM_S_BAS_ANNUAL_ED_SAVINGS NUMBER (15)
IM_S_BAS_INC_PROT_ALLOW_M NUMBER (15)
IM_S_BAS_TOTAL_INC_ALLOW NUMBER (15)
IM_S_BAS_CAL_AVAIL_INCOME NUMBER (15)
IM_S_BAS_AVAIL_INCOME NUMBER (15)
IM_S_BAS_TOTAL_CONT_INC NUMBER (15)
IM_S_BAS_CASH_BANK_ACCOUNTS NUMBER (15)
IM_S_BAS_HOME_EQUITY NUMBER (15)
IM_S_BAS_OT_RL_EST_INV_EQ NUMBER (15)
IM_S_BAS_ADJ_BUSFARM_WORTH NUMBER (15)
IM_S_BAS_TRUSTS NUMBER (15)
IM_S_BAS_NET_WORTH NUMBER (15)
IM_S_BAS_EMERG_RES_ALLOW NUMBER (15)
IM_S_BAS_CUM_ED_SAVINGS NUMBER (15)
IM_S_BAS_TOTAL_ASSET_ALLOW NUMBER (15)
IM_S_BAS_DISC_NET_WORTH NUMBER (15)
IM_S_BAS_TOTAL_CONT_ASSET NUMBER (15)
IM_S_BAS_TOTAL_CONT NUMBER (15)
IM_S_BAS_NUM_IN_COLL_ADJ NUMBER (13)
IM_S_BAS_CONT_FOR_STU NUMBER (15)
IM_S_BAS_CONT_FROM_INCOME NUMBER (15)
IM_S_BAS_CONT_FROM_ASSETS NUMBER (15)
IM_S_EST_AGITAXABLE_INCOME NUMBER (15)
IM_S_EST_UNTX_INC_AND_BEN NUMBER (15)
IM_S_EST_INC_ADJ NUMBER (15)
IM_S_EST_TOTAL_INCOME NUMBER (15)
IM_S_EST_US_INCOME_TAX NUMBER (15)
IM_S_EST_STATE_AND_OTH_TAXES NUMBER (15)
IM_S_EST_FICA_TAX NUMBER (15)
IM_S_EST_MED_DENTAL NUMBER (15)
IM_S_EST_EMPLOYMENT_ALLOW NUMBER (15)
IM_S_EST_ANNUAL_ED_SAVINGS NUMBER (15)
IM_S_EST_INC_PROT_ALLOW_M NUMBER (15)
IM_S_EST_TOTAL_INC_ALLOW NUMBER (15)
IM_S_EST_CAL_AVAIL_INCOME NUMBER (15)
IM_S_EST_AVAIL_INCOME NUMBER (15)
IM_S_EST_TOTAL_CONT_INC NUMBER (15)
IM_S_EST_CASH_BANK_ACCOUNTS NUMBER (15)
IM_S_EST_HOME_EQUITY NUMBER (15)
IM_S_EST_OT_RL_EST_INV_EQ NUMBER (15)
IM_S_EST_ADJ_BUS_FARM_WORTH NUMBER (15)
IM_S_EST_EST_TRUSTS NUMBER (15)
IM_S_EST_NET_WORTH NUMBER (15)
IM_S_EST_EMERG_RES_ALLOW NUMBER (15)
IM_S_EST_CUM_ED_SAVINGS NUMBER (15)
IM_S_EST_TOTAL_ASSET_ALLOW NUMBER (15)
IM_S_EST_DISC_NET_WORTH NUMBER (15)
IM_S_EST_TOTAL_CONT_ASSET NUMBER (15)
IM_S_EST_TOTAL_CONT NUMBER (15)
IM_S_EST_NUM_IN_COLL_ADJ NUMBER (13)
IM_S_EST_CONT_FOR_STU NUMBER (15)
IM_S_EST_CONT_FROM_INCOME NUMBER (15)
IM_S_EST_CONT_FROM_ASSETS NUMBER (15)
IM_S_OPT_AGI_TAXABLE_INCOME NUMBER (15)
IM_S_OPT_UNTX_INC_AND_BEN NUMBER (15)
IM_S_OPT_INC_ADJ NUMBER (15)
IM_S_OPT_TOTAL_INCOME NUMBER (15)
IM_S_OPT_US_INCOME_TAX NUMBER (15)
IM_S_OPT_STATE_AND_OTH_TAXES NUMBER (15)
IM_S_OPT_FICA_TAX NUMBER (15)
IM_S_OPT_MED_DENTAL NUMBER (15)
IM_S_OPT_EMPLOYMENT_ALLOW NUMBER (15)
IM_S_OPT_ANNUAL_ED_SAVINGS NUMBER (15)
IM_S_OPT_INC_PROT_ALLOW_M NUMBER (15)
IM_S_OPT_TOTAL_INC_ALLOW NUMBER (15)
IM_S_OPT_CAL_AVAIL_INCOME NUMBER (15)
IM_S_OPT_AVAIL_INCOME NUMBER (15)
IM_S_OPT_TOTAL_CONT_INC NUMBER (15)
IM_S_OPT_CASH_BANK_ACCOUNTS NUMBER (15)
IM_S_OPT_IRA_KEOGH_ACCOUNTS NUMBER (15)
IM_S_OPT_HOME_EQUITY NUMBER (15)
IM_S_OPT_OT_RL_EST_INV_EQ NUMBER (15)
IM_S_OPT_ADJ_BUS_FARM_WORTH NUMBER (15)
IM_S_OPT_TRUSTS NUMBER (15)
IM_S_OPT_NET_WORTH NUMBER (15)
IM_S_OPT_EMERG_RES_ALLOW NUMBER (15)
IM_S_OPT_CUM_ED_SAVINGS NUMBER (15)
IM_S_OPT_TOTAL_ASSET_ALLOW NUMBER (15)
IM_S_OPT_DISC_NET_WORTH NUMBER (15)
IM_S_OPT_TOTAL_CONT_ASSET NUMBER (15)
IM_S_OPT_TOTAL_CONT NUMBER (15)
IM_S_OPT_NUM_IN_COLL_ADJ NUMBER (15)
IM_S_OPT_CONT_FOR_STU NUMBER (15)
IM_S_OPT_CONT_FROM_INCOME NUMBER (15)
IM_S_OPT_CONT_FROM_ASSETS NUMBER (15)
FM_S_ANALYSIS_TYPE VARCHAR2 (30)
FM_S_AGI_TAXABLE_INCOME NUMBER (15)
FM_S_UNTX_INC_AND_BEN NUMBER (15)
FM_S_INC_ADJ NUMBER (15)
FM_S_TOTAL_INCOME NUMBER (15)
FM_S_US_INCOME_TAX NUMBER (15)
FM_S_STATE_AND_OTH_TAXES NUMBER (15)
FM_S_FICA_TAX NUMBER (15)
FM_S_EMPLOYMENT_ALLOW NUMBER (15)
FM_S_INCOME_PROT_ALLOW NUMBER (15)
FM_S_TOTAL_ALLOW NUMBER (15)
FM_S_CAL_AVAIL_INCOME NUMBER (15)
FM_S_AVAIL_INCOME NUMBER (15)
FM_S_CASH_BANK_ACCOUNTS NUMBER (15)
FM_S_OT_RL_EST_INV_EQUITY NUMBER (15)
FM_S_ADJ_BUS_FARM_WORTH NUMBER (15)
FM_S_TRUSTS NUMBER (15)
FM_S_NET_WORTH NUMBER (15)
FM_S_ASSET_PROT_ALLOW NUMBER (15)
FM_S_DISC_NET_WORTH NUMBER (15)
FM_S_TOTAL_CONT NUMBER (15)
FM_S_NUM_IN_COLL NUMBER (15)
FM_S_CONT_FOR_STU NUMBER (15)
FM_S_CONT_FROM_INCOME NUMBER (15)
FM_S_CONT_FROM_ASSETS NUMBER (15)
IM_INST_RESIDENT_IND VARCHAR2 (30)
INSTITUTIONAL_1_BUDGET_NAME VARCHAR2 (7)
IM_INST_1_BUDGET_DURATION NUMBER (15)
IM_INST_1_TUITION_FEES NUMBER (15)
IM_INST_1_BOOKS_SUPPLIES NUMBER (15)
IM_INST_1_LIVING_EXPENSES NUMBER (15)
IM_INST_1_TOT_EXPENSES NUMBER (15)
IM_INST_1_TOT_STU_CONT NUMBER (15)
IM_INST_1_TOT_PAR_CONT NUMBER (15)
IM_INST_1_TOT_FAMILY_CONT NUMBER (15)
IM_INST_1_VA_BENEFITS NUMBER (15)
IM_INST_1_OT_CONT NUMBER (15)
IM_INST_1_EST_FINANCIAL_NEED NUMBER (15)
INSTITUTIONAL_2_BUDGET_NAME VARCHAR2 (7)
IM_INST_2_BUDGET_DURATION VARCHAR2 (2)
IM_INST_2_TUITION_FEES NUMBER (15)
IM_INST_2_BOOKS_SUPPLIES NUMBER (15)
IM_INST_2_LIVING_EXPENSES NUMBER (15)
IM_INST_2_TOT_EXPENSES NUMBER (15)
IM_INST_2_TOT_STU_CONT NUMBER (15)
IM_INST_2_TOT_PAR_CONT NUMBER (15)
IM_INST_2_TOT_FAMILY_CONT NUMBER (15)
IM_INST_2_VA_BENEFITS NUMBER (15)
IM_INST_2_EST_FINANCIAL_NEED NUMBER (15)
INSTITUTIONAL_3_BUDGET_NAME VARCHAR2 (7)
IM_INST_3_BUDGET_DURATION NUMBER (15)
IM_INST_3_TUITION_FEES NUMBER (15)
IM_INST_3_BOOKS_SUPPLIES NUMBER (15)
IM_INST_3_LIVING_EXPENSES NUMBER (15)
IM_INST_3_TOT_EXPENSES NUMBER (15)
IM_INST_3_TOT_STU_CONT NUMBER (15)
IM_INST_3_TOT_PAR_CONT NUMBER (15)
IM_INST_3_TOT_FAMILY_CONT NUMBER (15)
IM_INST_3_VA_BENEFITS NUMBER (15)
IM_INST_3_EST_FINANCIAL_NEED NUMBER (15)
FM_INST_1_FEDERAL_EFC VARCHAR2 (5)
FM_INST_1_VA_BENEFITS VARCHAR2 (5)
FM_INST_1_FED_ELIGIBILITY VARCHAR2 (5)
FM_INST_1_PELL VARCHAR2 (4)
OPTION_PAR_LOSS_ALLOW_IND VARCHAR2 (30)
OPTION_PAR_TUITION_IND VARCHAR2 (30)
OPTION_PAR_HOME_IND VARCHAR2 (30)
OPTION_PAR_HOME_VALUE VARCHAR2 (7)
OPTION_PAR_HOME_DEBT VARCHAR2 (7)
OPTION_STU_IRA_KEOGH_IND VARCHAR2 (30)
OPTION_STU_HOME_IND VARCHAR2 (30)
OPTION_STU_HOME_VALUE VARCHAR2 (6)
OPTION_STU_HOME_DEBT VARCHAR2 (6)
OPTION_STU_SUM_AY_INC_IND VARCHAR2 (30)
OPTION_PAR_HOPE_LL_CREDIT VARCHAR2 (30)
OPTION_STU_HOPE_LL_CREDIT VARCHAR2 (30)
OPTION_PAR_COLA_ADJ_IND VARCHAR2 (30)
Holds the option parent cost of living adjustment indicator
OPTION_PAR_STU_FA_ASSETS_IND VARCHAR2 (30)
Holds the option student assets treated as parents asset indicator
OPTION_PAR_IPT_ASSETS_IND VARCHAR2 (30)
Holds the option parent assets from interest and dividend income indicator
OPTION_STU_IPT_ASSETS_IND VARCHAR2 (30)
Holds the option student assets from interest and dividend income indicator
OPTION_PAR_COLA_ADJ_VALUE NUMBER (12)
Holds the option parent adjustment factor used to modify IPA and ERA
IM_PARENT_1_8_MONTHS_BAS VARCHAR2 (5)
IM_P_MORE_THAN_9_MTH_BA VARCHAR2 (5)
IM_PARENT_1_8_MONTHS_OPT VARCHAR2 (5)
IM_P_MORE_THAN_9_MTH_OP VARCHAR2 (5)
FNAR_MESSAGE_1 VARCHAR2 (30)
FNAR_MESSAGE_2 VARCHAR2 (30)
FNAR_MESSAGE_3 VARCHAR2 (30)
FNAR_MESSAGE_4 VARCHAR2 (30)
FNAR_MESSAGE_5 VARCHAR2 (30)
FNAR_MESSAGE_6 VARCHAR2 (30)
FNAR_MESSAGE_7 VARCHAR2 (30)
FNAR_MESSAGE_8 VARCHAR2 (30)
FNAR_MESSAGE_9 VARCHAR2 (30)
FNAR_MESSAGE_10 VARCHAR2 (30)
FNAR_MESSAGE_11 VARCHAR2 (30)
FNAR_MESSAGE_12 VARCHAR2 (30)
FNAR_MESSAGE_13 VARCHAR2 (30)
FNAR_MESSAGE_20 VARCHAR2 (30)
FNAR_MESSAGE_21 VARCHAR2 (30)
FNAR_MESSAGE_22 VARCHAR2 (30)
FNAR_MESSAGE_23 VARCHAR2 (30)
FNAR_MESSAGE_24 VARCHAR2 (30)
FNAR_MESSAGE_25 VARCHAR2 (30)
FNAR_MESSAGE_26 VARCHAR2 (30)
FNAR_MESSAGE_27 VARCHAR2 (30)
FNAR_MESSAGE_30 VARCHAR2 (30)
FNAR_MESSAGE_31 VARCHAR2 (30)
FNAR_MESSAGE_32 VARCHAR2 (30)
FNAR_MESSAGE_33 VARCHAR2 (30)
FNAR_MESSAGE_34 VARCHAR2 (30)
FNAR_MESSAGE_35 VARCHAR2 (30)
FNAR_MESSAGE_36 VARCHAR2 (30)
FNAR_MESSAGE_37 VARCHAR2 (30)
FNAR_MESSAGE_38 VARCHAR2 (30)
FNAR_MESSAGE_39 VARCHAR2 (30)
FNAR_MESSAGE_45 VARCHAR2 (30)
FNAR_MESSAGE_46 VARCHAR2 (30)
FNAR_MESSAGE_47 VARCHAR2 (30)
FNAR_MESSAGE_48 VARCHAR2 (30)
FNAR_MESSAGE_49 VARCHAR2 (30)
FNAR Message
FNAR_MESSAGE_50 VARCHAR2 (30)
FNAR_MESSAGE_51 VARCHAR2 (30)
FNAR_MESSAGE_52 VARCHAR2 (30)
FNAR_MESSAGE_53 VARCHAR2 (30)
FNAR_MESSAGE_55 VARCHAR2 (30)
FNAR Message
FNAR_MESSAGE_56 VARCHAR2 (30)
FNAR_MESSAGE_57 VARCHAR2 (30)
FNAR_MESSAGE_58 VARCHAR2 (30)
FNAR_MESSAGE_59 VARCHAR2 (30)
FNAR_MESSAGE_60 VARCHAR2 (30)
FNAR_MESSAGE_61 VARCHAR2 (30)
FNAR_MESSAGE_62 VARCHAR2 (30)
FNAR_MESSAGE_63 VARCHAR2 (30)
FNAR_MESSAGE_64 VARCHAR2 (30)
FNAR_MESSAGE_65 VARCHAR2 (30)
FNAR_MESSAGE_71 VARCHAR2 (30)
FNAR_MESSAGE_72 VARCHAR2 (30)
FNAR_MESSAGE_73 VARCHAR2 (30)
FNAR_MESSAGE_74 VARCHAR2 (30)
FNAR_MESSAGE_75 VARCHAR2 (30)
FNAR_MESSAGE_76 VARCHAR2 (30)
FNAR_MESSAGE_77 VARCHAR2 (30)
FNAR_MESSAGE_78 VARCHAR2 (30)
FNAR_MESG_10_STU_FAM_MEM VARCHAR2 (2)
FNAR_MESG_11_STU_NO_IN_COLL VARCHAR2 (30)
FNAR_MESG_24_STU_AVAIL_INC VARCHAR2 (7)
FNAR_MESG_26_STU_TAXES VARCHAR2 (6)
FNAR_MESG_33_STU_HOME_VALUE VARCHAR2 (6)
FNAR_MESG_34_STU_HOME_VALUE VARCHAR2 (6)
FNAR_MESG_34_STU_HOME_EQUITY VARCHAR2 (6)
FNAR_MESG_35_STU_HOME_VALUE VARCHAR2 (6)
FNAR_MESG_35_STU_HOME_EQUITY VARCHAR2 (6)
FNAR_MESG_36_STU_HOME_EQUITY VARCHAR2 (6)
FNAR_MESG_48_PAR_FAM_MEM VARCHAR2 (2)
FNAR_MESG_49_PAR_NO_IN_COLL VARCHAR2 (30)
FNAR_MESG_56_PAR_AGI VARCHAR2 (8)
FNAR_MESG_62_PAR_TAXES VARCHAR2 (7)
FNAR_MESG_73_PAR_HOME_VALUE VARCHAR2 (7)
FNAR_MESG_74_PAR_HOME_VALUE VARCHAR2 (7)
FNAR_MESG_74_PAR_HOME_EQUITY VARCHAR2 (7)
FNAR_MESG_75_PAR_HOME_VALUE VARCHAR2 (7)
FNAR_MESG_75_PAR_HOME_EQUITY VARCHAR2 (7)
FNAR_MESG_76_PAR_HOME_EQUITY VARCHAR2 (7)
ASSUMPTION_MESSAGE_1 VARCHAR2 (30)
ASSUMPTION_MESSAGE_2 VARCHAR2 (30)
ASSUMPTION_MESSAGE_3 VARCHAR2 (30)
ASSUMPTION_MESSAGE_4 VARCHAR2 (30)
ASSUMPTION_MESSAGE_5 VARCHAR2 (30)
ASSUMPTION_MESSAGE_6 VARCHAR2 (30)
RECORD_MARK VARCHAR2 (30)
LEGACY_RECORD_FLAG VARCHAR2 (1)
Indicates this student award record is imported through legacy import process
CREATION_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER (15) Yes
OPTION_IND_STU_IPT_ASSETS_FLAG VARCHAR2 (1)
Independent Student Assets from Interest and dividend income indicator
CUST_PARENT_CONT_ADJ_NUM NUMBER

Custodial Parent Contribution Adjustment
CUSTODIAL_PARENT_NUM NUMBER

Custodial Parent
CUST_PAR_BASE_PRCNT_INC_AMT NUMBER

Custodial Parent Base Percentage from Income
CUST_PAR_BASE_CONT_INC_AMT NUMBER

Custodial Parent Base Contribution from Income
CUST_PAR_BASE_CONT_AST_AMT NUMBER

Custodial Parent Base Contribution from Assets
CUST_PAR_BASE_TOT_CONT_AMT NUMBER

Custodial Parent Base Total Contribution
CUST_PAR_OPT_PRCNT_INC_AMT NUMBER

Custodial Parent Optional Percentage from Income
CUST_PAR_OPT_CONT_INC_AMT NUMBER

Custodial Parent Optional Contribution from Income
CUST_PAR_OPT_CONT_AST_AMT NUMBER

Custodial Parent Optional Contribution from Assets
CUST_PAR_OPT_TOT_CONT_AMT NUMBER

Custodial Parent Optional Total Contribution
PARENTS_EMAIL_TXT VARCHAR2 (50)
Parent's Email
PARENT_1_BIRTH_DATE DATE

Parent 1 Date of Birth
PARENT_2_BIRTH_DATE DATE

Parent 2 Date of Birth
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ROW_ID
,      FNAR_ID
,      CSSP_ID
,      R_S_EMAIL_ADDRESS
,      EPS_CODE
,      COMP_CSS_DEPENDENCY_STATUS
,      STU_AGE
,      ASSUMED_STU_YR_IN_COLL
,      COMP_STU_MARITAL_STATUS
,      STU_FAMILY_MEMBERS
,      STU_FAM_MEMBERS_IN_COLLEGE
,      PAR_MARITAL_STATUS
,      PAR_FAMILY_MEMBERS
,      PAR_TOTAL_IN_COLLEGE
,      PAR_PAR_IN_COLLEGE
,      PAR_OTHERS_IN_COLLEGE
,      PAR_AESA
,      PAR_CESA
,      STU_AESA
,      STU_CESA
,      IM_P_BAS_AGI_TAXABLE_INCOME
,      IM_P_BAS_UNTX_INC_AND_BEN
,      IM_P_BAS_INC_ADJ
,      IM_P_BAS_TOTAL_INCOME
,      IM_P_BAS_US_INCOME_TAX
,      IM_P_BAS_ST_AND_OTHER_TAX
,      IM_P_BAS_FICA_TAX
,      IM_P_BAS_MED_DENTAL
,      IM_P_BAS_EMPLOYMENT_ALLOW
,      IM_P_BAS_ANNUAL_ED_SAVINGS
,      IM_P_BAS_INC_PROT_ALLOW_M
,      IM_P_BAS_TOTAL_INC_ALLOW
,      IM_P_BAS_CAL_AVAIL_INC
,      IM_P_BAS_AVAIL_INCOME
,      IM_P_BAS_TOTAL_CONT_INC
,      IM_P_BAS_CASH_BANK_ACCOUNTS
,      IM_P_BAS_HOME_EQUITY
,      IM_P_BAS_OT_RL_EST_INV_EQ
,      IM_P_BAS_ADJ_BUS_FARM_WORTH
,      IM_P_BAS_ASS_SIBS_PRE_TUI
,      IM_P_BAS_NET_WORTH
,      IM_P_BAS_EMERG_RES_ALLOW
,      IM_P_BAS_CUM_ED_SAVINGS
,      IM_P_BAS_LOW_INC_ALLOW
,      IM_P_BAS_TOTAL_ASSET_ALLOW
,      IM_P_BAS_DISC_NET_WORTH
,      IM_P_BAS_TOTAL_CONT_ASSET
,      IM_P_BAS_TOTAL_CONT
,      IM_P_BAS_NUM_IN_COLL_ADJ
,      IM_P_BAS_CONT_FOR_STU
,      IM_P_BAS_CONT_FROM_INCOME
,      IM_P_BAS_CONT_FROM_ASSETS
,      IM_P_OPT_AGI_TAXABLE_INCOME
,      IM_P_OPT_UNTX_INC_AND_BEN
,      IM_P_OPT_INC_ADJ
,      IM_P_OPT_TOTAL_INCOME
,      IM_P_OPT_US_INCOME_TAX
,      IM_P_OPT_ST_AND_OTHER_TAX
,      IM_P_OPT_FICA_TAX
,      IM_P_OPT_MED_DENTAL
,      IM_P_OPT_ELEM_SEC_TUIT
,      IM_P_OPT_EMPLOYMENT_ALLOW
,      IM_P_OPT_ANNUAL_ED_SAVINGS
,      IM_P_OPT_INC_PROT_ALLOW_M
,      IM_P_OPT_TOTAL_INC_ALLOW
,      IM_P_OPT_CAL_AVAIL_INC
,      IM_P_OPT_AVAIL_INCOME
,      IM_P_OPT_TOTAL_CONT_INC
,      IM_P_OPT_CASH_BANK_ACCOUNTS
,      IM_P_OPT_HOME_EQUITY
,      IM_P_OPT_OT_RL_EST_INV_EQ
,      IM_P_OPT_ADJ_BUS_FARM_WORTH
,      IM_P_OPT_ASS_SIBS_PRE_TUI
,      IM_P_OPT_NET_WORTH
,      IM_P_OPT_EMERG_RES_ALLOW
,      IM_P_OPT_CUM_ED_SAVINGS
,      IM_P_OPT_LOW_INC_ALLOW
,      IM_P_OPT_TOTAL_ASSET_ALLOW
,      IM_P_OPT_DISC_NET_WORTH
,      IM_P_OPT_TOTAL_CONT_ASSET
,      IM_P_OPT_TOTAL_CONT
,      IM_P_OPT_NUM_IN_COLL_ADJ
,      IM_P_OPT_CONT_FOR_STU
,      IM_P_OPT_CONT_FROM_INCOME
,      IM_P_OPT_CONT_FROM_ASSETS
,      FM_P_ANALYSIS_TYPE
,      FM_P_AGI_TAXABLE_INCOME
,      FM_P_UNTX_INC_AND_BEN
,      FM_P_INC_ADJ
,      FM_P_TOTAL_INCOME
,      FM_P_US_INCOME_TAX
,      FM_P_STATE_AND_OTHER_TAXES
,      FM_P_FICA_TAX
,      FM_P_EMPLOYMENT_ALLOW
,      FM_P_INCOME_PROT_ALLOW
,      FM_P_TOTAL_ALLOW
,      FM_P_AVAIL_INCOME
,      FM_P_CASH_BANK_ACCOUNTS
,      FM_P_OT_RL_EST_INV_EQUITY
,      FM_P_ADJ_BUS_FARM_NET_WORTH
,      FM_P_NET_WORTH
,      FM_P_ASSET_PROT_ALLOW
,      FM_P_DISC_NET_WORTH
,      FM_P_TOTAL_CONTRIBUTION
,      FM_P_NUM_IN_COLL
,      FM_P_CONT_FOR_STU
,      FM_P_CONT_FROM_INCOME
,      FM_P_CONT_FROM_ASSETS
,      IM_S_BAS_AGI_TAXABLE_INCOME
,      IM_S_BAS_UNTX_INC_AND_BEN
,      IM_S_BAS_INC_ADJ
,      IM_S_BAS_TOTAL_INCOME
,      IM_S_BAS_US_INCOME_TAX
,      IM_S_BAS_STATE_AND_OTH_TAXES
,      IM_S_BAS_FICA_TAX
,      IM_S_BAS_MED_DENTAL
,      IM_S_BAS_EMPLOYMENT_ALLOW
,      IM_S_BAS_ANNUAL_ED_SAVINGS
,      IM_S_BAS_INC_PROT_ALLOW_M
,      IM_S_BAS_TOTAL_INC_ALLOW
,      IM_S_BAS_CAL_AVAIL_INCOME
,      IM_S_BAS_AVAIL_INCOME
,      IM_S_BAS_TOTAL_CONT_INC
,      IM_S_BAS_CASH_BANK_ACCOUNTS
,      IM_S_BAS_HOME_EQUITY
,      IM_S_BAS_OT_RL_EST_INV_EQ
,      IM_S_BAS_ADJ_BUSFARM_WORTH
,      IM_S_BAS_TRUSTS
,      IM_S_BAS_NET_WORTH
,      IM_S_BAS_EMERG_RES_ALLOW
,      IM_S_BAS_CUM_ED_SAVINGS
,      IM_S_BAS_TOTAL_ASSET_ALLOW
,      IM_S_BAS_DISC_NET_WORTH
,      IM_S_BAS_TOTAL_CONT_ASSET
,      IM_S_BAS_TOTAL_CONT
,      IM_S_BAS_NUM_IN_COLL_ADJ
,      IM_S_BAS_CONT_FOR_STU
,      IM_S_BAS_CONT_FROM_INCOME
,      IM_S_BAS_CONT_FROM_ASSETS
,      IM_S_EST_AGITAXABLE_INCOME
,      IM_S_EST_UNTX_INC_AND_BEN
,      IM_S_EST_INC_ADJ
,      IM_S_EST_TOTAL_INCOME
,      IM_S_EST_US_INCOME_TAX
,      IM_S_EST_STATE_AND_OTH_TAXES
,      IM_S_EST_FICA_TAX
,      IM_S_EST_MED_DENTAL
,      IM_S_EST_EMPLOYMENT_ALLOW
,      IM_S_EST_ANNUAL_ED_SAVINGS
,      IM_S_EST_INC_PROT_ALLOW_M
,      IM_S_EST_TOTAL_INC_ALLOW
,      IM_S_EST_CAL_AVAIL_INCOME
,      IM_S_EST_AVAIL_INCOME
,      IM_S_EST_TOTAL_CONT_INC
,      IM_S_EST_CASH_BANK_ACCOUNTS
,      IM_S_EST_HOME_EQUITY
,      IM_S_EST_OT_RL_EST_INV_EQ
,      IM_S_EST_ADJ_BUS_FARM_WORTH
,      IM_S_EST_EST_TRUSTS
,      IM_S_EST_NET_WORTH
,      IM_S_EST_EMERG_RES_ALLOW
,      IM_S_EST_CUM_ED_SAVINGS
,      IM_S_EST_TOTAL_ASSET_ALLOW
,      IM_S_EST_DISC_NET_WORTH
,      IM_S_EST_TOTAL_CONT_ASSET
,      IM_S_EST_TOTAL_CONT
,      IM_S_EST_NUM_IN_COLL_ADJ
,      IM_S_EST_CONT_FOR_STU
,      IM_S_EST_CONT_FROM_INCOME
,      IM_S_EST_CONT_FROM_ASSETS
,      IM_S_OPT_AGI_TAXABLE_INCOME
,      IM_S_OPT_UNTX_INC_AND_BEN
,      IM_S_OPT_INC_ADJ
,      IM_S_OPT_TOTAL_INCOME
,      IM_S_OPT_US_INCOME_TAX
,      IM_S_OPT_STATE_AND_OTH_TAXES
,      IM_S_OPT_FICA_TAX
,      IM_S_OPT_MED_DENTAL
,      IM_S_OPT_EMPLOYMENT_ALLOW
,      IM_S_OPT_ANNUAL_ED_SAVINGS
,      IM_S_OPT_INC_PROT_ALLOW_M
,      IM_S_OPT_TOTAL_INC_ALLOW
,      IM_S_OPT_CAL_AVAIL_INCOME
,      IM_S_OPT_AVAIL_INCOME
,      IM_S_OPT_TOTAL_CONT_INC
,      IM_S_OPT_CASH_BANK_ACCOUNTS
,      IM_S_OPT_IRA_KEOGH_ACCOUNTS
,      IM_S_OPT_HOME_EQUITY
,      IM_S_OPT_OT_RL_EST_INV_EQ
,      IM_S_OPT_ADJ_BUS_FARM_WORTH
,      IM_S_OPT_TRUSTS
,      IM_S_OPT_NET_WORTH
,      IM_S_OPT_EMERG_RES_ALLOW
,      IM_S_OPT_CUM_ED_SAVINGS
,      IM_S_OPT_TOTAL_ASSET_ALLOW
,      IM_S_OPT_DISC_NET_WORTH
,      IM_S_OPT_TOTAL_CONT_ASSET
,      IM_S_OPT_TOTAL_CONT
,      IM_S_OPT_NUM_IN_COLL_ADJ
,      IM_S_OPT_CONT_FOR_STU
,      IM_S_OPT_CONT_FROM_INCOME
,      IM_S_OPT_CONT_FROM_ASSETS
,      FM_S_ANALYSIS_TYPE
,      FM_S_AGI_TAXABLE_INCOME
,      FM_S_UNTX_INC_AND_BEN
,      FM_S_INC_ADJ
,      FM_S_TOTAL_INCOME
,      FM_S_US_INCOME_TAX
,      FM_S_STATE_AND_OTH_TAXES
,      FM_S_FICA_TAX
,      FM_S_EMPLOYMENT_ALLOW
,      FM_S_INCOME_PROT_ALLOW
,      FM_S_TOTAL_ALLOW
,      FM_S_CAL_AVAIL_INCOME
,      FM_S_AVAIL_INCOME
,      FM_S_CASH_BANK_ACCOUNTS
,      FM_S_OT_RL_EST_INV_EQUITY
,      FM_S_ADJ_BUS_FARM_WORTH
,      FM_S_TRUSTS
,      FM_S_NET_WORTH
,      FM_S_ASSET_PROT_ALLOW
,      FM_S_DISC_NET_WORTH
,      FM_S_TOTAL_CONT
,      FM_S_NUM_IN_COLL
,      FM_S_CONT_FOR_STU
,      FM_S_CONT_FROM_INCOME
,      FM_S_CONT_FROM_ASSETS
,      IM_INST_RESIDENT_IND
,      INSTITUTIONAL_1_BUDGET_NAME
,      IM_INST_1_BUDGET_DURATION
,      IM_INST_1_TUITION_FEES
,      IM_INST_1_BOOKS_SUPPLIES
,      IM_INST_1_LIVING_EXPENSES
,      IM_INST_1_TOT_EXPENSES
,      IM_INST_1_TOT_STU_CONT
,      IM_INST_1_TOT_PAR_CONT
,      IM_INST_1_TOT_FAMILY_CONT
,      IM_INST_1_VA_BENEFITS
,      IM_INST_1_OT_CONT
,      IM_INST_1_EST_FINANCIAL_NEED
,      INSTITUTIONAL_2_BUDGET_NAME
,      IM_INST_2_BUDGET_DURATION
,      IM_INST_2_TUITION_FEES
,      IM_INST_2_BOOKS_SUPPLIES
,      IM_INST_2_LIVING_EXPENSES
,      IM_INST_2_TOT_EXPENSES
,      IM_INST_2_TOT_STU_CONT
,      IM_INST_2_TOT_PAR_CONT
,      IM_INST_2_TOT_FAMILY_CONT
,      IM_INST_2_VA_BENEFITS
,      IM_INST_2_EST_FINANCIAL_NEED
,      INSTITUTIONAL_3_BUDGET_NAME
,      IM_INST_3_BUDGET_DURATION
,      IM_INST_3_TUITION_FEES
,      IM_INST_3_BOOKS_SUPPLIES
,      IM_INST_3_LIVING_EXPENSES
,      IM_INST_3_TOT_EXPENSES
,      IM_INST_3_TOT_STU_CONT
,      IM_INST_3_TOT_PAR_CONT
,      IM_INST_3_TOT_FAMILY_CONT
,      IM_INST_3_VA_BENEFITS
,      IM_INST_3_EST_FINANCIAL_NEED
,      FM_INST_1_FEDERAL_EFC
,      FM_INST_1_VA_BENEFITS
,      FM_INST_1_FED_ELIGIBILITY
,      FM_INST_1_PELL
,      OPTION_PAR_LOSS_ALLOW_IND
,      OPTION_PAR_TUITION_IND
,      OPTION_PAR_HOME_IND
,      OPTION_PAR_HOME_VALUE
,      OPTION_PAR_HOME_DEBT
,      OPTION_STU_IRA_KEOGH_IND
,      OPTION_STU_HOME_IND
,      OPTION_STU_HOME_VALUE
,      OPTION_STU_HOME_DEBT
,      OPTION_STU_SUM_AY_INC_IND
,      OPTION_PAR_HOPE_LL_CREDIT
,      OPTION_STU_HOPE_LL_CREDIT
,      OPTION_PAR_COLA_ADJ_IND
,      OPTION_PAR_STU_FA_ASSETS_IND
,      OPTION_PAR_IPT_ASSETS_IND
,      OPTION_STU_IPT_ASSETS_IND
,      OPTION_PAR_COLA_ADJ_VALUE
,      IM_PARENT_1_8_MONTHS_BAS
,      IM_P_MORE_THAN_9_MTH_BA
,      IM_PARENT_1_8_MONTHS_OPT
,      IM_P_MORE_THAN_9_MTH_OP
,      FNAR_MESSAGE_1
,      FNAR_MESSAGE_2
,      FNAR_MESSAGE_3
,      FNAR_MESSAGE_4
,      FNAR_MESSAGE_5
,      FNAR_MESSAGE_6
,      FNAR_MESSAGE_7
,      FNAR_MESSAGE_8
,      FNAR_MESSAGE_9
,      FNAR_MESSAGE_10
,      FNAR_MESSAGE_11
,      FNAR_MESSAGE_12
,      FNAR_MESSAGE_13
,      FNAR_MESSAGE_20
,      FNAR_MESSAGE_21
,      FNAR_MESSAGE_22
,      FNAR_MESSAGE_23
,      FNAR_MESSAGE_24
,      FNAR_MESSAGE_25
,      FNAR_MESSAGE_26
,      FNAR_MESSAGE_27
,      FNAR_MESSAGE_30
,      FNAR_MESSAGE_31
,      FNAR_MESSAGE_32
,      FNAR_MESSAGE_33
,      FNAR_MESSAGE_34
,      FNAR_MESSAGE_35
,      FNAR_MESSAGE_36
,      FNAR_MESSAGE_37
,      FNAR_MESSAGE_38
,      FNAR_MESSAGE_39
,      FNAR_MESSAGE_45
,      FNAR_MESSAGE_46
,      FNAR_MESSAGE_47
,      FNAR_MESSAGE_48
,      FNAR_MESSAGE_49
,      FNAR_MESSAGE_50
,      FNAR_MESSAGE_51
,      FNAR_MESSAGE_52
,      FNAR_MESSAGE_53
,      FNAR_MESSAGE_55
,      FNAR_MESSAGE_56
,      FNAR_MESSAGE_57
,      FNAR_MESSAGE_58
,      FNAR_MESSAGE_59
,      FNAR_MESSAGE_60
,      FNAR_MESSAGE_61
,      FNAR_MESSAGE_62
,      FNAR_MESSAGE_63
,      FNAR_MESSAGE_64
,      FNAR_MESSAGE_65
,      FNAR_MESSAGE_71
,      FNAR_MESSAGE_72
,      FNAR_MESSAGE_73
,      FNAR_MESSAGE_74
,      FNAR_MESSAGE_75
,      FNAR_MESSAGE_76
,      FNAR_MESSAGE_77
,      FNAR_MESSAGE_78
,      FNAR_MESG_10_STU_FAM_MEM
,      FNAR_MESG_11_STU_NO_IN_COLL
,      FNAR_MESG_24_STU_AVAIL_INC
,      FNAR_MESG_26_STU_TAXES
,      FNAR_MESG_33_STU_HOME_VALUE
,      FNAR_MESG_34_STU_HOME_VALUE
,      FNAR_MESG_34_STU_HOME_EQUITY
,      FNAR_MESG_35_STU_HOME_VALUE
,      FNAR_MESG_35_STU_HOME_EQUITY
,      FNAR_MESG_36_STU_HOME_EQUITY
,      FNAR_MESG_48_PAR_FAM_MEM
,      FNAR_MESG_49_PAR_NO_IN_COLL
,      FNAR_MESG_56_PAR_AGI
,      FNAR_MESG_62_PAR_TAXES
,      FNAR_MESG_73_PAR_HOME_VALUE
,      FNAR_MESG_74_PAR_HOME_VALUE
,      FNAR_MESG_74_PAR_HOME_EQUITY
,      FNAR_MESG_75_PAR_HOME_VALUE
,      FNAR_MESG_75_PAR_HOME_EQUITY
,      FNAR_MESG_76_PAR_HOME_EQUITY
,      ASSUMPTION_MESSAGE_1
,      ASSUMPTION_MESSAGE_2
,      ASSUMPTION_MESSAGE_3
,      ASSUMPTION_MESSAGE_4
,      ASSUMPTION_MESSAGE_5
,      ASSUMPTION_MESSAGE_6
,      RECORD_MARK
,      LEGACY_RECORD_FLAG
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OPTION_IND_STU_IPT_ASSETS_FLAG
,      CUST_PARENT_CONT_ADJ_NUM
,      CUSTODIAL_PARENT_NUM
,      CUST_PAR_BASE_PRCNT_INC_AMT
,      CUST_PAR_BASE_CONT_INC_AMT
,      CUST_PAR_BASE_CONT_AST_AMT
,      CUST_PAR_BASE_TOT_CONT_AMT
,      CUST_PAR_OPT_PRCNT_INC_AMT
,      CUST_PAR_OPT_CONT_INC_AMT
,      CUST_PAR_OPT_CONT_AST_AMT
,      CUST_PAR_OPT_TOT_CONT_AMT
,      PARENTS_EMAIL_TXT
,      PARENT_1_BIRTH_DATE
,      PARENT_2_BIRTH_DATE
FROM APPS.IGF_AP_CSS_FNAR;

Dependencies

[top of page]

APPS.IGF_AP_CSS_FNAR references the following:

SchemaAPPS
SynonymIGF_AP_CSS_FNAR_ALL
APPS.IGF_AP_CSS_FNAR is referenced by following:

SchemaAPPS
Package BodyIGF_AP_CALC_IM_EFC - show dependent code
ViewIGF_AP_CSS_FNAR_V
ViewIGF_AP_CSS_PROFILE_V
Package BodyIGF_AP_MK_PROF_ACT_PKG - show dependent code
Package BodyIGF_AP_PROFILE_MATCHING_PKG - show dependent code
Package BodyIGF_AP_UHK_INAS_PKG - show dependent code
PL/SQL PackageIGF_AP_UHK_INAS_PKG - show dependent code