APPS.PA_UTILS dependencies on DUAL

Line 402: into X_week_ending_day from dual;

398: into X_week_ending_day_index
399: FROM pa_implementations;
400:
401: select to_char(to_date('01-01-1950','DD-MM-YYYY') +X_week_ending_day_index-1, 'Day')
402: into X_week_ending_day from dual;
403:
404: SELECT
405: next_day( trunc( X_date )-1, X_week_ending_day ) /* BUG#3118592 */
406: INTO

Line 409: sys.dual;

405: next_day( trunc( X_date )-1, X_week_ending_day ) /* BUG#3118592 */
406: INTO
407: X_week_ending
408: FROM
409: sys.dual;
410:
411: RETURN ( X_week_ending );
412:
413: EXCEPTION

Line 449: sys.dual

445: count(1)
446: INTO
447: dummy
448: FROM
449: sys.dual
450: WHERE
451: trunc(X_date) BETWEEN trunc(trunc( X_week_end )-6 ) /* BUG#3118592 */
452: AND trunc( X_week_end );
453:

Line 841: sys.dual;

837: pa_expenditure_items_s.nextval
838: INTO
839: X_expenditure_item_id
840: FROM
841: sys.dual;
842:
843: RETURN( X_expenditure_item_id );
844:
845: EXCEPTION

Line 1004: From sys.dual

1000: ELSE
1001:
1002: Select 1
1003: Into dummy
1004: From sys.dual
1005: Where exists
1006: ( Select null
1007: From pa_projects_expend_v p
1008: Where p.project_Id = X_project_Id );

Line 1044: FROM sys.dual

1040: BEGIN
1041:
1042: SELECT 'Y'
1043: INTO x_dummy
1044: FROM sys.dual
1045: WHERE EXISTS (
1046: SELECT NULL
1047: FROM pa_implementations_all
1048: WHERE org_id IS NOT NULL );

Line 1689: from dual;

1685: FROM pa_implementations;
1686:
1687: select to_char(to_date('01-01-1950','DD-MM-YYYY') +X_week_ending_day_index-1, 'Day')
1688: into X_week_ending_day
1689: from dual;
1690:
1691: SELECT Next_Day( trunc( X_date )-1, X_Week_Ending_Day ) /* BUG#3118592 */
1692: INTO X_Week_Ending
1693: FROM sys.dual;

Line 1693: FROM sys.dual;

1689: from dual;
1690:
1691: SELECT Next_Day( trunc( X_date )-1, X_Week_Ending_Day ) /* BUG#3118592 */
1692: INTO X_Week_Ending
1693: FROM sys.dual;
1694:
1695: -- Add the week ending date to the pl/sql table using the ei date
1696: -- as the index value.
1697: G_WeekEndDateTab(to_number(to_char(X_date,'YYYYMMDD')||to_char(x_week_start))) := X_Week_Ending; /*Bug 7601460 */