APPS.CS_ERES_INT_PKG dependencies on DUAL

Line 633: FROM DUAL;

629: AND obj.object_code (+) = SrLnkEO.object_type
630: AND obj.language (+) = userenv('LANG')
631: AND sysdate between nvl(SrLnkEO.start_date_active,sysdate)
632: AND nvl(SrLnkEO.end_date_active,sysdate) ) AS cs_sr_related_OBJ_list_t) RELATED_OB_LIST
633: FROM DUAL;
634:
635: l_rel_onj_list cs_sr_related_OBJ_list_t;
636:
637: BEGIN

Line 681: FROM DUAL;

677: AND tlSR.incident_id = relSR.incident_id
678: AND tlSR.language = userenv('lang')
679: AND sysdate between nvl(SrLnkEO.start_date_active,sysdate)
680: AND nvl(SrLnkEO.end_date_active,sysdate) ) AS cs_sr_related_SR_list_t) RELATED_SR_LIST
681: FROM DUAL;
682:
683: l_rel_sr_list cs_sr_related_SR_list_t;
684:
685: BEGIN

Line 729: FROM DUAL;

725: AND ext_usert.language (+)= userenv('LANG')
726: AND ext_userb.resource_id = ext_usert.resource_id (+)
727: AND ext_userb.category = ext_usert.category (+)
728: order by JNB.entered_date ) AS cs_sr_note_list_t) NOTE_LIST
729: FROM DUAL;
730:
731: l_note_list cs_sr_note_list_t;
732:
733: BEGIN

Line 802: FROM DUAL;

798: AND obj_vl.object_code = jtf1B.owner_type_code
799: AND obj_vl.LANGUAGE = userenv('LANG')
800: AND jtf1B.parent_task_id = jtf2.task_id (+)
801: ORDER BY jtf1B.creation_date) AS cs_sr_task_list_t) TASK_LIST
802: FROM DUAL;
803:
804: l_task_list cs_sr_task_list_t;
805:
806: BEGIN

Line 1833: FROM DUAL';

1829: , CS_ERES_INT_PKG.Get_SR_Tasks (:INCIDENT_ID, :L_SOURCE_TIMEZONE_ID, :L_DESC_TIMEZONE_ID, :L_DATE_FORMAT) AS TASK_LIST
1830: , CS_ERES_INT_PKG.Get_SR_Notes (:incident_id, :l_source_timezone_id, :l_desc_timezone_id, :l_date_format) NOTE_LIST
1831: , CS_ERES_INT_PKG.Get_Related_SRs(:incident_id) RELATED_SR_LIST
1832: , CS_ERES_INT_PKG.Get_Related_Objs(:incident_id) RELATED_OB_LIST
1833: FROM DUAL';
1834:
1835:
1836: END IF ;
1837: