APPS.PA_FAXFACE dependencies on PA_MC_PRJ_AST_LINE_DTLS

Line 1181: DELETE PA_MC_PRJ_AST_LINE_DTLS

1177:
1178: IF l_mrc_flag = 'Y' THEN
1179: x_err_stage := 'Deleting the ALC project asset line details';
1180:
1181: DELETE PA_MC_PRJ_AST_LINE_DTLS
1182: WHERE PROJ_ASSET_LINE_DTL_UNIQ_ID = x_project_asset_line_detail_id;
1183: END IF;
1184:
1185: EXCEPTION

Line 5990: INSERT into PA_MC_PRJ_AST_LINE_DTLS

5986: END IF;
5987:
5988:
5989:
5990: INSERT into PA_MC_PRJ_AST_LINE_DTLS
5991: (
5992: SET_OF_BOOKS_ID,
5993: PROJ_ASSET_LINE_DTL_UNIQ_ID,
5994: PROJECT_ASSET_LINE_DETAIL_ID,

Line 6089: FROM PA_MC_PRJ_AST_LINE_DTLS

6085: x_err_stage := 'Create ALC Project Asset Line details for new line';
6086:
6087: SELECT nvl(sum(cip_cost),0)
6088: INTO l_orig_asset_cost
6089: FROM PA_MC_PRJ_AST_LINE_DTLS
6090: WHERE set_of_books_id = v_alc_ledger.ledger_id
6091: AND project_asset_line_detail_id = x_project_asset_line_detail_id;
6092:
6093: l_curr_asset_cost := l_orig_asset_cost;