DBA Data[Home] [Help]

APPS.PV_TAP_ACCESS_TERRS_PVT dependencies on PV_PARTNER_ACCESSES

Line 918: -- check, the supplied partner_access_id in the PV_PARTNER_ACCESSES table EXISTS.

914: p_tap_access_terrs_rec IN tap_access_terrs_rec_type,
915: x_return_status OUT NOCOPY VARCHAR2
916: )
917: IS
918: -- check, the supplied partner_access_id in the PV_PARTNER_ACCESSES table EXISTS.
919: CURSOR l_chk_paccess_active_csr(cv_partner_access_id IN NUMBER) IS
920: SELECT 'Y'
921: FROM pv_partner_accesses
922: WHERE partner_access_id = cv_partner_access_id;

Line 921: FROM pv_partner_accesses

917: IS
918: -- check, the supplied partner_access_id in the PV_PARTNER_ACCESSES table EXISTS.
919: CURSOR l_chk_paccess_active_csr(cv_partner_access_id IN NUMBER) IS
920: SELECT 'Y'
921: FROM pv_partner_accesses
922: WHERE partner_access_id = cv_partner_access_id;
923:
924: -- check, the supplied territory in the JTF_TERR_ALL table is ACTIVE and EXISTS.
925: CURSOR l_chk_terr_active_csr(cv_terr_id IN NUMBER) IS