APPS.PA_FORECAST_ITEMS_UTILS dependencies on PA_LOOKUPS

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

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

Line 1459: FROM pa_lookups

1455:
1456: SELECT lookup_code, meaning
1457: INTO x_tp_amount_type_code,
1458: x_tp_amount_type_desc
1459: FROM pa_lookups
1460: WHERE lookup_type = 'TP_AMOUNT_TYPE'
1461: AND lookup_code = p_tp_amount_type_code;
1462:
1463: ELSE

Line 1474: FROM pa_lookups

1470: lv_error_msg := 'PA_AMOUNT_TYPE_DESC_AMBIGUOUS';
1471:
1472: SELECT lookup_code
1473: INTO x_tp_amount_type_code
1474: FROM pa_lookups
1475: WHERE lookup_type = 'TP_AMOUNT_TYPE'
1476: AND meaning = p_tp_amount_type_desc;
1477:
1478: