APPS.PA_FI_AMT_CALC_PKG dependencies on PA_FORECAST_ITEM_DETAILS

Line 446: l_line_num Pa_Forecast_Item_Details.Line_Num%TYPE;

442: l_fi_tp_rejct_reason_tab PA_PLSQL_DATATYPES.Char30TabTyp;
443: l_fi_delete_flag_tab PA_PLSQL_DATATYPES.Char1TabTyp;
444:
445: l_fi_process_flag_tab PA_PLSQL_DATATYPES.Char30TabTyp;
446: l_line_num Pa_Forecast_Item_Details.Line_Num%TYPE;
447: l_temp_line_num Pa_Forecast_Item_Details.Line_Num%TYPE;
448:
449: l_prev_fi_pvdr_papd Pa_Forecast_Items.PVDR_PA_PERIOD_NAME%TYPE;
450:

Line 447: l_temp_line_num Pa_Forecast_Item_Details.Line_Num%TYPE;

443: l_fi_delete_flag_tab PA_PLSQL_DATATYPES.Char1TabTyp;
444:
445: l_fi_process_flag_tab PA_PLSQL_DATATYPES.Char30TabTyp;
446: l_line_num Pa_Forecast_Item_Details.Line_Num%TYPE;
447: l_temp_line_num Pa_Forecast_Item_Details.Line_Num%TYPE;
448:
449: l_prev_fi_pvdr_papd Pa_Forecast_Items.PVDR_PA_PERIOD_NAME%TYPE;
450:
451: l_prev_project_id NUMBER;

Line 1831: FROM Pa_Forecast_Item_Details

1827: SELECT
1828: TP_AMOUNT_TYPE
1829: INTO
1830: l_fi_amount_type_tab(i)
1831: FROM Pa_Forecast_Item_Details
1832: WHERE
1833: FORECAST_ITEM_ID = l_fi_id_tab(i) AND
1834: Line_Num = ( SELECT MAX(Line_Num) FROM
1835: Pa_Forecast_Item_Details WHERE

Line 1835: Pa_Forecast_Item_Details WHERE

1831: FROM Pa_Forecast_Item_Details
1832: WHERE
1833: FORECAST_ITEM_ID = l_fi_id_tab(i) AND
1834: Line_Num = ( SELECT MAX(Line_Num) FROM
1835: Pa_Forecast_Item_Details WHERE
1836: Forecast_Item_Id = l_fi_id_tab(i) AND
1837: Net_Zero_Flag = 'N' );
1838: EXCEPTION
1839: WHEN NO_DATA_FOUND THEN