DBA Data[Home] [Help]

APPS.PA_ASSIGNMENTS_PVT dependencies on PA_FORECAST_ITEMS

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

946:
947: BEGIN
948:
949: /*
950: This select is done for getting the min item_date from pa_forecast_items table.
951: There can be case that the assignment start date is a holiday (Exception in the calendar)
952: and hence no fi will be created for the assignment start date. So we need to get the first
953: working date which is done in the select below. If the min(item_date) is null, we dont call the
954: pa_cc_transfer_price.get_initial_transfer_price api

Line 958: from pa_forecast_items

954: pa_cc_transfer_price.get_initial_transfer_price api
955: */
956:
957: select min(item_date) into l_start_date
958: from pa_forecast_items
959: WHERE Assignment_id = p_assignment_id
960: AND Error_Flag = 'N'
961: AND Delete_Flag = 'N';
962: