APPS.AST_WEBASSIST_PVT dependencies on AST_ASSISTS

Line 35: CURSOR c0 IS SELECT 'X' FROM ast_assists

31: l_return_status VARCHAR2(1);
32: l_msg_count NUMBER;
33: l_msg_data VARCHAR2(32767);
34:
35: CURSOR c0 IS SELECT 'X' FROM ast_assists
36: WHERE assist_id = p_assist_rec.assist_id;
37:
38: CURSOR c1 IS SELECT 'X' FROM ast_web_assists
39: WHERE web_assist_id = p_web_assist_rec.web_assist_id;

Line 129: INSERT INTO ast_assists(

125: THEN
126: OPEN c0;
127: FETCH c0 INTO P_DUMMY;
128: IF c0%notfound THEN
129: INSERT INTO ast_assists(
130: assist_id,
131: object_version_number,
132: last_update_date,
133: last_updated_by,

Line 566: FROM ast_assists

562: DECLARE
563: v_dummy char(1);
564:
565: CURSOR c1 IS SELECT 'X'
566: FROM ast_assists
567: WHERE assist_id = p_assist_rec.assist_id
568: FOR UPDATE;
569: BEGIN
570: OPEN c1;