APPS.PA_REVENUE dependencies on PA_PROJECT_ASSIGNMENTS

Line 414: FROM pa_project_assignments asgn

410: INTO l_bill_rate,l_raw_revenue,
411: l_rate_currency_code,
412: l_markup_percentage,
413: l_discount_pct
414: FROM pa_project_assignments asgn
415: WHERE asgn.assignment_id = p_item_id;
416:
417: EXCEPTION
418: WHEN TOO_MANY_ROWS THEN

Line 499: FROM pa_project_assignments asgn

495: INTO l_bill_rate,l_raw_revenue,
496: l_rate_currency_code,
497: l_markup_percentage,
498: l_discount_pct
499: FROM pa_project_assignments asgn
500: WHERE asgn.assignment_id = p_item_id;
501:
502: EXCEPTION
503: WHEN TOO_MANY_ROWS THEN

Line 1146: FROM pa_project_assignments asgn

1142: l_rate_currency_code,
1143: l_markup_percentage,
1144: l_amount_calculation_code,
1145: l_discount_percentage
1146: FROM pa_project_assignments asgn
1147: WHERE asgn.assignment_id = p_item_id;
1148:
1149: EXCEPTION
1150: WHEN TOO_MANY_ROWS THEN

Line 1176: FROM pa_project_assignments asgn

1172: l_rate_currency_code,
1173: l_markup_percentage,
1174: l_amount_calculation_code,
1175: l_discount_percentage
1176: FROM pa_project_assignments asgn
1177: WHERE asgn.assignment_id = p_item_id;
1178:
1179: EXCEPTION
1180: WHEN TOO_MANY_ROWS THEN

Line 1317: FROM pa_project_assignments asgn

1313: l_rate_currency_code,
1314: l_markup_percentage,
1315: l_amount_calculation_code,
1316: l_discount_percentage
1317: FROM pa_project_assignments asgn
1318: WHERE asgn.assignment_id = p_item_id;
1319:
1320: EXCEPTION
1321: WHEN TOO_MANY_ROWS THEN

Line 1347: FROM pa_project_assignments asgn

1343: l_rate_currency_code,
1344: l_markup_percentage,
1345: l_amount_calculation_code,
1346: l_discount_percentage
1347: FROM pa_project_assignments asgn
1348: WHERE asgn.assignment_id = p_item_id;
1349:
1350: EXCEPTION
1351: WHEN TOO_MANY_ROWS THEN