APPS.PA_ADJUSTMENTS dependencies on PA_EXPENDITURES_ALL

Line 2989: l_person_id pa_expenditures_all.incurred_by_person_id%type;

2985: l_sys_link_func VARCHAR2(3);
2986: l_denom_raw_cost NUMBER := NULL;
2987: l_transaction_source pa_expenditure_items_all.transaction_source%type;
2988: l_expenditure_id pa_expenditure_items_all.expenditure_id%type;
2989: l_person_id pa_expenditures_all.incurred_by_person_id%type;
2990: l_expenditure_item_date Date;
2991:
2992: /* Commented the following code as part of Bug#2291180 -- Start */
2993: /* Bug#2291180

Line 3141: pa_expenditures_all

3137: Incurred_by_person_id
3138: into
3139: l_person_id
3140: from
3141: pa_expenditures_all
3142: where expenditure_id = l_expenditure_id;
3143: /* end of bug fix:2798742 */
3144:
3145: l_denom_currency_code := get_denom_curr_code(l_transaction_source,

Line 3709: pa_expenditures_all e

3705: , ei.costing_method
3706: , ei.payroll_accrual_flag -- bug 12541898
3707: , ei.interface_run_id -- bug 12541898
3708: FROM
3709: pa_expenditures_all e
3710: , pa_expenditure_items_all ei
3711: , pa_expenditure_items_all ei2
3712: , pa_transaction_sources ts
3713: , pa_expenditure_comments ec

Line 4285: pa_expenditures_all e

4281: SELECT
4282: ei.expenditure_item_id
4283: , eia.expenditure_item_id adj_expenditure_item_id
4284: FROM
4285: pa_expenditures_all e
4286: , pa_expenditure_items_all ei
4287: , pa_expenditure_items_all eia
4288: WHERE
4289: ei.expenditure_item_id = eia.adjusted_expenditure_item_id (+)

Line 4459: pa_expenditures_all e

4455: SELECT
4456: ei.expenditure_item_id
4457: , eia.expenditure_item_id adj_expenditure_item_id
4458: FROM
4459: pa_expenditures_all e
4460: , pa_expenditure_items_all ei
4461: , pa_expenditure_items_all eia
4462: WHERE
4463: ei.expenditure_item_id = eia.adjusted_expenditure_item_id (+)

Line 5558: l_expenditure_status_code PA_EXPENDITURES_ALL.EXPENDITURE_STATUS_CODE%TYPE;

5554: l_error_message_name varchar2(30);
5555: l_application_short_name varchar2(30);
5556: l_net_zero_adjustment_flag PA_EXPENDITURE_ITEMS_ALL.NET_ZERO_ADJUSTMENT_FLAG%TYPE;
5557: l_converted_flag PA_EXPENDITURE_ITEMS_ALL.CONVERTED_FLAG%TYPE;
5558: l_expenditure_status_code PA_EXPENDITURES_ALL.EXPENDITURE_STATUS_CODE%TYPE;
5559: l_allow_adjustments_flag PA_TRANSACTION_SOURCES.ALLOW_ADJUSTMENTS_FLAG%TYPE;
5560: l_burden_sum_dest_run_id PA_EXPENDITURE_ITEMS_ALL.BURDEN_SUM_DEST_RUN_ID%TYPE;
5561: l_document_distribution_type PA_EXPENDITURE_ITEMS_ALL.DOCUMENT_DISTRIBUTION_TYPE%TYPE;
5562: l_source_expenditure_item_id PA_EXPENDITURE_ITEMS_ALL.SOURCE_EXPENDITURE_ITEM_ID%TYPE;

Line 5649: || ',pa_expenditures_all e';

5645: || ',ei.cbs_element_id'; -- Added for CBS Enhancement Bug 16220146
5646:
5647: from_clause := ' FROM'
5648: || ' pa_expenditure_items_all ei'
5649: || ',pa_expenditures_all e';
5650:
5651: where_clause := ' WHERE ei.expenditure_id = e.expenditure_id';
5652:
5653: if p_org_id is not null then

Line 9654: l_organization_id pa_expenditures_all.incurred_by_organization_id%TYPE;

9650: l_gl_accounted_flag pa_transaction_sources.gl_accounted_flag%type;
9651: l_costed_flag pa_transaction_sources.costed_flag%type; /* added bug 3142879 */
9652: l_cost_rate_flag pa_expenditure_types.cost_rate_flag%type;
9653: l_job_id pa_expenditure_items_all.job_id%TYPE;
9654: l_organization_id pa_expenditures_all.incurred_by_organization_id%TYPE;
9655: l_cost_rate pa_bill_rates_all.rate%TYPE;
9656: l_start_date Date;
9657: l_end_date Date;
9658: l_org_labor_sch_rule_id pa_org_labor_sch_rule.org_labor_sch_rule_id%TYPE;