eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGF_SL_CL_VALIDATION dependencies on IGF_SL_PE_CITI_MAP

Line 413: CURSOR cur_fa_mapping ( cp_citizenship_status igf_sl_pe_citi_map.pe_citi_stat_code%TYPE,

409: WHERE pct.person_id = cp_person_id AND
410: SYSDATE BETWEEN start_date AND NVL(end_date,SYSDATE);
411: citizenship_dtl_rec citizenship_dtl_cur%ROWTYPE;
412:
413: CURSOR cur_fa_mapping ( cp_citizenship_status igf_sl_pe_citi_map.pe_citi_stat_code%TYPE,
414: cp_cal_type igf_sl_pe_citi_map.ci_cal_type%TYPE,
415: cp_sequence_number igf_sl_pe_citi_map.ci_sequence_number%TYPE) IS
416: SELECT trim(fa_citi_stat_code) fa_citi_stat_code FROM igf_sl_pe_citi_map
417: WHERE pe_citi_stat_code = cp_citizenship_status

Line 414: cp_cal_type igf_sl_pe_citi_map.ci_cal_type%TYPE,

410: SYSDATE BETWEEN start_date AND NVL(end_date,SYSDATE);
411: citizenship_dtl_rec citizenship_dtl_cur%ROWTYPE;
412:
413: CURSOR cur_fa_mapping ( cp_citizenship_status igf_sl_pe_citi_map.pe_citi_stat_code%TYPE,
414: cp_cal_type igf_sl_pe_citi_map.ci_cal_type%TYPE,
415: cp_sequence_number igf_sl_pe_citi_map.ci_sequence_number%TYPE) IS
416: SELECT trim(fa_citi_stat_code) fa_citi_stat_code FROM igf_sl_pe_citi_map
417: WHERE pe_citi_stat_code = cp_citizenship_status
418: AND ci_sequence_number = cp_sequence_number

Line 415: cp_sequence_number igf_sl_pe_citi_map.ci_sequence_number%TYPE) IS

411: citizenship_dtl_rec citizenship_dtl_cur%ROWTYPE;
412:
413: CURSOR cur_fa_mapping ( cp_citizenship_status igf_sl_pe_citi_map.pe_citi_stat_code%TYPE,
414: cp_cal_type igf_sl_pe_citi_map.ci_cal_type%TYPE,
415: cp_sequence_number igf_sl_pe_citi_map.ci_sequence_number%TYPE) IS
416: SELECT trim(fa_citi_stat_code) fa_citi_stat_code FROM igf_sl_pe_citi_map
417: WHERE pe_citi_stat_code = cp_citizenship_status
418: AND ci_sequence_number = cp_sequence_number
419: AND ci_cal_type = cp_cal_type;

Line 416: SELECT trim(fa_citi_stat_code) fa_citi_stat_code FROM igf_sl_pe_citi_map

412:
413: CURSOR cur_fa_mapping ( cp_citizenship_status igf_sl_pe_citi_map.pe_citi_stat_code%TYPE,
414: cp_cal_type igf_sl_pe_citi_map.ci_cal_type%TYPE,
415: cp_sequence_number igf_sl_pe_citi_map.ci_sequence_number%TYPE) IS
416: SELECT trim(fa_citi_stat_code) fa_citi_stat_code FROM igf_sl_pe_citi_map
417: WHERE pe_citi_stat_code = cp_citizenship_status
418: AND ci_sequence_number = cp_sequence_number
419: AND ci_cal_type = cp_cal_type;
420: cur_fa_mapping_rec cur_fa_mapping%ROWTYPE;