APPS.HR_CA_FF_UDFS dependencies on DUAL

Line 987: from dual

983:
984: begin
985:
986: select 1 INTO l_asg_info_changes
987: from dual
988: where exists (
989: SELECT 1
990: FROM per_assignments_f ASG,
991: per_assignment_status_types AST,

Line 1021: from dual

1017:
1018: begin
1019:
1020: select 1 INTO l_eev_info_changes
1021: from dual
1022: where exists (
1023: SELECT 1
1024: FROM pay_element_entry_values_f EEV
1025: WHERE EEV.element_entry_id = p_ele_entry_id

Line 1067: from dual

1063:
1064: begin
1065:
1066: select 1 INTO l_asg_info_changes
1067: from dual
1068: where exists (
1069: SELECT 1
1070: FROM per_assignments_f ASG,
1071: per_assignment_status_types AST,

Line 1093: from dual

1089:
1090: begin
1091:
1092: select 1 INTO l_eev_info_changes
1093: from dual
1094: where exists (
1095: SELECT 1
1096: FROM pay_element_entry_values_f EEV
1097: WHERE EEV.element_entry_id = p_ele_entry_id

Line 1138: from dual

1134:
1135: hr_utility.set_location('calculate_period_earnings', 53);
1136:
1137: select 1 INTO l_eev_info_changes
1138: from dual
1139: where exists (
1140: SELECT 1
1141: FROM pay_element_entry_values_f EEV
1142: WHERE EEV.element_entry_id = p_ele_entry_id

Line 2492: -- FROM sys.dual;

2488: dt_fndate.set_effective_date (p_effective_date => sysdate);
2489: -- INSERT INTO fnd_sessions
2490: -- SELECT userenv('sessionid'),
2491: -- sysdate
2492: -- FROM sys.dual;
2493: --
2494: END IF;
2495: --
2496: hr_utility.set_location('work_schedule_total_hours', 10);

Line 2549: FROM DUAL;

2545:
2546: SELECT decode(v_day_no,1,'SUN',2,'MON',3,'TUE',
2547: 4,'WED',5,'THU',6,'FRI',7,'SAT')
2548: INTO v_curr_day
2549: FROM DUAL;
2550:
2551: --
2552: hr_utility.set_location('curr_day = '||v_curr_day, 20);
2553: