APPS.CS_AUTOGEN_TASK_PVT dependencies on CS_SR_TSK_TMPL_GP_MAP

Line 485: From cs_sr_tsk_tmpl_gp_map

481: p_num NUMBER,
482: p_char VARCHAR2)
483: Is
484: Select task_template_group_id
485: From cs_sr_tsk_tmpl_gp_map
486: Where decode(p_incident_type_id, p_null_num, p_num, incident_type_id) = nvl(p_incident_type_id, p_num)
487: And decode(p_organization_id, p_null_num, p_num, organization_id) = nvl(p_organization_id, p_num)
488: And decode(p_inventory_item_id, p_null_num, p_num, inventory_item_id) = nvl(p_inventory_item_id, p_num)
489: And decode(p_category_id, p_null_num, p_num, category_id) = nvl(p_category_id, p_num)

Line 504: From cs_sr_tsk_tmpl_gp_map gp,

500: p_num NUMBER,
501: p_char VARCHAR2)
502: Is
503: Select gp.task_template_group_id
504: From cs_sr_tsk_tmpl_gp_map gp,
505: jtf_task_temp_groups_vl jtf
506: Where nvl(gp.incident_type_id, p_num) = nvl(p_incident_type_id, p_num)
507: And nvl(gp.organization_id, p_num) = nvl(p_organization_id, p_num)
508: And nvl(gp.inventory_item_id, p_num) = nvl(p_inventory_item_id, p_num)