DBA Data[Home] [Help]

APPS.OKE_COMM_ACT_UTILS dependencies on FND_LOOKUP_VALUES_VL

Line 357: FROM fnd_lookup_values_vl

353: WHERE user_id = P_Updated_By;
354:
355: CURSOR comm_type IS
356: SELECT meaning
357: FROM fnd_lookup_values_vl
358: WHERE lookup_type='COMMUNICATION_TYPE'
359: AND lookup_code=P_TYPE
360: AND view_application_id=777;
361:

Line 364: FROM fnd_lookup_values_vl

360: AND view_application_id=777;
361:
362: CURSOR comm_reason IS
363: SELECT meaning
364: FROM fnd_lookup_values_vl
365: WHERE lookup_type='COMMUNICATION_REASON_CODE'
366: AND lookup_code=P_REASON_CODE
367: AND view_application_id=777;
368:

Line 392: FROM fnd_lookup_values_vl

388: AND orig_system_id = P_Owner;
389:
390: CURSOR comm_priority IS
391: SELECT meaning
392: FROM fnd_lookup_values_vl
393: WHERE lookup_type='COMMUNICATION_PRIORITY'
394: AND lookup_code=P_PRIORITY_CODE
395: AND view_application_id=777;
396: