DBA Data[Home] [Help]

APPS.PA_ASSIGNMENTS_PVT dependencies on PA_FORECAST_ITEMS

Line 942: This select is done for getting the min item_date from pa_forecast_items table.

938:
939: BEGIN
940:
941: /*
942: This select is done for getting the min item_date from pa_forecast_items table.
943: There can be case that the assignment start date is a holiday (Exception in the calendar)
944: and hence no fi will be created for the assignment start date. So we need to get the first
945: working date which is done in the select below. If the min(item_date) is null, we dont call the
946: pa_cc_transfer_price.get_initial_transfer_price api

Line 950: from pa_forecast_items

946: pa_cc_transfer_price.get_initial_transfer_price api
947: */
948:
949: select min(item_date) into l_start_date
950: from pa_forecast_items
951: WHERE Assignment_id = p_assignment_id
952: AND Error_Flag = 'N'
953: AND Delete_Flag = 'N';
954: