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 1837: FROM Pa_Forecast_Item_Details

1833: SELECT
1834: TP_AMOUNT_TYPE
1835: INTO
1836: l_fi_amount_type_tab(i)
1837: FROM Pa_Forecast_Item_Details
1838: WHERE
1839: FORECAST_ITEM_ID = l_fi_id_tab(i) AND
1840: Line_Num = ( SELECT MAX(Line_Num) FROM
1841: Pa_Forecast_Item_Details WHERE

Line 1841: Pa_Forecast_Item_Details WHERE

1837: FROM Pa_Forecast_Item_Details
1838: WHERE
1839: FORECAST_ITEM_ID = l_fi_id_tab(i) AND
1840: Line_Num = ( SELECT MAX(Line_Num) FROM
1841: Pa_Forecast_Item_Details WHERE
1842: Forecast_Item_Id = l_fi_id_tab(i) AND
1843: Net_Zero_Flag = 'N' );
1844: EXCEPTION
1845: WHEN NO_DATA_FOUND THEN