APPS.PA_UTILS dependencies on DUAL

Line 403: into X_week_ending_day from dual;

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

Line 410: sys.dual;

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

Line 450: sys.dual

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

Line 1085: sys.dual;

1081: pa_expenditure_items_s.nextval
1082: INTO
1083: X_expenditure_item_id
1084: FROM
1085: sys.dual;
1086:
1087: RETURN( X_expenditure_item_id );
1088:
1089: EXCEPTION

Line 1248: From sys.dual

1244: ELSE
1245:
1246: Select 1
1247: Into dummy
1248: From sys.dual
1249: Where exists
1250: ( Select null
1251: From pa_projects_expend_v p
1252: Where p.project_Id = X_project_Id );

Line 1288: FROM sys.dual

1284: BEGIN
1285:
1286: SELECT 'Y'
1287: INTO x_dummy
1288: FROM sys.dual
1289: WHERE EXISTS (
1290: SELECT NULL
1291: FROM pa_implementations_all
1292: WHERE org_id IS NOT NULL );

Line 1973: from dual;

1969: FROM pa_implementations;
1970:
1971: select to_char(to_date('01-01-1950','DD-MM-YYYY') +X_week_ending_day_index-1, 'Day')
1972: into X_week_ending_day
1973: from dual;
1974:
1975: SELECT Next_Day( trunc( X_date )-1, X_Week_Ending_Day ) /* BUG#3118592 */
1976: INTO X_Week_Ending
1977: FROM sys.dual;

Line 1977: FROM sys.dual;

1973: from dual;
1974:
1975: SELECT Next_Day( trunc( X_date )-1, X_Week_Ending_Day ) /* BUG#3118592 */
1976: INTO X_Week_Ending
1977: FROM sys.dual;
1978:
1979: -- Add the week ending date to the pl/sql table using the ei date
1980: -- as the index value.
1981: G_WeekEndDateTab(to_number(to_char(X_date,'YYYYMMDD')||to_char(x_week_start))) := X_Week_Ending; /*Bug 7601460 */