DBA Data[Home] [Help]

APPS.PA_FORECAST_ITEMS_UTILS dependencies on PA_LOOKUPS

Line 1369: /* Utilizing the fact that 01-01-1950 was a Sunday and PA lookups value for a Sunday is 1 */

1365: l_week_starting_day_index := TO_NUMBER(FND_PROFILE.VALUE('PA_GLOBAL_WEEK_START_DAY'));
1366:
1367: /*Commenting below for Bug 7012687 : not use Select from dual to evaluate expression*/
1368: /* Added for Bug 5549814*/
1369: /* Utilizing the fact that 01-01-1950 was a Sunday and PA lookups value for a Sunday is 1 */
1370: --Select (trim(to_char((to_date('01-01-1950','dd-mm-yyyy')+(l_week_starting_day_index - 1)),'DAY')))
1371: --into l_week_starting_day
1372: --from dual;
1373:

Line 1452: FROM pa_lookups

1448:
1449: SELECT lookup_code, meaning
1450: INTO x_tp_amount_type_code,
1451: x_tp_amount_type_desc
1452: FROM pa_lookups
1453: WHERE lookup_type = 'TP_AMOUNT_TYPE'
1454: AND lookup_code = p_tp_amount_type_code;
1455:
1456: ELSE

Line 1467: FROM pa_lookups

1463: lv_error_msg := 'PA_AMOUNT_TYPE_DESC_AMBIGUOUS';
1464:
1465: SELECT lookup_code
1466: INTO x_tp_amount_type_code
1467: FROM pa_lookups
1468: WHERE lookup_type = 'TP_AMOUNT_TYPE'
1469: AND meaning = p_tp_amount_type_desc;
1470:
1471: