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_DL_LI_IMP_PKG dependencies on IGF_AP_ISIR_MATCHED

Line 1954: FROM igf_ap_fa_base_rec fabase,igf_ap_isir_matched isir

1950:
1951: CURSOR cur_isir_depend_status (cp_person_id NUMBER)
1952: IS
1953: SELECT isir.dependency_status
1954: FROM igf_ap_fa_base_rec fabase,igf_ap_isir_matched isir
1955: WHERE isir.base_id = fabase.base_id
1956: AND isir.payment_isir = 'Y'
1957: AND isir.system_record_type = 'ORIGINAL'
1958: AND fabase.person_id = cp_person_id;

Line 1965: lv_s_license_number igf_ap_isir_matched.driver_license_number%TYPE;

1961:
1962: ln_row_id ROWID;
1963: lv_p_permt_phone igf_sl_lor_loc_all.s_permt_phone%TYPE;
1964: lv_s_permt_phone igf_sl_lor_loc_all.s_permt_phone%TYPE;
1965: lv_s_license_number igf_ap_isir_matched.driver_license_number%TYPE;
1966: lv_s_license_state igf_ap_isir_matched.driver_license_state%TYPE;
1967: lv_s_citizenship_status VARCHAR2(30);
1968: lv_alien_reg_num igf_ap_isir_matched.alien_reg_number%TYPE;
1969: lv_dependency_status igf_ap_isir_matched.dependency_status%TYPE;

Line 1966: lv_s_license_state igf_ap_isir_matched.driver_license_state%TYPE;

1962: ln_row_id ROWID;
1963: lv_p_permt_phone igf_sl_lor_loc_all.s_permt_phone%TYPE;
1964: lv_s_permt_phone igf_sl_lor_loc_all.s_permt_phone%TYPE;
1965: lv_s_license_number igf_ap_isir_matched.driver_license_number%TYPE;
1966: lv_s_license_state igf_ap_isir_matched.driver_license_state%TYPE;
1967: lv_s_citizenship_status VARCHAR2(30);
1968: lv_alien_reg_num igf_ap_isir_matched.alien_reg_number%TYPE;
1969: lv_dependency_status igf_ap_isir_matched.dependency_status%TYPE;
1970: lv_s_legal_res_date igf_ap_isir_matched.s_legal_resd_date%TYPE;

Line 1968: lv_alien_reg_num igf_ap_isir_matched.alien_reg_number%TYPE;

1964: lv_s_permt_phone igf_sl_lor_loc_all.s_permt_phone%TYPE;
1965: lv_s_license_number igf_ap_isir_matched.driver_license_number%TYPE;
1966: lv_s_license_state igf_ap_isir_matched.driver_license_state%TYPE;
1967: lv_s_citizenship_status VARCHAR2(30);
1968: lv_alien_reg_num igf_ap_isir_matched.alien_reg_number%TYPE;
1969: lv_dependency_status igf_ap_isir_matched.dependency_status%TYPE;
1970: lv_s_legal_res_date igf_ap_isir_matched.s_legal_resd_date%TYPE;
1971: lv_s_legal_res_state igf_ap_isir_matched.s_state_legal_residence%TYPE;
1972:

Line 1969: lv_dependency_status igf_ap_isir_matched.dependency_status%TYPE;

1965: lv_s_license_number igf_ap_isir_matched.driver_license_number%TYPE;
1966: lv_s_license_state igf_ap_isir_matched.driver_license_state%TYPE;
1967: lv_s_citizenship_status VARCHAR2(30);
1968: lv_alien_reg_num igf_ap_isir_matched.alien_reg_number%TYPE;
1969: lv_dependency_status igf_ap_isir_matched.dependency_status%TYPE;
1970: lv_s_legal_res_date igf_ap_isir_matched.s_legal_resd_date%TYPE;
1971: lv_s_legal_res_state igf_ap_isir_matched.s_state_legal_residence%TYPE;
1972:
1973: BEGIN

Line 1970: lv_s_legal_res_date igf_ap_isir_matched.s_legal_resd_date%TYPE;

1966: lv_s_license_state igf_ap_isir_matched.driver_license_state%TYPE;
1967: lv_s_citizenship_status VARCHAR2(30);
1968: lv_alien_reg_num igf_ap_isir_matched.alien_reg_number%TYPE;
1969: lv_dependency_status igf_ap_isir_matched.dependency_status%TYPE;
1970: lv_s_legal_res_date igf_ap_isir_matched.s_legal_resd_date%TYPE;
1971: lv_s_legal_res_state igf_ap_isir_matched.s_state_legal_residence%TYPE;
1972:
1973: BEGIN
1974:

Line 1971: lv_s_legal_res_state igf_ap_isir_matched.s_state_legal_residence%TYPE;

1967: lv_s_citizenship_status VARCHAR2(30);
1968: lv_alien_reg_num igf_ap_isir_matched.alien_reg_number%TYPE;
1969: lv_dependency_status igf_ap_isir_matched.dependency_status%TYPE;
1970: lv_s_legal_res_date igf_ap_isir_matched.s_legal_resd_date%TYPE;
1971: lv_s_legal_res_state igf_ap_isir_matched.s_state_legal_residence%TYPE;
1972:
1973: BEGIN
1974:
1975: ln_row_id := NULL;

Line 2390: FROM igf_ap_fa_base_rec fabase,igf_ap_isir_matched isir

2386:
2387: CURSOR cur_isir_depend_status (cp_person_id NUMBER)
2388: IS
2389: SELECT isir.dependency_status
2390: FROM igf_ap_fa_base_rec fabase,igf_ap_isir_matched isir
2391: WHERE isir.base_id = fabase.base_id
2392: AND isir.payment_isir = 'Y'
2393: AND isir.system_record_type = 'ORIGINAL'
2394: AND fabase.person_id = cp_person_id;

