APPS.HR_US_FF_UDFS dependencies on DUAL

Line 1360: from dual

1356:
1357: BEGIN /* Check ASGMPE */
1358:
1359: select 1 INTO l_asg_info_changes
1360: from dual
1361: where exists (
1362: SELECT 1
1363: FROM per_assignments_f ASG,
1364: per_assignment_status_types AST,

Line 1388: from dual

1384:
1385: BEGIN /* EEVMPE check - maybe pick*/
1386:
1387: select 1 INTO l_eev_info_changes
1388: from dual
1389: where exists (
1390: SELECT 1
1391: FROM pay_element_entry_values_f EEV
1392: WHERE EEV.element_entry_id = p_ele_entry_id

Line 1433: from dual

1429:
1430: BEGIN /* ASGMPS changes */
1431:
1432: select 1 INTO l_asg_info_changes
1433: from dual
1434: where exists (
1435: SELECT 1
1436: FROM per_assignments_f ASG,
1437: per_assignment_status_types AST,

Line 1456: from dual

1452:
1453: BEGIN /* EEVMPE changes ASGMPS */
1454:
1455: select 1 INTO l_eev_info_changes
1456: from dual
1457: where exists (
1458: SELECT 1
1459: FROM pay_element_entry_values_f EEV
1460: WHERE EEV.element_entry_id = p_ele_entry_id

Line 1503: from dual

1499: hr_utility.set_location('calculate_period_earnings', 58);
1500: hr_utility.trace('Check for EEVMPE changes nevertheless');
1501:
1502: select 1 INTO l_eev_info_changes
1503: from dual
1504: where exists (
1505: SELECT 1
1506: FROM pay_element_entry_values_f EEV
1507: WHERE EEV.element_entry_id = p_ele_entry_id

Line 2971: FROM DUAL;

2967:
2968: SELECT decode(v_day_no,1,'SUN',2,'MON',3,'TUE',
2969: 4,'WED',5,'THU',6,'FRI',7,'SAT')
2970: INTO v_curr_day
2971: FROM DUAL;
2972:
2973: --
2974: --
2975: v_total_hours := v_total_hours + FND_NUMBER.CANONICAL_TO_NUMBER(hruserdt.get_table_value(p_bg_id,