DBA Data[Home] [Help]

APPS.HR_PAYROLLS dependencies on DUAL

Line 514: select to_char(p_date,'IW') from dual;

510: l_next_period_end_date date;
511: l_last_period boolean := false;
512: --
513: CURSOR csr_week_number (p_date in date) IS
514: select to_char(p_date,'IW') from dual;
515: --
516: BEGIN
517: --
518: hr_utility.set_location(proc_name, 1);

Line 1066: from sys.dual;

1062: p_last_update_login,
1063: p_created_by,
1064: p_creation_date,
1065: Current_regular_pay_date + p_pay_det.payslip_view_date_offset
1066: from sys.dual;
1067: --
1068: -- Increment loop variables.
1069: hr_utility.set_location(proc_name, 8);
1070: -- Store the first period end date, on the first loop.