DBA Data[Home] [Help]

APPS.CN_WEBSERVICE_PUB dependencies on CSF_RESOURCE_PUB

Line 372: csf_resource_pub.get_resource_name(resource_id,

368: , sla_esc
369: , calc_date
370: FROM (SELECT b.task_number, b.task_id, s.NAME assignment_status, b.task_name,
371: pi.party_name customer_name, jtp.NAME priority_name,
372: csf_resource_pub.get_resource_name(resource_id,
373: resource_type_code
374: ) resource_name,
375: resource_id, resource_type_code, b.planned_start_date,
376: b.scheduled_start_date, 'ESC' sla_esc, NULL calc_date

Line 402: csf_resource_pub.get_resource_name(resource_id,

398: AND jtp.task_priority_id = b.task_priority_id
399: UNION
400: SELECT b.task_number, b.task_id, s.NAME assignment_status, b.task_name,
401: pi.party_name customer_name, jtp.NAME priority_name,
402: csf_resource_pub.get_resource_name(resource_id,
403: resource_type_code
404: ) resource_name,
405: resource_id, resource_type_code, b.planned_start_date,
406: b.scheduled_start_date, 'SLA' sla_esc,