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.PV_BATCH_CHG_PRTNR_PVT dependencies on PV_PARTNER_PROFILES

Line 882: -- check, the supplied partner in the PV_PARTNER_PROFILES table is ACTIVE and EXISTS.

878: p_batch_chg_prtnrs_rec IN Batch_Chg_Prtnrs_Rec_Type,
879: x_return_status OUT NOCOPY VARCHAR2
880: )
881: IS
882: -- check, the supplied partner in the PV_PARTNER_PROFILES table is ACTIVE and EXISTS.
883: CURSOR l_chk_partner_active_csr(cv_partner_id IN NUMBER) IS
884: SELECT 'Y'
885: FROM pv_partner_profiles
886: WHERE partner_id = cv_partner_id

Line 885: FROM pv_partner_profiles

881: IS
882: -- check, the supplied partner in the PV_PARTNER_PROFILES table is ACTIVE and EXISTS.
883: CURSOR l_chk_partner_active_csr(cv_partner_id IN NUMBER) IS
884: SELECT 'Y'
885: FROM pv_partner_profiles
886: WHERE partner_id = cv_partner_id
887: AND status = 'A';
888:
889: -- Local variale declaration.