APPS.JTF_EC_WORKFLOW_PKG dependencies on FND_LOOKUPS

Line 1032: l_esc_level fnd_lookups.meaning%TYPE;

1028: l_old_owner_id jtf_tasks_vl.owner_id%TYPE := p_old_owner_id;
1029: --l_old_owner_type_code jtf_tasks_vl.owner_type_code%TYPE := p_old_owner_type_code;
1030: l_user_name per_people_f.full_name%TYPE;
1031: l_esc_status jtf_ec_statuses_vl.description%TYPE;
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;

Line 1111: FROM fnd_lookups

1107: -------------------------------------------------------------------------
1108:
1109: cursor c_esc_level (p_level in VARCHAR2) is
1110: SELECT meaning
1111: FROM fnd_lookups
1112: WHERE lookup_code = p_level
1113: AND lookup_type = 'JTF_TASK_ESC_LEVEL'
1114: AND enabled_flag = 'Y'
1115: AND start_date_active < sysdate

Line 1124: FROM fnd_lookups

1120: -------------------------------------------------------------------------
1121:
1122: cursor c_esc_old_level (p_level in VARCHAR2) is
1123: SELECT meaning
1124: FROM fnd_lookups
1125: WHERE lookup_code = p_level
1126: AND lookup_type = 'JTF_TASK_ESC_LEVEL';
1127:
1128: -------------------------------------------------------------------------