APPS.HR_CA_FF_UDFS dependencies on DUAL

Line 993: from dual

989:
990: begin
991:
992: select 1 INTO l_asg_info_changes
993: from dual
994: where exists (
995: SELECT 1
996: FROM per_assignments_f ASG,
997: per_assignment_status_types AST,

Line 1027: from dual

1023:
1024: begin
1025:
1026: select 1 INTO l_eev_info_changes
1027: from dual
1028: where exists (
1029: SELECT 1
1030: FROM pay_element_entry_values_f EEV
1031: WHERE EEV.element_entry_id = p_ele_entry_id

Line 1073: from dual

1069:
1070: begin
1071:
1072: select 1 INTO l_asg_info_changes
1073: from dual
1074: where exists (
1075: SELECT 1
1076: FROM per_assignments_f ASG,
1077: per_assignment_status_types AST,

Line 1099: from dual

1095:
1096: begin
1097:
1098: select 1 INTO l_eev_info_changes
1099: from dual
1100: where exists (
1101: SELECT 1
1102: FROM pay_element_entry_values_f EEV
1103: WHERE EEV.element_entry_id = p_ele_entry_id

Line 1144: from dual

1140:
1141: hr_utility.set_location('calculate_period_earnings', 53);
1142:
1143: select 1 INTO l_eev_info_changes
1144: from dual
1145: where exists (
1146: SELECT 1
1147: FROM pay_element_entry_values_f EEV
1148: WHERE EEV.element_entry_id = p_ele_entry_id

Line 2529: -- FROM sys.dual;

2525: dt_fndate.set_effective_date (p_effective_date => sysdate);
2526: -- INSERT INTO fnd_sessions
2527: -- SELECT userenv('sessionid'),
2528: -- sysdate
2529: -- FROM sys.dual;
2530: --
2531: END IF;
2532: --
2533: hr_utility.set_location('work_schedule_total_hours', 10);

Line 2586: FROM DUAL;

2582:
2583: SELECT decode(v_day_no,1,'SUN',2,'MON',3,'TUE',
2584: 4,'WED',5,'THU',6,'FRI',7,'SAT')
2585: INTO v_curr_day
2586: FROM DUAL;
2587:
2588: --
2589: hr_utility.set_location('curr_day = '||v_curr_day, 20);
2590: