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_ORIG dependencies on IGF_SL_PE_CITI_MAP

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

1444: AND pct.person_id = cp_person_id
1445: AND SYSDATE BETWEEN start_date AND NVL(end_date,SYSDATE);
1446: citizenship_dtl_rec citizenship_dtl_cur%ROWTYPE;
1447:
1448: CURSOR cur_fa_mapping ( cp_citizenship_status igf_sl_pe_citi_map.pe_citi_stat_code%TYPE,
1449: cp_cal_type igf_sl_pe_citi_map.ci_cal_type%TYPE,
1450: cp_sequence_number igf_sl_pe_citi_map.ci_sequence_number%TYPE) IS
1451: SELECT trim(fa_citi_stat_code) fa_citi_stat_code FROM igf_sl_pe_citi_map
1452: WHERE pe_citi_stat_code = cp_citizenship_status

Line 1449: cp_cal_type igf_sl_pe_citi_map.ci_cal_type%TYPE,

1445: AND SYSDATE BETWEEN start_date AND NVL(end_date,SYSDATE);
1446: citizenship_dtl_rec citizenship_dtl_cur%ROWTYPE;
1447:
1448: CURSOR cur_fa_mapping ( cp_citizenship_status igf_sl_pe_citi_map.pe_citi_stat_code%TYPE,
1449: cp_cal_type igf_sl_pe_citi_map.ci_cal_type%TYPE,
1450: cp_sequence_number igf_sl_pe_citi_map.ci_sequence_number%TYPE) IS
1451: SELECT trim(fa_citi_stat_code) fa_citi_stat_code FROM igf_sl_pe_citi_map
1452: WHERE pe_citi_stat_code = cp_citizenship_status
1453: AND ci_sequence_number = cp_sequence_number

Line 1450: cp_sequence_number igf_sl_pe_citi_map.ci_sequence_number%TYPE) IS

1446: citizenship_dtl_rec citizenship_dtl_cur%ROWTYPE;
1447:
1448: CURSOR cur_fa_mapping ( cp_citizenship_status igf_sl_pe_citi_map.pe_citi_stat_code%TYPE,
1449: cp_cal_type igf_sl_pe_citi_map.ci_cal_type%TYPE,
1450: cp_sequence_number igf_sl_pe_citi_map.ci_sequence_number%TYPE) IS
1451: SELECT trim(fa_citi_stat_code) fa_citi_stat_code FROM igf_sl_pe_citi_map
1452: WHERE pe_citi_stat_code = cp_citizenship_status
1453: AND ci_sequence_number = cp_sequence_number
1454: AND ci_cal_type = cp_cal_type;

Line 1451: SELECT trim(fa_citi_stat_code) fa_citi_stat_code FROM igf_sl_pe_citi_map

1447:
1448: CURSOR cur_fa_mapping ( cp_citizenship_status igf_sl_pe_citi_map.pe_citi_stat_code%TYPE,
1449: cp_cal_type igf_sl_pe_citi_map.ci_cal_type%TYPE,
1450: cp_sequence_number igf_sl_pe_citi_map.ci_sequence_number%TYPE) IS
1451: SELECT trim(fa_citi_stat_code) fa_citi_stat_code FROM igf_sl_pe_citi_map
1452: WHERE pe_citi_stat_code = cp_citizenship_status
1453: AND ci_sequence_number = cp_sequence_number
1454: AND ci_cal_type = cp_cal_type;
1455: cur_fa_mapping_rec cur_fa_mapping%ROWTYPE;