APPS.PA_PROJECT_CORE1 dependencies on PA_COST_DIST_OVERRIDES

Line 3947: INSERT INTO pa_cost_dist_overrides (

3943: FETCH cur_get_flag INTO l_fn_cb_overrides_flag;
3944: CLOSE cur_get_flag;
3945:
3946: IF 'Y' = l_fn_cb_overrides_flag THEN
3947: INSERT INTO pa_cost_dist_overrides (
3948: COST_DISTRIBUTION_OVERRIDE_ID
3949: , project_id
3950: , OVERRIDE_TO_ORGANIZATION_ID
3951: , start_date_active

Line 3962: pa_cost_dist_overrides_s.nextval

3958: , EXPENDITURE_CATEGORY
3959: , OVERRIDE_FROM_ORGANIZATION_ID
3960: , END_DATE_ACTIVE)
3961: SELECT
3962: pa_cost_dist_overrides_s.nextval
3963: , x_new_project_id
3964: , OVERRIDE_TO_ORGANIZATION_ID
3965: , decode(x_delta, null, x_start_date,
3966: start_date_active + x_delta)

Line 3978: pa_cost_dist_overrides

3974: , OVERRIDE_FROM_ORGANIZATION_ID
3975: , decode(x_delta, null, x_completion_date,
3976: end_date_active + x_delta)
3977: FROM
3978: pa_cost_dist_overrides
3979: WHERE project_id = x_orig_project_id;
3980: END IF;
3981:
3982: x_err_stage := 'copying credit receivers ';