Line 2402: lv_s_license_number igf_ap_isir_matched.driver_license_number%TYPE;

2398: ln_rowid ROWID;
2399: ln_pnpp_id NUMBER;
2400: lv_p_permt_phone igf_sl_lor_loc_all.s_permt_phone%TYPE;
2401: lv_s_permt_phone igf_sl_lor_loc_all.s_permt_phone%TYPE;
2402: lv_s_license_number igf_ap_isir_matched.driver_license_number%TYPE;
2403: lv_s_license_state igf_ap_isir_matched.driver_license_state%TYPE;
2404: lv_s_citizenship_status VARCHAR2(30);
2405: lv_alien_reg_num igf_ap_isir_matched.alien_reg_number%TYPE;
2406: --

Line 2403: lv_s_license_state igf_ap_isir_matched.driver_license_state%TYPE;

2399: ln_pnpp_id NUMBER;
2400: lv_p_permt_phone igf_sl_lor_loc_all.s_permt_phone%TYPE;
2401: lv_s_permt_phone igf_sl_lor_loc_all.s_permt_phone%TYPE;
2402: lv_s_license_number igf_ap_isir_matched.driver_license_number%TYPE;
2403: lv_s_license_state igf_ap_isir_matched.driver_license_state%TYPE;
2404: lv_s_citizenship_status VARCHAR2(30);
2405: lv_alien_reg_num igf_ap_isir_matched.alien_reg_number%TYPE;
2406: --
2407: lv_dependency_status igf_ap_isir_matched.dependency_status%TYPE;

Line 2405: lv_alien_reg_num igf_ap_isir_matched.alien_reg_number%TYPE;

2401: lv_s_permt_phone igf_sl_lor_loc_all.s_permt_phone%TYPE;
2402: lv_s_license_number igf_ap_isir_matched.driver_license_number%TYPE;
2403: lv_s_license_state igf_ap_isir_matched.driver_license_state%TYPE;
2404: lv_s_citizenship_status VARCHAR2(30);
2405: lv_alien_reg_num igf_ap_isir_matched.alien_reg_number%TYPE;
2406: --
2407: lv_dependency_status igf_ap_isir_matched.dependency_status%TYPE;
2408: lv_s_legal_res_date igf_ap_isir_matched.s_legal_resd_date%TYPE;
2409: lv_s_legal_res_state igf_ap_isir_matched.s_state_legal_residence%TYPE;

Line 2407: lv_dependency_status igf_ap_isir_matched.dependency_status%TYPE;

2403: lv_s_license_state igf_ap_isir_matched.driver_license_state%TYPE;
2404: lv_s_citizenship_status VARCHAR2(30);
2405: lv_alien_reg_num igf_ap_isir_matched.alien_reg_number%TYPE;
2406: --
2407: lv_dependency_status igf_ap_isir_matched.dependency_status%TYPE;
2408: lv_s_legal_res_date igf_ap_isir_matched.s_legal_resd_date%TYPE;
2409: lv_s_legal_res_state igf_ap_isir_matched.s_state_legal_residence%TYPE;
2410:
2411:

Line 2408: lv_s_legal_res_date igf_ap_isir_matched.s_legal_resd_date%TYPE;

2404: lv_s_citizenship_status VARCHAR2(30);
2405: lv_alien_reg_num igf_ap_isir_matched.alien_reg_number%TYPE;
2406: --
2407: lv_dependency_status igf_ap_isir_matched.dependency_status%TYPE;
2408: lv_s_legal_res_date igf_ap_isir_matched.s_legal_resd_date%TYPE;
2409: lv_s_legal_res_state igf_ap_isir_matched.s_state_legal_residence%TYPE;
2410:
2411:
2412: BEGIN

Line 2409: lv_s_legal_res_state igf_ap_isir_matched.s_state_legal_residence%TYPE;

2405: lv_alien_reg_num igf_ap_isir_matched.alien_reg_number%TYPE;
2406: --
2407: lv_dependency_status igf_ap_isir_matched.dependency_status%TYPE;
2408: lv_s_legal_res_date igf_ap_isir_matched.s_legal_resd_date%TYPE;
2409: lv_s_legal_res_state igf_ap_isir_matched.s_state_legal_residence%TYPE;
2410:
2411:
2412: BEGIN
2413:

Line 3195: p_active igf_ap_isir_matched.active_isir%TYPE

3191:
3192: l_award_ref c_award_ref%ROWTYPE;
3193:
3194: CURSOR c_act_isir(cp_base_id NUMBER,
3195: p_active igf_ap_isir_matched.active_isir%TYPE
3196: )
3197: IS
3198:
3199: SELECT 1

Line 3200: FROM igf_ap_isir_matched isir

3196: )
3197: IS
3198:
3199: SELECT 1
3200: FROM igf_ap_isir_matched isir
3201: WHERE isir.base_id = cp_base_id
3202: AND isir.active_isir = p_active;
3203:
3204: l_act_isir c_act_isir%ROWTYPE;

Line 3338: FROM igf_ap_isir_matched_all

3334:
3335: CURSOR c_chk_isir_dtls(p_base_id NUMBER, p_transaction_num NUMBER)
3336: IS
3337: SELECT isir_id
3338: FROM igf_ap_isir_matched_all
3339: WHERE TO_NUMBER(transaction_num) = p_transaction_num
3340: AND base_id = p_base_id;
3341:
3342: chk_isir_dtls_rec c_chk_isir_dtls%ROWTYPE;