APPS.CSF_ACCESS_HOURS_PUB dependencies on CSF_ACCESS_HOURS_VL

Line 319: from csf_access_hours_vl

315: SUNDAY_FIRST_END,
316: SUNDAY_SECOND_START,
317: SUNDAY_SECOND_END,
318: DESCRIPTION
319: from csf_access_hours_vl
320: where task_id=p_task_id;
321:
322: l_accesshour_required varchar2(1);
323: l_after_hours_flag varchar2(1);

Line 687: CURSOR C_EXISTS(p_task_id number) is select 'Y' from csf_access_hours_vl where task_id=p_task_id;

683: l_cnt number;
684: l_msg varchar2(2000);
685: l_temp varchar2(1);
686:
687: CURSOR C_EXISTS(p_task_id number) is select 'Y' from csf_access_hours_vl where task_id=p_task_id;
688:
689: BEGIN
690: SAVEPOINT create_access_hours_pub;
691: x_return_status := fnd_api.g_ret_sts_success;

Line 950: from csf_access_hours_vl

946: SUNDAY_SECOND_START,
947: SUNDAY_SECOND_END,
948: DESCRIPTION,
949: object_version_number
950: from csf_access_hours_vl
951: where task_id=p_task_id;
952:
953: l_ACCESS_HOUR_REQD VARCHAR2(1);
954:

Line 990: CURSOR C_EXISTS(p_task_id number) is select 'Y' from csf_access_hours_vl where task_id=p_task_id;

986:
987: l_task_status varchar2(1);
988: l_temp varchar2(1);
989:
990: CURSOR C_EXISTS(p_task_id number) is select 'Y' from csf_access_hours_vl where task_id=p_task_id;
991:
992: BEGIN
993: SAVEPOINT update_access_hours_pub;
994: x_return_status := fnd_api.g_ret_sts_success;

Line 1413: CURSOR C_EXISTS(p_task_id number) is select 'Y' from csf_access_hours_vl where task_id=p_task_id;

1409: l_msg varchar2(2000);
1410: l_task_status varchar2(1);
1411: l_temp varchar2(1);
1412:
1413: CURSOR C_EXISTS(p_task_id number) is select 'Y' from csf_access_hours_vl where task_id=p_task_id;
1414:
1415: BEGIN
1416: SAVEPOINT delete_access_hours_pub;
1417: x_return_status := fnd_api.g_ret_sts_success;

Line 1549: from csf_access_hours_vl

1545: ACCESSHOUR_REQUIRED,
1546: AFTER_HOURS_FLAG,
1547: DESCRIPTION,
1548: object_version_number
1549: from csf_access_hours_vl
1550: where task_id=p_task_id;
1551:
1552: l_rec c_existing_values%rowtype;
1553: l_object_version_number number;