APPS.CSF_ACCESS_HOURS_PUB dependencies on CSF_ACCESS_HOURS_VL

Line 323: from csf_access_hours_vl

319: SUNDAY_FIRST_END,
320: SUNDAY_SECOND_START,
321: SUNDAY_SECOND_END,
322: DESCRIPTION
323: from csf_access_hours_vl
324: where task_id=p_task_id;
325:
326: l_accesshour_required varchar2(1);
327: l_after_hours_flag varchar2(1);

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

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

Line 954: from csf_access_hours_vl

950: SUNDAY_SECOND_START,
951: SUNDAY_SECOND_END,
952: DESCRIPTION,
953: object_version_number
954: from csf_access_hours_vl
955: where task_id=p_task_id;
956:
957: l_ACCESS_HOUR_REQD VARCHAR2(1);
958:

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

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

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

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

Line 1553: from csf_access_hours_vl

1549: ACCESSHOUR_REQUIRED,
1550: AFTER_HOURS_FLAG,
1551: DESCRIPTION,
1552: object_version_number
1553: from csf_access_hours_vl
1554: where task_id=p_task_id;
1555:
1556: l_rec c_existing_values%rowtype;
1557: l_object_version_number number;