APPS.HR_US_FF_UDFS dependencies on DUAL

Line 1351: from dual

1347:
1348: BEGIN /* Check ASGMPE */
1349:
1350: select 1 INTO l_asg_info_changes
1351: from dual
1352: where exists (
1353: SELECT 1
1354: FROM per_assignments_f ASG,
1355: per_assignment_status_types AST,

Line 1379: from dual

1375:
1376: BEGIN /* EEVMPE check - maybe pick*/
1377:
1378: select 1 INTO l_eev_info_changes
1379: from dual
1380: where exists (
1381: SELECT 1
1382: FROM pay_element_entry_values_f EEV
1383: WHERE EEV.element_entry_id = p_ele_entry_id

Line 1424: from dual

1420:
1421: BEGIN /* ASGMPS changes */
1422:
1423: select 1 INTO l_asg_info_changes
1424: from dual
1425: where exists (
1426: SELECT 1
1427: FROM per_assignments_f ASG,
1428: per_assignment_status_types AST,

Line 1447: from dual

1443:
1444: BEGIN /* EEVMPE changes ASGMPS */
1445:
1446: select 1 INTO l_eev_info_changes
1447: from dual
1448: where exists (
1449: SELECT 1
1450: FROM pay_element_entry_values_f EEV
1451: WHERE EEV.element_entry_id = p_ele_entry_id

Line 1494: from dual

1490: hr_utility.set_location('calculate_period_earnings', 58);
1491: hr_utility.trace('Check for EEVMPE changes nevertheless');
1492:
1493: select 1 INTO l_eev_info_changes
1494: from dual
1495: where exists (
1496: SELECT 1
1497: FROM pay_element_entry_values_f EEV
1498: WHERE EEV.element_entry_id = p_ele_entry_id

Line 2962: FROM DUAL;

2958:
2959: SELECT decode(v_day_no,1,'SUN',2,'MON',3,'TUE',
2960: 4,'WED',5,'THU',6,'FRI',7,'SAT')
2961: INTO v_curr_day
2962: FROM DUAL;
2963:
2964: --
2965: --
2966: v_total_hours := v_total_hours + FND_NUMBER.CANONICAL_TO_NUMBER(hruserdt.get_table_value(p_bg_id,