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

Line 3673: igf_ap_isir_matched isir

3669: CURSOR cur_isir_depend_status (cp_person_id NUMBER)
3670: IS
3671: SELECT isir.dependency_status
3672: FROM igf_ap_fa_base_rec fabase,
3673: igf_ap_isir_matched isir
3674: WHERE isir.payment_isir = 'Y'
3675: AND isir.system_record_type = 'ORIGINAL'
3676: AND isir.base_id = fabase.base_id
3677: AND fabase.person_id = cp_person_id;

Line 3707: lv_p_citizenship_status igf_ap_isir_matched_all.citizenship_status%TYPE;

3703: lv_s_citizenship_status VARCHAR2(30);
3704:
3705:
3706: lv_p_permt_phone igf_sl_lor_loc_all.s_permt_phone%TYPE;
3707: lv_p_citizenship_status igf_ap_isir_matched_all.citizenship_status%TYPE;
3708: lv_p_foreign_postal_code igf_sl_lor_loc_all.s_foreign_postal_code%TYPE;
3709: lv_s_permt_phone igf_sl_lor_loc_all.s_permt_phone%TYPE;
3710: lv_s_license_number igf_ap_isir_matched.driver_license_number%TYPE;
3711: lv_s_license_state igf_ap_isir_matched.driver_license_state%TYPE;

Line 3710: lv_s_license_number igf_ap_isir_matched.driver_license_number%TYPE;

3706: lv_p_permt_phone igf_sl_lor_loc_all.s_permt_phone%TYPE;
3707: lv_p_citizenship_status igf_ap_isir_matched_all.citizenship_status%TYPE;
3708: lv_p_foreign_postal_code igf_sl_lor_loc_all.s_foreign_postal_code%TYPE;
3709: lv_s_permt_phone igf_sl_lor_loc_all.s_permt_phone%TYPE;
3710: lv_s_license_number igf_ap_isir_matched.driver_license_number%TYPE;
3711: lv_s_license_state igf_ap_isir_matched.driver_license_state%TYPE;
3712: lv_alien_reg_num igf_ap_isir_matched.alien_reg_number%TYPE;
3713: lv_dependency_status igf_ap_isir_matched.dependency_status%TYPE;
3714: lv_s_legal_res_date igf_ap_isir_matched.s_legal_resd_date%TYPE;

Line 3711: lv_s_license_state igf_ap_isir_matched.driver_license_state%TYPE;

3707: lv_p_citizenship_status igf_ap_isir_matched_all.citizenship_status%TYPE;
3708: lv_p_foreign_postal_code igf_sl_lor_loc_all.s_foreign_postal_code%TYPE;
3709: lv_s_permt_phone igf_sl_lor_loc_all.s_permt_phone%TYPE;
3710: lv_s_license_number igf_ap_isir_matched.driver_license_number%TYPE;
3711: lv_s_license_state igf_ap_isir_matched.driver_license_state%TYPE;
3712: lv_alien_reg_num igf_ap_isir_matched.alien_reg_number%TYPE;
3713: lv_dependency_status igf_ap_isir_matched.dependency_status%TYPE;
3714: lv_s_legal_res_date igf_ap_isir_matched.s_legal_resd_date%TYPE;
3715: lv_s_legal_res_state igf_ap_isir_matched.s_state_legal_residence%TYPE;

Line 3712: lv_alien_reg_num igf_ap_isir_matched.alien_reg_number%TYPE;

3708: lv_p_foreign_postal_code igf_sl_lor_loc_all.s_foreign_postal_code%TYPE;
3709: lv_s_permt_phone igf_sl_lor_loc_all.s_permt_phone%TYPE;
3710: lv_s_license_number igf_ap_isir_matched.driver_license_number%TYPE;
3711: lv_s_license_state igf_ap_isir_matched.driver_license_state%TYPE;
3712: lv_alien_reg_num igf_ap_isir_matched.alien_reg_number%TYPE;
3713: lv_dependency_status igf_ap_isir_matched.dependency_status%TYPE;
3714: lv_s_legal_res_date igf_ap_isir_matched.s_legal_resd_date%TYPE;
3715: lv_s_legal_res_state igf_ap_isir_matched.s_state_legal_residence%TYPE;
3716: ln_cbth_id igf_sl_cl_batch_all.cbth_id%TYPE;

Line 3713: lv_dependency_status igf_ap_isir_matched.dependency_status%TYPE;

3709: lv_s_permt_phone igf_sl_lor_loc_all.s_permt_phone%TYPE;
3710: lv_s_license_number igf_ap_isir_matched.driver_license_number%TYPE;
3711: lv_s_license_state igf_ap_isir_matched.driver_license_state%TYPE;
3712: lv_alien_reg_num igf_ap_isir_matched.alien_reg_number%TYPE;
3713: lv_dependency_status igf_ap_isir_matched.dependency_status%TYPE;
3714: lv_s_legal_res_date igf_ap_isir_matched.s_legal_resd_date%TYPE;
3715: lv_s_legal_res_state igf_ap_isir_matched.s_state_legal_residence%TYPE;
3716: ln_cbth_id igf_sl_cl_batch_all.cbth_id%TYPE;
3717: l_clrp1_id igf_sl_cl_resp_r1_all.clrp1_id%TYPE;

Line 3714: lv_s_legal_res_date igf_ap_isir_matched.s_legal_resd_date%TYPE;

3710: lv_s_license_number igf_ap_isir_matched.driver_license_number%TYPE;
3711: lv_s_license_state igf_ap_isir_matched.driver_license_state%TYPE;
3712: lv_alien_reg_num igf_ap_isir_matched.alien_reg_number%TYPE;
3713: lv_dependency_status igf_ap_isir_matched.dependency_status%TYPE;
3714: lv_s_legal_res_date igf_ap_isir_matched.s_legal_resd_date%TYPE;
3715: lv_s_legal_res_state igf_ap_isir_matched.s_state_legal_residence%TYPE;
3716: ln_cbth_id igf_sl_cl_batch_all.cbth_id%TYPE;
3717: l_clrp1_id igf_sl_cl_resp_r1_all.clrp1_id%TYPE;
3718:

Line 3715: lv_s_legal_res_state igf_ap_isir_matched.s_state_legal_residence%TYPE;

3711: lv_s_license_state igf_ap_isir_matched.driver_license_state%TYPE;
3712: lv_alien_reg_num igf_ap_isir_matched.alien_reg_number%TYPE;
3713: lv_dependency_status igf_ap_isir_matched.dependency_status%TYPE;
3714: lv_s_legal_res_date igf_ap_isir_matched.s_legal_resd_date%TYPE;
3715: lv_s_legal_res_state igf_ap_isir_matched.s_state_legal_residence%TYPE;
3716: ln_cbth_id igf_sl_cl_batch_all.cbth_id%TYPE;
3717: l_clrp1_id igf_sl_cl_resp_r1_all.clrp1_id%TYPE;
3718:
3719: l_disb_interface c_disb_interface%ROWTYPE;

Line 5129: FROM igf_ap_isir_matched isir

5125:
5126: CURSOR c_act_isir(cp_base_id NUMBER)
5127: IS
5128: SELECT 1
5129: FROM igf_ap_isir_matched isir
5130: WHERE isir.base_id = cp_base_id
5131: AND isir.active_isir = 'Y';
5132:
5133: l_act_isir c_act_isir%ROWTYPE;