APPS.CSF_GPS_PUB dependencies on CSF_GPS_VENDORS_B

Line 37: FROM csf_gps_vendors_b WHERE enabled = 'Y';

33: FUNCTION is_gps_enabled RETURN VARCHAR2 IS
34: l_enabled VARCHAR2(1);
35: CURSOR c_vendors IS
36: SELECT DECODE(COUNT(*), 0, 'N', 'Y')
37: FROM csf_gps_vendors_b WHERE enabled = 'Y';
38: BEGIN
39: OPEN c_vendors;
40: FETCH c_vendors INTO l_enabled;
41: CLOSE c_vendors;

Line 529: WHERE NOT EXISTS (SELECT NULL FROM csf_gps_vendors_b b WHERE b.vendor_id = t.vendor_id);

525:
526: PROCEDURE add_language IS
527: BEGIN
528: DELETE FROM csf_gps_vendors_tl t
529: WHERE NOT EXISTS (SELECT NULL FROM csf_gps_vendors_b b WHERE b.vendor_id = t.vendor_id);
530:
531: UPDATE csf_gps_vendors_tl cgvt
532: SET (cgvt.vendor_name, cgvt.description) = (
533: SELECT cgvtl.vendor_name, cgvtl.description