DBA Data[Home] [Help]

APPS.PA_BILLING dependencies on PA_EXPENDITURE_ITEMS_ALL

Line 1807: from pa_tasks t, pa_expenditure_items_all e

1803: /* Indicator variables Bug# 634414 */
1804: NC := 1206;
1805: select t.labor_sch_type
1806: into labor_sch_type
1807: from pa_tasks t, pa_expenditure_items_all e
1808: where t.task_id = e.task_id
1809: and e.expenditure_item_id = ei_id( j );
1810: /* Indicator variables Bug# 634414 */
1811: NC := 1207;

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

1879:
1880: select nvl(BTC_COST_BASE_REV_CODE,'EXP_TRANS_CURR')
1881: into l_mcb_cost_flag
1882: from pa_projects_all
1883: where project_id =(select project_id from pa_expenditure_items_all where expenditure_item_id=ei_id(j));
1884:
1885: EXCEPTION
1886: WHEN NO_DATA_FOUND THEN
1887: IF g1_debug_mode = 'Y' THEN

Line 1950: pa_expenditure_items_all table.

1946:
1947:
1948: /*--------------------------------------------------------------------------------------------
1949: Rejection code error message which would be eventually populated in
1950: pa_expenditure_items_all table.
1951: --------------------------------------------------------------------------------------------*/
1952: NC := 1209;
1953:
1954: IF ( insert_error_message ) THEN