APPS.PA_REVENUE_AMT dependencies on PA_PROJECTS_ALL

Line 115: FROM pa_projects_all

111: /* Added the following nvl so that code doesn't break even if upgrade script fails - For bug 2724185 */
112:
113: SELECT nvl(BTC_COST_BASE_REV_CODE,'EXP_TRANS_CURR')
114: INTO l_mcb_cost_flag
115: FROM pa_projects_all
116: WHERE project_id =(select project_id from pa_expenditure_items_all
117: where expenditure_item_id=ei_id(1));
118: EXCEPTION
119: WHEN NO_DATA_FOUND THEN

Line 371: /* Bug 2638840 : Get the BTC_COST_BASE_REV_CODE from pa_projects_all table */

367:
368: /* Commented for bug 2638840
369: rev_amount( j ) := to_char(l_ind_cost_denm); */
370:
371: /* Bug 2638840 : Get the BTC_COST_BASE_REV_CODE from pa_projects_all table */
372: /* Moved the following code added for bug 2638840 out of the while loop and
373: added the same before the start of while, as each call of get_irs_amt
374: has EIs that belong to the same project and hence retrieving the
375: btc_cost_base_rev_code once for each call of get_irs_amt would be sufficient

Line 381: from pa_projects_all

377: BEGIN
378:
379: select BTC_COST_BASE_REV_CODE
380: into l_mcb_cost_flag
381: from pa_projects_all
382: where project_id =(select project_id from pa_expenditure_items_all where expenditure_item_id=ei_id(j));
383:
384: EXCEPTION
385: WHEN NO_DATA_FOUND THEN

Line 537: /* Bug 2638840 : Get the BTC_COST_BASE_REV_CODE from pa_projects_all table */

533:
534: /* Commented for bug 2638840
535: inv_amount( j ) := to_char(l_ind_cost_denm); */
536:
537: /* Bug 2638840 : Get the BTC_COST_BASE_REV_CODE from pa_projects_all table */
538: /* Moved the following code added for bug 2638840 out of the while loop and
539: added the same before the start of while, as each call of get_irs_amt
540: has EIs that belong to the same project and hence retrieving the
541: btc_cost_base_rev_code once for each call of get_irs_amt would be sufficient

Line 548: from pa_projects_all

544: BEGIN
545:
546: select BTC_COST_BASE_REV_CODE
547: into l_mcb_cost_flag
548: from pa_projects_all
549: where project_id =(select project_id from pa_expenditure_items_all where expenditure_item_id=ei_id(j));
550:
551: EXCEPTION
552: WHEN NO_DATA_FOUND THEN