DBA Data[Home] [Help]

APPS.IGS_PRECREATE_APPL_PUB dependencies on IGS_SS_APP_REQ_STG_S

Line 1794: l_SS_ADM_APPL_ID IGS_SS_APP_REQ_STG.SS_ADM_APPL_ID%TYPE;

1790: l_APPL_FEE_STATUS_REC C_FEE_STATUS%ROWTYPE;
1791: l_APPL_FEE_PAY_MET_REC C_FEE_PAYMENT_METHOD%ROWTYPE;
1792:
1793:
1794: l_SS_ADM_APPL_ID IGS_SS_APP_REQ_STG.SS_ADM_APPL_ID%TYPE;
1795: l_PERSON_ID IGS_SS_APP_REQ_STG.PERSON_ID%TYPE;
1796: l_APPLICANT_FEE_TYPE IGS_SS_APP_REQ_STG.APPLICANT_FEE_TYPE%TYPE;
1797: l_APPLICANT_FEE_STATUS IGS_SS_APP_REQ_STG.APPLICANT_FEE_STATUS%TYPE;
1798: l_FEE_DATE IGS_SS_APP_REQ_STG.FEE_DATE%TYPE;

Line 1989: IGS_SS_APP_REQ_STG_S.NEXTVAL,

1985: REFERENCE_NUM
1986: )
1987: VALUES
1988: (
1989: IGS_SS_APP_REQ_STG_S.NEXTVAL,
1990: l_SS_ADM_APPL_ID,
1991: l_PERSON_ID,
1992: l_APPLICANT_FEE_TYPE,
1993: l_APPLICANT_FEE_STATUS,