APPS.PA_ASSET_REVERSAL_PVT dependencies on PA_PROJECT_ASSETS

Line 106: FROM pa_project_assets pas

102: WHERE ppal.rev_proj_asset_line_id = pal.project_asset_line_id
103: )
104: AND pal.project_asset_id NOT IN
105: ( SELECT project_asset_id
106: FROM pa_project_assets pas
107: WHERE pas.reverse_flag = 'Y'
108: AND pas.project_id = pal.project_id
109: )
110: UNION

Line 118: FROM pa_project_assets pas

114: AND pal.transfer_status_code <> 'T'
115: AND pal.rev_proj_asset_line_id IS NULL
116: AND pal.project_asset_id IN
117: ( SELECT project_asset_id
118: FROM pa_project_assets pas
119: WHERE pas.reverse_flag = 'Y'
120: AND pas.project_id = pal.project_id
121: );
122:

Line 209: v_project_asset_id PA_PROJECT_ASSETS_ALL.project_asset_id%TYPE;

205:
206: i NUMBER;
207: v_user_id NUMBER := FND_GLOBAL.user_id;
208: v_login_id NUMBER := FND_GLOBAL.login_id;
209: v_project_asset_id PA_PROJECT_ASSETS_ALL.project_asset_id%TYPE;
210:
211: l_update_count NUMBER := 0;
212:
213: BEGIN

Line 223: UPDATE pa_project_assets

219: WHILE i IS NOT NULL LOOP
220:
221: v_project_asset_id := x_project_assets(i).PROJECT_ASSET_ID;
222:
223: UPDATE pa_project_assets
224: SET reverse_flag = 'Y',
225: last_update_date = SYSDATE,
226: last_updated_by = v_user_id,
227: last_update_login = v_login_id