DBA Data[Home] [Help]

APPS.CS_AUTOGEN_TASK_PVT dependencies on CS_SR_TSK_TMPL_GP_MAP

Line 563: From cs_sr_tsk_tmpl_gp_map

559: p_num NUMBER,
560: p_char VARCHAR2)
561: Is
562: Select task_template_group_id
563: From cs_sr_tsk_tmpl_gp_map
564: Where decode(p_incident_type_id, p_null_num, p_num, incident_type_id) = nvl(p_incident_type_id, p_num)
565: And decode(p_organization_id, p_null_num, p_num, organization_id) = nvl(p_organization_id, p_num)
566: And decode(p_inventory_item_id, p_null_num, p_num, inventory_item_id) = nvl(p_inventory_item_id, p_num)
567: And decode(p_category_id, p_null_num, p_num, category_id) = nvl(p_category_id, p_num)

Line 582: From cs_sr_tsk_tmpl_gp_map gp,

578: p_num NUMBER,
579: p_char VARCHAR2)
580: Is
581: Select gp.task_template_group_id
582: From cs_sr_tsk_tmpl_gp_map gp,
583: jtf_task_temp_groups_vl jtf
584: Where nvl(gp.incident_type_id, p_num) = nvl(p_incident_type_id, p_num)
585: And nvl(gp.organization_id, p_num) = nvl(p_organization_id, p_num)
586: And nvl(gp.inventory_item_id, p_num) = nvl(p_inventory_item_id, p_num)