DBA Data[Home] [Help]

APPS.PA_BILLING dependencies on PA_EXPENDITURE_ITEMS_ALL

Line 1736: from pa_tasks t, pa_expenditure_items_all e

1732: /* Indicator variables Bug# 634414 */
1733: NC := 1206;
1734: select t.labor_sch_type
1735: into labor_sch_type
1736: from pa_tasks t, pa_expenditure_items_all e
1737: where t.task_id = e.task_id
1738: and e.expenditure_item_id = ei_id( j );
1739: /* Indicator variables Bug# 634414 */
1740: NC := 1207;

Line 1812: where project_id =(select project_id from pa_expenditure_items_all where expenditure_item_id=ei_id(j));

1808:
1809: select nvl(BTC_COST_BASE_REV_CODE,'EXP_TRANS_CURR')
1810: into l_mcb_cost_flag
1811: from pa_projects_all
1812: where project_id =(select project_id from pa_expenditure_items_all where expenditure_item_id=ei_id(j));
1813:
1814: EXCEPTION
1815: WHEN NO_DATA_FOUND THEN
1816: IF g1_debug_mode = 'Y' THEN

Line 1879: pa_expenditure_items_all table.

1875:
1876:
1877: /*--------------------------------------------------------------------------------------------
1878: Rejection code error message which would be eventually populated in
1879: pa_expenditure_items_all table.
1880: --------------------------------------------------------------------------------------------*/
1881: NC := 1209;
1882:
1883: IF ( insert_error_message ) THEN