APPS.CS_ERES_INT_PKG dependencies on DUAL

Line 649: FROM DUAL;

645: AND obj.object_code (+) = SrLnkEO.object_type
646: AND obj.language (+) = userenv('LANG')
647: AND sysdate between nvl(SrLnkEO.start_date_active,sysdate)
648: AND nvl(SrLnkEO.end_date_active,sysdate) ) AS cs_sr_related_OBJ_list_t) RELATED_OB_LIST
649: FROM DUAL;
650:
651: l_rel_onj_list cs_sr_related_OBJ_list_t;
652:
653: BEGIN

Line 697: FROM DUAL;

693: AND tlSR.incident_id = relSR.incident_id
694: AND tlSR.language = userenv('lang')
695: AND sysdate between nvl(SrLnkEO.start_date_active,sysdate)
696: AND nvl(SrLnkEO.end_date_active,sysdate) ) AS cs_sr_related_SR_list_t) RELATED_SR_LIST
697: FROM DUAL;
698:
699: l_rel_sr_list cs_sr_related_SR_list_t;
700:
701: BEGIN

Line 751: FROM DUAL;

747: AND ext_usert.language (+)= userenv('LANG')
748: AND ext_userb.resource_id = ext_usert.resource_id (+)
749: AND ext_userb.category = ext_usert.category (+)
750: order by JNB.entered_date ) AS cs_sr_note_list_t) NOTE_LIST
751: FROM DUAL;
752:
753: l_note_list cs_sr_note_list_t;
754: CURSOR timezone_code(l_time_zone_id Number) IS -- Bug 11830349
755: Select timezone_code

Line 849: FROM DUAL;

845: AND obj_vl.object_code = jtf1B.owner_type_code
846: AND obj_vl.LANGUAGE = userenv('LANG')
847: AND jtf1B.parent_task_id = jtf2.task_id (+)
848: ORDER BY jtf1B.creation_date) AS cs_sr_task_list_t) TASK_LIST
849: FROM DUAL;
850:
851: l_task_list cs_sr_task_list_t;
852: CURSOR timezone_code(l_time_zone_id Number) IS -- Bug 11830349
853: Select timezone_code

Line 1918: FROM DUAL';

1914: , CS_ERES_INT_PKG.Get_SR_Tasks (:INCIDENT_ID, :L_SOURCE_TIMEZONE_ID, :L_DESC_TIMEZONE_ID, :L_DATE_FORMAT) AS TASK_LIST
1915: , CS_ERES_INT_PKG.Get_SR_Notes (:incident_id, :l_source_timezone_id, :l_desc_timezone_id, :l_date_format) NOTE_LIST
1916: , CS_ERES_INT_PKG.Get_Related_SRs(:incident_id) RELATED_SR_LIST
1917: , CS_ERES_INT_PKG.Get_Related_Objs(:incident_id) RELATED_OB_LIST
1918: FROM DUAL';
1919:
1920:
1921: END IF ;
1922: