APPS.PSP_ARCHIVE_RETRIEVE dependencies on DUAL

Line 55: --FROM DUAL

51: --Cursor to check if there are any pending effort reports for the selected begin and end periods
52: -- and for the selected payroll
53: --CURSOR effort_pending_cur IS
54: --SELECT 1
55: --FROM DUAL
56: --WHERE EXISTS
57: -- (
58: -- SELECT DISTINCT PER.effort_report_id,
59: -- PER.version_num

Line 1791: FROM dual;

1787: END IF;
1788:
1789: SELECT To_number(fnd_profile.VALUE ('PER_BUSINESS_GROUP_ID'))
1790: INTO l_business_group_id
1791: FROM dual;
1792:
1793: SELECT To_number(fnd_profile.VALUE ('GL_SET_OF_BKS_ID'))
1794: INTO l_set_of_books_id
1795: FROM dual;

Line 1795: FROM dual;

1791: FROM dual;
1792:
1793: SELECT To_number(fnd_profile.VALUE ('GL_SET_OF_BKS_ID'))
1794: INTO l_set_of_books_id
1795: FROM dual;
1796:
1797: IF g_debug_enabled THEN
1798: hr_utility.Trace('Business_group_id '||l_business_group_id);
1799: hr_utility.Trace('Set_of_books_id '||l_set_of_books_id);