APPS.PAY_CORE_FF_UDFS dependencies on DUAL

Line 1753: from dual

1749:
1750: BEGIN /* Check ASGMPE */
1751:
1752: select 1 INTO l_asg_info_changes
1753: from dual
1754: where exists (
1755: SELECT 1
1756: FROM per_assignments_f ASG,
1757: per_assignment_status_types AST,

Line 1781: from dual

1777:
1778: BEGIN /* EEVMPE check - maybe pick*/
1779:
1780: select 1 INTO l_eev_info_changes
1781: from dual
1782: where exists (
1783: SELECT 1
1784: FROM pay_element_entry_values_f EEV
1785: WHERE EEV.element_entry_id = p_ele_entry_id

Line 1826: from dual

1822:
1823: BEGIN /* ASGMPS changes */
1824:
1825: select 1 INTO l_asg_info_changes
1826: from dual
1827: where exists (
1828: SELECT 1
1829: FROM per_assignments_f ASG,
1830: per_assignment_status_types AST,

Line 1849: from dual

1845:
1846: BEGIN /* EEVMPE changes ASGMPS */
1847:
1848: select 1 INTO l_eev_info_changes
1849: from dual
1850: where exists (
1851: SELECT 1
1852: FROM pay_element_entry_values_f EEV
1853: WHERE EEV.element_entry_id = p_ele_entry_id

Line 1896: from dual

1892: hr_utility.set_location('calculate_period_earnings', 58);
1893: hr_utility.trace('Check for EEVMPE changes nevertheless');
1894:
1895: select 1 INTO l_eev_info_changes
1896: from dual
1897: where exists (
1898: SELECT 1
1899: FROM pay_element_entry_values_f EEV
1900: WHERE EEV.element_entry_id = p_ele_entry_id

Line 3114: FROM DUAL;

3110:
3111: SELECT p_duration + (((SUBSTR(l_day_end_time,1,2)*60 + SUBSTR(l_day_end_time,4,2)) -
3112: (SUBSTR(l_start_time,1,2)*60 + SUBSTR(l_start_time,4,2)))/60)
3113: INTO p_duration
3114: FROM DUAL;
3115: -- hr_utility.trace('p_start_duration ' || p_start_duration);
3116: hr_utility.trace('Start p_duration ' || p_duration);
3117:
3118: --

Line 3125: FROM DUAL;

3121: hr_utility.trace('l_end_time ' || l_end_time);
3122: SELECT p_duration + (((SUBSTR(l_end_time,1,2)*60 + SUBSTR(l_end_time,4,2)) -
3123: (SUBSTR(l_day_start_time,1,2)*60 + SUBSTR(l_day_start_time,4,2)) + 1)/60)
3124: INTO p_duration
3125: FROM DUAL;
3126: --hr_utility.trace('p_end_duration ' || p_end_duration);
3127: hr_utility.trace('End p_duration ' || p_duration);
3128: --
3129: -- Get between full day hours

Line 3132: FROM DUAL;

3128: --
3129: -- Get between full day hours
3130: SELECT p_duration + ((TRUNC(l_schedule(l_idx).END_DATE_TIME) - TRUNC(l_schedule(l_idx).START_DATE_TIME) - 1) * 24)
3131: INTO p_duration
3132: FROM DUAL;
3133: ELSE
3134: -- Start and End on same day
3135: l_start_time := TO_CHAR(l_schedule(l_idx).START_DATE_TIME,'HH24:MI');
3136: l_end_time := TO_CHAR(l_schedule(l_idx).END_DATE_TIME,'HH24:MI');

Line 3144: FROM DUAL;

3140:
3141: SELECT p_duration + (((SUBSTR(l_end_time,1,2)*60 + SUBSTR(l_end_time,4,2)) -
3142: (SUBSTR(l_start_time,1,2)*60 + SUBSTR(l_start_time,4,2)))/60)
3143: INTO p_duration
3144: FROM DUAL;
3145: hr_utility.trace('duration l_idx '||l_idx||' ' ||p_duration);
3146:
3147: END IF;
3148: END IF;