APPS.IGF_SL_CL_LI_IMP_PKG dependencies on IGF_AW_LOOKUPS_VIEW

Line 1397: FROM igf_aw_lookups_view

1393: --
1394: --
1395: CURSOR c_citizenship_codes (cp_lookup_code VARCHAR2) IS
1396: SELECT lookup_code
1397: FROM igf_aw_lookups_view
1398: WHERE
1399: lookup_type = 'IGF_SL_ALT_CS_US_CT_ST_CODE'
1400: AND cal_type = p_cal_type
1401: AND sequence_number = p_seq_number

Line 1407: FROM igf_aw_lookups_view

1403: AND lookup_code = cp_lookup_code;
1404:
1405: CURSOR c_state_codes (cp_lookup_code VARCHAR2) IS
1406: SELECT lookup_code
1407: FROM igf_aw_lookups_view
1408: WHERE
1409: lookup_type = 'IGF_AP_STATE_CODES'
1410: AND cal_type = p_cal_type
1411: AND sequence_number = p_seq_number

Line 1418: FROM igf_aw_lookups_view

1414: AND lookup_code = cp_lookup_code;
1415:
1416: CURSOR c_yes_no_codes (cp_lookup_code VARCHAR2) IS -- Used for Signature/Credit Aut/Elect Sig validations.
1417: SELECT lookup_code
1418: FROM igf_aw_lookups_view
1419: WHERE
1420: lookup_type = 'YES_NO'
1421: AND cal_type = p_cal_type
1422: AND sequence_number = p_seq_number

Line 1428: FROM igf_aw_lookups_view

1424: AND lookup_code = cp_lookup_code;
1425:
1426: CURSOR c_relationship_codes (cp_lookup_code VARCHAR2) IS
1427: SELECT lookup_code
1428: FROM igf_aw_lookups_view
1429: WHERE
1430: lookup_type = 'IGF_SL_ALT_CS_STUDENT_RELATION'
1431: AND cal_type = p_cal_type
1432: AND sequence_number = p_seq_number

Line 1436: l_lookup_code igf_aw_lookups_view.lookup_code%TYPE;

1432: AND sequence_number = p_seq_number
1433: AND enabled_flag = 'Y'
1434: AND lookup_code = cp_lookup_code;
1435:
1436: l_lookup_code igf_aw_lookups_view.lookup_code%TYPE;
1437:
1438: BEGIN
1439: IF SUBSTR(p_ssn_txt,1,1) = '8' OR -- SSN Validations - CL Spec - 8/9/000 at start not permitted.
1440: SUBSTR(p_ssn_txt,1,1) = '9' OR