APPS.PA_PROJECT_ASSETS_PUB dependencies on PA_PROJECT_ASSETS_S

Line 1666: SELECT pa_project_assets_s.NEXTVAL

1662: END IF;
1663:
1664:
1665: --Get next project_asset_id sequence value
1666: SELECT pa_project_assets_s.NEXTVAL
1667: INTO l_asset_in_rec.pa_project_asset_id
1668: FROM SYS.DUAL;
1669:
1670:

Line 3411: l_statement := 'UPDATE PA_PROJECT_ASSETS SET ';

3407:
3408:
3409: --Initialize update variables
3410: l_update_yes_flag := 'N';
3411: l_statement := 'UPDATE PA_PROJECT_ASSETS SET ';
3412:
3413: --Set the date variables which are used in processing and cursors
3414: l_date_placed_in_service := NVL(p_date_placed_in_service, l_asset_rec.date_placed_in_service);
3415: l_estimated_in_service_date := NVL(p_estimated_in_service_date, l_asset_rec.estimated_in_service_date);