APPS.JTF_EC_WORKFLOW_PKG dependencies on HZ_PARTIES

Line 1036: l_customer_name hz_parties.party_name%TYPE := NULL;

1032: l_esc_level fnd_lookups.meaning%TYPE;
1033: l_temp_status VARCHAR2(1);
1034: -- l_found VARCHAR2(1) := 'x';
1035: l_counter NUMBER(5);
1036: l_customer_name hz_parties.party_name%TYPE := NULL;
1037: l_event VARCHAR2(50) DEFAULT NULL;
1038: l_doc_number jtf_task_references_vl.object_name%TYPE;
1039: l_owner_name VARCHAR2(200);
1040: l_doc_type jtf_objects_vl.name%TYPE;

Line 1092: hz_parties p

1088: -------------------------------------------------------------------------
1089: cursor c_cust_name is
1090: SELECT p.party_name customer_name
1091: FROM jtf_tasks_vl t,
1092: hz_parties p
1093: WHERE t.task_id = p_task_id
1094: AND t.customer_id = p.party_id;
1095:
1096: -------------------------------------------------------------------------