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

Line 276: CURSOR cur_fa_mapping ( p_citizenship_status igf_sl_pe_citi_map.pe_citi_stat_code%TYPE,

272:
273: citizenship_dtl_rec citizenship_dtl_cur%ROWTYPE;
274:
275: --Bug# 5006583
276: CURSOR cur_fa_mapping ( p_citizenship_status igf_sl_pe_citi_map.pe_citi_stat_code%TYPE,
277: p_cal_type igf_sl_pe_citi_map.ci_cal_type%TYPE,
278: p_sequence_number igf_sl_pe_citi_map.ci_sequence_number%TYPE ) IS
279: SELECT fa_citi_stat_code FROM igf_sl_pe_citi_map
280: WHERE pe_citi_stat_code = p_citizenship_status

Line 277: p_cal_type igf_sl_pe_citi_map.ci_cal_type%TYPE,

273: citizenship_dtl_rec citizenship_dtl_cur%ROWTYPE;
274:
275: --Bug# 5006583
276: CURSOR cur_fa_mapping ( p_citizenship_status igf_sl_pe_citi_map.pe_citi_stat_code%TYPE,
277: p_cal_type igf_sl_pe_citi_map.ci_cal_type%TYPE,
278: p_sequence_number igf_sl_pe_citi_map.ci_sequence_number%TYPE ) IS
279: SELECT fa_citi_stat_code FROM igf_sl_pe_citi_map
280: WHERE pe_citi_stat_code = p_citizenship_status
281: AND ci_sequence_number =p_sequence_number

Line 278: p_sequence_number igf_sl_pe_citi_map.ci_sequence_number%TYPE ) IS

274:
275: --Bug# 5006583
276: CURSOR cur_fa_mapping ( p_citizenship_status igf_sl_pe_citi_map.pe_citi_stat_code%TYPE,
277: p_cal_type igf_sl_pe_citi_map.ci_cal_type%TYPE,
278: p_sequence_number igf_sl_pe_citi_map.ci_sequence_number%TYPE ) IS
279: SELECT fa_citi_stat_code FROM igf_sl_pe_citi_map
280: WHERE pe_citi_stat_code = p_citizenship_status
281: AND ci_sequence_number =p_sequence_number
282: AND ci_cal_type = p_cal_type;

Line 279: SELECT fa_citi_stat_code FROM igf_sl_pe_citi_map

275: --Bug# 5006583
276: CURSOR cur_fa_mapping ( p_citizenship_status igf_sl_pe_citi_map.pe_citi_stat_code%TYPE,
277: p_cal_type igf_sl_pe_citi_map.ci_cal_type%TYPE,
278: p_sequence_number igf_sl_pe_citi_map.ci_sequence_number%TYPE ) IS
279: SELECT fa_citi_stat_code FROM igf_sl_pe_citi_map
280: WHERE pe_citi_stat_code = p_citizenship_status
281: AND ci_sequence_number =p_sequence_number
282: AND ci_cal_type = p_cal_type;
283:

Line 1599: CURSOR cur_fa_mapping ( p_citizenship_status igf_sl_pe_citi_map.pe_citi_stat_code%TYPE,

1595: l_student_person_id NUMBER;
1596: l_cosigner_person_id NUMBER;
1597:
1598: --Bug# 5006583
1599: CURSOR cur_fa_mapping ( p_citizenship_status igf_sl_pe_citi_map.pe_citi_stat_code%TYPE,
1600: p_cal_type igf_sl_pe_citi_map.ci_cal_type%TYPE,
1601: p_sequence_number igf_sl_pe_citi_map.ci_sequence_number%TYPE ) IS
1602: SELECT fa_citi_stat_code FROM igf_sl_pe_citi_map
1603: WHERE pe_citi_stat_code = p_citizenship_status

Line 1600: p_cal_type igf_sl_pe_citi_map.ci_cal_type%TYPE,

1596: l_cosigner_person_id NUMBER;
1597:
1598: --Bug# 5006583
1599: CURSOR cur_fa_mapping ( p_citizenship_status igf_sl_pe_citi_map.pe_citi_stat_code%TYPE,
1600: p_cal_type igf_sl_pe_citi_map.ci_cal_type%TYPE,
1601: p_sequence_number igf_sl_pe_citi_map.ci_sequence_number%TYPE ) IS
1602: SELECT fa_citi_stat_code FROM igf_sl_pe_citi_map
1603: WHERE pe_citi_stat_code = p_citizenship_status
1604: AND ci_sequence_number =p_sequence_number

Line 1601: p_sequence_number igf_sl_pe_citi_map.ci_sequence_number%TYPE ) IS

