eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_ADJUSTMENTS dependencies on PA_EXPENDITURES

Line 201: , pa_expenditures e

197: X_reversed_orig_txn_reference) orig_txn_reference
198: FROM
199: pa_transaction_sources ts
200: , pa_expenditure_items i
201: , pa_expenditures e
202: WHERE
203: i.expenditure_item_date = X_item_date
204: AND i.expenditure_type ||'' = X_exp_type
205: AND i.system_linkage_function ||'' = X_system_linkage_function

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 5792: || ' AND pa_expenditures_utils.Get_Latest_GL_Date(ei.expenditure_item_id)'

5788:
5789: if p_start_gl_date is not null
5790: and p_end_gl_date is not null then
5791: where_clause := where_clause
5792: || ' AND pa_expenditures_utils.Get_Latest_GL_Date(ei.expenditure_item_id)'
5793: || ' BETWEEN trunc(:start_gl_date) AND trunc(:end_gl_date)';
5794: elsif p_start_gl_date is not null then
5795: where_clause := where_clause
5796: || ' AND pa_expenditures_utils.Get_Latest_GL_Date(ei.expenditure_item_id) >= trunc(:start_gl_date)';

Line 5796: || ' AND pa_expenditures_utils.Get_Latest_GL_Date(ei.expenditure_item_id) >= trunc(:start_gl_date)';

5792: || ' AND pa_expenditures_utils.Get_Latest_GL_Date(ei.expenditure_item_id)'
5793: || ' BETWEEN trunc(:start_gl_date) AND trunc(:end_gl_date)';
5794: elsif p_start_gl_date is not null then
5795: where_clause := where_clause
5796: || ' AND pa_expenditures_utils.Get_Latest_GL_Date(ei.expenditure_item_id) >= trunc(:start_gl_date)';
5797: elsif p_end_gl_date is not null then
5798: where_clause := where_clause
5799: || ' AND pa_expenditures_utils.Get_Latest_GL_Date(ei.expenditure_item_id) >= trunc(:end_gl_date)';
5800: end if ;

Line 5799: || ' AND pa_expenditures_utils.Get_Latest_GL_Date(ei.expenditure_item_id) >= trunc(:end_gl_date)';

5795: where_clause := where_clause
5796: || ' AND pa_expenditures_utils.Get_Latest_GL_Date(ei.expenditure_item_id) >= trunc(:start_gl_date)';
5797: elsif p_end_gl_date is not null then
5798: where_clause := where_clause
5799: || ' AND pa_expenditures_utils.Get_Latest_GL_Date(ei.expenditure_item_id) >= trunc(:end_gl_date)';
5800: end if ;
5801:
5802: if p_start_pa_date is not null
5803: and p_end_pa_date is not null then

Line 5805: || ' AND pa_expenditures_utils.Get_Latest_PA_Date(ei.expenditure_item_id)'

5801:
5802: if p_start_pa_date is not null
5803: and p_end_pa_date is not null then
5804: where_clause := where_clause
5805: || ' AND pa_expenditures_utils.Get_Latest_PA_Date(ei.expenditure_item_id)'
5806: || ' BETWEEN trunc(:start_pa_date) AND trunc(:end_pa_date)';
5807: elsif p_start_pa_date is not null then
5808: where_clause := where_clause
5809: || ' AND pa_expenditures_utils.Get_Latest_PA_Date(ei.expenditure_item_id) >= trunc(:start_pa_date)';

Line 5809: || ' AND pa_expenditures_utils.Get_Latest_PA_Date(ei.expenditure_item_id) >= trunc(:start_pa_date)';

5805: || ' AND pa_expenditures_utils.Get_Latest_PA_Date(ei.expenditure_item_id)'
5806: || ' BETWEEN trunc(:start_pa_date) AND trunc(:end_pa_date)';
5807: elsif p_start_pa_date is not null then
5808: where_clause := where_clause
5809: || ' AND pa_expenditures_utils.Get_Latest_PA_Date(ei.expenditure_item_id) >= trunc(:start_pa_date)';
5810: elsif p_end_pa_date is not null then
5811: where_clause := where_clause
5812: || ' AND pa_expenditures_utils.Get_Latest_PA_Date(ei.expenditure_item_id) >= trunc(:end_pa_date)';
5813: end if ;

Line 5812: || ' AND pa_expenditures_utils.Get_Latest_PA_Date(ei.expenditure_item_id) >= trunc(:end_pa_date)';

5808: where_clause := where_clause
5809: || ' AND pa_expenditures_utils.Get_Latest_PA_Date(ei.expenditure_item_id) >= trunc(:start_pa_date)';
5810: elsif p_end_pa_date is not null then
5811: where_clause := where_clause
5812: || ' AND pa_expenditures_utils.Get_Latest_PA_Date(ei.expenditure_item_id) >= trunc(:end_pa_date)';
5813: end if ;
5814:
5815: if X_cc_recvr_organization_id is not null then
5816: where_clause := where_clause || ' AND ei.cc_recvr_organization_id = :cc_recvr_organization_id';

Line 5826: || ' AND pa_expenditures_utils.Get_Latest_GL_Date(ei.expenditure_item_id)'

5822:
5823: if p_recvr_start_gl_date is not null
5824: and p_recvr_end_gl_date is not null then
5825: where_clause := where_clause
5826: || ' AND pa_expenditures_utils.Get_Latest_GL_Date(ei.expenditure_item_id)'
5827: || ' BETWEEN trunc(:recvr_start_gl_date) AND trunc(:recvr_end_gl_date)';
5828: elsif p_recvr_start_gl_date is not null then
5829: where_clause := where_clause
5830: || ' AND pa_expenditures_utils.Get_Latest_GL_Date(ei.expenditure_item_id) >= trunc(:recvr_start_gl_date)';

Line 5830: || ' AND pa_expenditures_utils.Get_Latest_GL_Date(ei.expenditure_item_id) >= trunc(:recvr_start_gl_date)';

5826: || ' AND pa_expenditures_utils.Get_Latest_GL_Date(ei.expenditure_item_id)'
5827: || ' BETWEEN trunc(:recvr_start_gl_date) AND trunc(:recvr_end_gl_date)';
5828: elsif p_recvr_start_gl_date is not null then
5829: where_clause := where_clause
5830: || ' AND pa_expenditures_utils.Get_Latest_GL_Date(ei.expenditure_item_id) >= trunc(:recvr_start_gl_date)';
5831: elsif p_recvr_end_gl_date is not null then
5832: where_clause := where_clause
5833: || ' AND pa_expenditures_utils.Get_Latest_GL_Date(ei.expenditure_item_id) >= trunc(:recvr_end_gl_date)';
5834: end if ;

Line 5833: || ' AND pa_expenditures_utils.Get_Latest_GL_Date(ei.expenditure_item_id) >= trunc(:recvr_end_gl_date)';

5829: where_clause := where_clause
5830: || ' AND pa_expenditures_utils.Get_Latest_GL_Date(ei.expenditure_item_id) >= trunc(:recvr_start_gl_date)';
5831: elsif p_recvr_end_gl_date is not null then
5832: where_clause := where_clause
5833: || ' AND pa_expenditures_utils.Get_Latest_GL_Date(ei.expenditure_item_id) >= trunc(:recvr_end_gl_date)';
5834: end if ;
5835:
5836: if p_recvr_start_pa_date is not null
5837: and p_recvr_end_pa_date is not null then

Line 5839: || ' AND pa_expenditures_utils.Get_Latest_PA_Date(ei.expenditure_item_id)'

5835:
5836: if p_recvr_start_pa_date is not null
5837: and p_recvr_end_pa_date is not null then
5838: where_clause := where_clause
5839: || ' AND pa_expenditures_utils.Get_Latest_PA_Date(ei.expenditure_item_id)'
5840: || ' BETWEEN trunc(:recvr_start_pa_date) AND trunc(:recvr_end_pa_date)';
5841: elsif p_recvr_start_pa_date is not null then
5842: where_clause := where_clause
5843: || ' AND pa_expenditures_utils.Get_Latest_PA_Date(ei.expenditure_item_id) >= trunc(:recvr_start_pa_date)';

Line 5843: || ' AND pa_expenditures_utils.Get_Latest_PA_Date(ei.expenditure_item_id) >= trunc(:recvr_start_pa_date)';

5839: || ' AND pa_expenditures_utils.Get_Latest_PA_Date(ei.expenditure_item_id)'
5840: || ' BETWEEN trunc(:recvr_start_pa_date) AND trunc(:recvr_end_pa_date)';
5841: elsif p_recvr_start_pa_date is not null then
5842: where_clause := where_clause
5843: || ' AND pa_expenditures_utils.Get_Latest_PA_Date(ei.expenditure_item_id) >= trunc(:recvr_start_pa_date)';
5844: elsif p_recvr_end_pa_date is not null then
5845: where_clause := where_clause
5846: || ' AND pa_expenditures_utils.Get_Latest_PA_Date(ei.expenditure_item_id) >= trunc(:recvr_end_pa_date)';
5847: end if ;

Line 5846: || ' AND pa_expenditures_utils.Get_Latest_PA_Date(ei.expenditure_item_id) >= trunc(:recvr_end_pa_date)';

5842: where_clause := where_clause
5843: || ' AND pa_expenditures_utils.Get_Latest_PA_Date(ei.expenditure_item_id) >= trunc(:recvr_start_pa_date)';
5844: elsif p_recvr_end_pa_date is not null then
5845: where_clause := where_clause
5846: || ' AND pa_expenditures_utils.Get_Latest_PA_Date(ei.expenditure_item_id) >= trunc(:recvr_end_pa_date)';
5847: end if ;
5848:
5849: if x_capitalizable_flag is not null then
5850: where_clause := where_clause || ' AND 1 = (SELECT 1'

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;