APPS.PA_REVENUE dependencies on PA_PROJECT_ASSIGNMENTS

Line 405: FROM pa_project_assignments asgn

401: INTO l_bill_rate,l_raw_revenue,
402: l_rate_currency_code,
403: l_markup_percentage,
404: l_discount_pct
405: FROM pa_project_assignments asgn
406: WHERE asgn.assignment_id = p_item_id;
407:
408: EXCEPTION
409: WHEN TOO_MANY_ROWS THEN

Line 490: FROM pa_project_assignments asgn

486: INTO l_bill_rate,l_raw_revenue,
487: l_rate_currency_code,
488: l_markup_percentage,
489: l_discount_pct
490: FROM pa_project_assignments asgn
491: WHERE asgn.assignment_id = p_item_id;
492:
493: EXCEPTION
494: WHEN TOO_MANY_ROWS THEN

Line 1127: FROM pa_project_assignments asgn

1123: l_rate_currency_code,
1124: l_markup_percentage,
1125: l_amount_calculation_code,
1126: l_discount_percentage
1127: FROM pa_project_assignments asgn
1128: WHERE asgn.assignment_id = p_item_id;
1129:
1130: EXCEPTION
1131: WHEN TOO_MANY_ROWS THEN

Line 1157: FROM pa_project_assignments asgn

1153: l_rate_currency_code,
1154: l_markup_percentage,
1155: l_amount_calculation_code,
1156: l_discount_percentage
1157: FROM pa_project_assignments asgn
1158: WHERE asgn.assignment_id = p_item_id;
1159:
1160: EXCEPTION
1161: WHEN TOO_MANY_ROWS THEN

Line 1298: FROM pa_project_assignments asgn

1294: l_rate_currency_code,
1295: l_markup_percentage,
1296: l_amount_calculation_code,
1297: l_discount_percentage
1298: FROM pa_project_assignments asgn
1299: WHERE asgn.assignment_id = p_item_id;
1300:
1301: EXCEPTION
1302: WHEN TOO_MANY_ROWS THEN

Line 1328: FROM pa_project_assignments asgn

1324: l_rate_currency_code,
1325: l_markup_percentage,
1326: l_amount_calculation_code,
1327: l_discount_percentage
1328: FROM pa_project_assignments asgn
1329: WHERE asgn.assignment_id = p_item_id;
1330:
1331: EXCEPTION
1332: WHEN TOO_MANY_ROWS THEN