APPS.JTF_TASK_PHONES_PUB dependencies on JTF_TASKS_B

Line 82: l_task_id jtf_tasks_b.task_id%TYPE;

78: l_api_version CONSTANT NUMBER := 1.0;
79: l_api_name CONSTANT VARCHAR2(30)
80: := 'CREATE_TASK_PHONES';
81: l_rowid ROWID;
82: l_task_id jtf_tasks_b.task_id%TYPE;
83: l_contact_id jtf_task_contacts.contact_id%TYPE;
84: l_task_phone_id jtf_task_phones.task_phone_id%TYPE;
85: x CHAR;
86:

Line 532: FROM jtf_tasks_b

528: ELSE
529: BEGIN
530: SELECT customer_id
531: INTO l_contact_id
532: FROM jtf_tasks_b
533: WHERE task_id = l_task_contact_id;
534: EXCEPTION
535: WHEN NO_DATA_FOUND
536: THEN

Line 823: FROM jtf_tasks_b

819: WHERE contact_point_id =
820: p_phone_id
821: AND owner_table_id =
822: (SELECT customer_id
823: FROM jtf_tasks_b
824: WHERE task_id =
825: p_task_contact_id))
826: AND owner_table_id =
827: (SELECT customer_id

Line 828: FROM jtf_tasks_b

824: WHERE task_id =
825: p_task_contact_id))
826: AND owner_table_id =
827: (SELECT customer_id
828: FROM jtf_tasks_b
829: WHERE task_id =
830: p_task_contact_id))
831: AND primary_flag = 'Y';
832: END IF;