APPS.IGF_AP_MATCHING_PROCESS_PKG dependencies on IGF_LOOKUPS_VIEW

Line 2525: FROM igf_lookups_view

2521:
2522:
2523: CURSOR cur_lkups(cp_lkup_type VARCHAR2, cp_lkup_cd VARCHAR2) IS
2524: SELECT tag
2525: FROM igf_lookups_view
2526: WHERE lookup_type = cp_lkup_type
2527: AND lookup_code = cp_lkup_cd
2528: AND enabled_flag = 'Y';
2529:

Line 2540: lv_sex igf_lookups_view.lookup_code%TYPE;

2536: lv_msg_data VARCHAR2(2000);
2537: lv_return_status VARCHAR2(1);
2538: lv_row_id VARCHAR2(30);
2539: ld_end_date DATE;
2540: lv_sex igf_lookups_view.lookup_code%TYPE;
2541: lv_oss_sex_val VARCHAR2(30);
2542: l_demo_data_changed VARCHAR2(1);
2543: BEGIN
2544:

Line 3328: CURSOR cur_lookups (p_lkup_type igf_lookups_view.Lookup_type%TYPE,

3324: SELECT person_id_type
3325: FROM igs_pe_person_id_typ
3326: WHERE s_person_id_type = cp_pers_id_type ;
3327:
3328: CURSOR cur_lookups (p_lkup_type igf_lookups_view.Lookup_type%TYPE,
3329: p_lkup_code igf_lookups_view.Lookup_code%TYPE) IS
3330: SELECT tag
3331: FROM igf_lookups_view
3332: WHERE lookup_type = p_lkup_type

Line 3329: p_lkup_code igf_lookups_view.Lookup_code%TYPE) IS

3325: FROM igs_pe_person_id_typ
3326: WHERE s_person_id_type = cp_pers_id_type ;
3327:
3328: CURSOR cur_lookups (p_lkup_type igf_lookups_view.Lookup_type%TYPE,
3329: p_lkup_code igf_lookups_view.Lookup_code%TYPE) IS
3330: SELECT tag
3331: FROM igf_lookups_view
3332: WHERE lookup_type = p_lkup_type
3333: AND lookup_code = p_lkup_code

Line 3331: FROM igf_lookups_view

3327:
3328: CURSOR cur_lookups (p_lkup_type igf_lookups_view.Lookup_type%TYPE,
3329: p_lkup_code igf_lookups_view.Lookup_code%TYPE) IS
3330: SELECT tag
3331: FROM igf_lookups_view
3332: WHERE lookup_type = p_lkup_type
3333: AND lookup_code = p_lkup_code
3334: AND enabled_flag = 'Y';
3335:

Line 3346: lv_sex igf_lookups_view.lookup_code%TYPE;

3342: lv_return_status VARCHAR2(1);
3343: lv_row_id VARCHAR2(30);
3344: retcode NUMBER;
3345: errbuf VARCHAR2(300);
3346: lv_sex igf_lookups_view.lookup_code%TYPE;
3347: l_object_version_number NUMBER;
3348:
3349: l_return_status VARCHAR2(25);
3350: l_msg_count NUMBER;

Line 4051: FROM igf_lookups_view

4047:
4048:
4049: CURSOR cur_lookups(cp_lkup_type VARCHAR2, cp_lkup_cd VARCHAR2) IS
4050: SELECT tag
4051: FROM igf_lookups_view
4052: WHERE lookup_type = cp_lkup_type
4053: AND lookup_code = cp_lkup_cd
4054: AND enabled_flag = 'Y';
4055: