APPS.PA_ADJUSTMENTS dependencies on PA_EXPENDITURES_ALL

Line 2930: l_person_id pa_expenditures_all.incurred_by_person_id%type;

2926: l_sys_link_func VARCHAR2(3);
2927: l_denom_raw_cost NUMBER := NULL;
2928: l_transaction_source pa_expenditure_items_all.transaction_source%type;
2929: l_expenditure_id pa_expenditure_items_all.expenditure_id%type;
2930: l_person_id pa_expenditures_all.incurred_by_person_id%type;
2931: l_expenditure_item_date Date;
2932:
2933: /* Commented the following code as part of Bug#2291180 -- Start */
2934: /* Bug#2291180

Line 3082: pa_expenditures_all

3078: Incurred_by_person_id
3079: into
3080: l_person_id
3081: from
3082: pa_expenditures_all
3083: where expenditure_id = l_expenditure_id;
3084: /* end of bug fix:2798742 */
3085:
3086: l_denom_currency_code := get_denom_curr_code(l_transaction_source,

Line 3615: pa_expenditures_all e

3611: , ei.document_type
3612: , ei.document_distribution_type
3613: /* R12 Changes - End */
3614: FROM
3615: pa_expenditures_all e
3616: , pa_expenditure_items_all ei
3617: , pa_expenditure_items_all ei2
3618: , pa_transaction_sources ts
3619: , pa_expenditure_comments ec

Line 4175: pa_expenditures_all e

4171: SELECT
4172: ei.expenditure_item_id
4173: , eia.expenditure_item_id adj_expenditure_item_id
4174: FROM
4175: pa_expenditures_all e
4176: , pa_expenditure_items_all ei
4177: , pa_expenditure_items_all eia
4178: WHERE
4179: ei.expenditure_item_id = eia.adjusted_expenditure_item_id (+)

Line 4349: pa_expenditures_all e

4345: SELECT
4346: ei.expenditure_item_id
4347: , eia.expenditure_item_id adj_expenditure_item_id
4348: FROM
4349: pa_expenditures_all e
4350: , pa_expenditure_items_all ei
4351: , pa_expenditure_items_all eia
4352: WHERE
4353: ei.expenditure_item_id = eia.adjusted_expenditure_item_id (+)

Line 5444: l_expenditure_status_code PA_EXPENDITURES_ALL.EXPENDITURE_STATUS_CODE%TYPE;

5440: l_error_message_name varchar2(30);
5441: l_application_short_name varchar2(30);
5442: l_net_zero_adjustment_flag PA_EXPENDITURE_ITEMS_ALL.NET_ZERO_ADJUSTMENT_FLAG%TYPE;
5443: l_converted_flag PA_EXPENDITURE_ITEMS_ALL.CONVERTED_FLAG%TYPE;
5444: l_expenditure_status_code PA_EXPENDITURES_ALL.EXPENDITURE_STATUS_CODE%TYPE;
5445: l_allow_adjustments_flag PA_TRANSACTION_SOURCES.ALLOW_ADJUSTMENTS_FLAG%TYPE;
5446: l_burden_sum_dest_run_id PA_EXPENDITURE_ITEMS_ALL.BURDEN_SUM_DEST_RUN_ID%TYPE;
5447: l_document_distribution_type PA_EXPENDITURE_ITEMS_ALL.DOCUMENT_DISTRIBUTION_TYPE%TYPE;
5448: l_source_expenditure_item_id PA_EXPENDITURE_ITEMS_ALL.SOURCE_EXPENDITURE_ITEM_ID%TYPE;

Line 5519: || ',pa_expenditures_all e';

5515: || ',ei.organization_id';
5516:
5517: from_clause := ' FROM'
5518: || ' pa_expenditure_items_all ei'
5519: || ',pa_expenditures_all e';
5520:
5521: where_clause := ' WHERE ei.expenditure_id = e.expenditure_id';
5522:
5523: if p_org_id is not null then

Line 9371: l_organization_id pa_expenditures_all.incurred_by_organization_id%TYPE;

9367: l_gl_accounted_flag pa_transaction_sources.gl_accounted_flag%type;
9368: l_costed_flag pa_transaction_sources.costed_flag%type; /* added bug 3142879 */
9369: l_cost_rate_flag pa_expenditure_types.cost_rate_flag%type;
9370: l_job_id pa_expenditure_items_all.job_id%TYPE;
9371: l_organization_id pa_expenditures_all.incurred_by_organization_id%TYPE;
9372: l_cost_rate pa_bill_rates_all.rate%TYPE;
9373: l_start_date Date;
9374: l_end_date Date;
9375: l_org_labor_sch_rule_id pa_org_labor_sch_rule.org_labor_sch_rule_id%TYPE;