APPS.HZ_DSS_VALIDATE_PKG dependencies on HZ_DSS_ASSIGNMENTS

Line 343: -- Return Y if the assignment code exists in hz_dss_assignments

339: -- exist_in_dss_assignments
340: --------------------------------------------
341:
342: FUNCTION exist_in_dss_assignments
343: -- Return Y if the assignment code exists in hz_dss_assignments
344: -- N otherwise
345: (p_assignment_id VARCHAR2 )
346: RETURN VARCHAR2
347: IS

Line 351: FROM hz_dss_assignments

347: IS
348: CURSOR c0
349: IS
350: SELECT 'Y'
351: FROM hz_dss_assignments
352: WHERE assignment_id = p_assignment_id ;
353: l_yn VARCHAR2(1);
354: result VARCHAR2(1);
355: BEGIN