1597:
1598: --Bug# 5006583
1599: CURSOR cur_fa_mapping ( p_citizenship_status igf_sl_pe_citi_map.pe_citi_stat_code%TYPE,
1600: p_cal_type igf_sl_pe_citi_map.ci_cal_type%TYPE,
1601: p_sequence_number igf_sl_pe_citi_map.ci_sequence_number%TYPE ) IS
1602: SELECT fa_citi_stat_code FROM igf_sl_pe_citi_map
1603: WHERE pe_citi_stat_code = p_citizenship_status
1604: AND ci_sequence_number =p_sequence_number
1605: AND ci_cal_type = p_cal_type;

Line 1602: SELECT fa_citi_stat_code FROM igf_sl_pe_citi_map

1598: --Bug# 5006583
1599: CURSOR cur_fa_mapping ( p_citizenship_status igf_sl_pe_citi_map.pe_citi_stat_code%TYPE,
1600: p_cal_type igf_sl_pe_citi_map.ci_cal_type%TYPE,
1601: p_sequence_number igf_sl_pe_citi_map.ci_sequence_number%TYPE ) IS
1602: SELECT fa_citi_stat_code FROM igf_sl_pe_citi_map
1603: WHERE pe_citi_stat_code = p_citizenship_status
1604: AND ci_sequence_number =p_sequence_number
1605: AND ci_cal_type = p_cal_type;
1606:

Line 2036: CURSOR cur_fa_mapping ( p_citizenship_status igf_sl_pe_citi_map.pe_citi_stat_code%TYPE,

2032: lb_update Boolean;
2033: l_parent_person_id NUMBER;
2034: l_student_person_id NUMBER;
2035: --Bug# 5006583
2036: CURSOR cur_fa_mapping ( p_citizenship_status igf_sl_pe_citi_map.pe_citi_stat_code%TYPE,
2037: p_cal_type igf_sl_pe_citi_map.ci_cal_type%TYPE,
2038: p_sequence_number igf_sl_pe_citi_map.ci_sequence_number%TYPE ) IS
2039: SELECT fa_citi_stat_code FROM igf_sl_pe_citi_map
2040: WHERE pe_citi_stat_code = p_citizenship_status

Line 2037: p_cal_type igf_sl_pe_citi_map.ci_cal_type%TYPE,

2033: l_parent_person_id NUMBER;
2034: l_student_person_id NUMBER;
2035: --Bug# 5006583
2036: CURSOR cur_fa_mapping ( p_citizenship_status igf_sl_pe_citi_map.pe_citi_stat_code%TYPE,
2037: p_cal_type igf_sl_pe_citi_map.ci_cal_type%TYPE,
2038: p_sequence_number igf_sl_pe_citi_map.ci_sequence_number%TYPE ) IS
2039: SELECT fa_citi_stat_code FROM igf_sl_pe_citi_map
2040: WHERE pe_citi_stat_code = p_citizenship_status
2041: AND ci_sequence_number =p_sequence_number

Line 2038: p_sequence_number igf_sl_pe_citi_map.ci_sequence_number%TYPE ) IS

2034: l_student_person_id NUMBER;
2035: --Bug# 5006583
2036: CURSOR cur_fa_mapping ( p_citizenship_status igf_sl_pe_citi_map.pe_citi_stat_code%TYPE,
2037: p_cal_type igf_sl_pe_citi_map.ci_cal_type%TYPE,
2038: p_sequence_number igf_sl_pe_citi_map.ci_sequence_number%TYPE ) IS
2039: SELECT fa_citi_stat_code FROM igf_sl_pe_citi_map
2040: WHERE pe_citi_stat_code = p_citizenship_status
2041: AND ci_sequence_number =p_sequence_number
2042: AND ci_cal_type = p_cal_type;

Line 2039: SELECT fa_citi_stat_code FROM igf_sl_pe_citi_map

2035: --Bug# 5006583
2036: CURSOR cur_fa_mapping ( p_citizenship_status igf_sl_pe_citi_map.pe_citi_stat_code%TYPE,
2037: p_cal_type igf_sl_pe_citi_map.ci_cal_type%TYPE,
2038: p_sequence_number igf_sl_pe_citi_map.ci_sequence_number%TYPE ) IS
2039: SELECT fa_citi_stat_code FROM igf_sl_pe_citi_map
2040: WHERE pe_citi_stat_code = p_citizenship_status
2041: AND ci_sequence_number =p_sequence_number
2042: AND ci_cal_type = p_cal_type;
2043: