APPS.PA_FAXFACE dependencies on PA_MC_PRJ_AST_LINE_DTLS

Line 1256: DELETE PA_MC_PRJ_AST_LINE_DTLS

1252:
1253: IF l_mrc_flag = 'Y' THEN
1254: x_err_stage := 'Deleting the ALC project asset line details';
1255:
1256: DELETE PA_MC_PRJ_AST_LINE_DTLS
1257: WHERE PROJ_ASSET_LINE_DTL_UNIQ_ID = x_project_asset_line_detail_id;
1258: END IF;
1259:
1260: EXCEPTION

Line 6436: INSERT into PA_MC_PRJ_AST_LINE_DTLS

6432: END IF;
6433:
6434:
6435:
6436: INSERT into PA_MC_PRJ_AST_LINE_DTLS
6437: (
6438: SET_OF_BOOKS_ID,
6439: PROJ_ASSET_LINE_DTL_UNIQ_ID,
6440: PROJECT_ASSET_LINE_DETAIL_ID,

Line 6536: FROM PA_MC_PRJ_AST_LINE_DTLS

6532: x_err_stage := 'Create ALC Project Asset Line details for new line';
6533:
6534: SELECT nvl(sum(cip_cost),0)
6535: INTO l_orig_asset_cost
6536: FROM PA_MC_PRJ_AST_LINE_DTLS
6537: WHERE set_of_books_id = v_alc_ledger.ledger_id
6538: AND project_asset_line_detail_id = x_project_asset_line_detail_id;
6539:
6540: l_curr_asset_cost := l_orig_asset_cost;