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: -- reversing item's orig_transaction_reference
198: DECODE(X_reversed_orig_txn_reference,NULL, i.orig_transaction_reference, X_reversed_orig_txn_reference) orig_txn_reference
199: FROM pa_transaction_sources ts ,
200: pa_expenditure_items i ,
201: pa_expenditures e
202: WHERE i.expenditure_item_date = X_item_date
203: AND i.task_id = X_task_id
204: AND i.expenditure_type ||'' = X_exp_type
205: AND i.system_linkage_function ||'' = X_system_linkage_function

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

5932:
5933: if p_start_gl_date is not null
5934: and p_end_gl_date is not null then
5935: where_clause := where_clause
5936: || ' AND pa_expenditures_utils.Get_Latest_GL_Date(ei.expenditure_item_id)'
5937: || ' BETWEEN trunc(:start_gl_date) AND trunc(:end_gl_date)';
5938: elsif p_start_gl_date is not null then
5939: where_clause := where_clause
5940: || ' AND pa_expenditures_utils.Get_Latest_GL_Date(ei.expenditure_item_id) >= trunc(:start_gl_date)';

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

5936: || ' AND pa_expenditures_utils.Get_Latest_GL_Date(ei.expenditure_item_id)'
5937: || ' BETWEEN trunc(:start_gl_date) AND trunc(:end_gl_date)';
5938: elsif p_start_gl_date is not null then
5939: where_clause := where_clause
5940: || ' AND pa_expenditures_utils.Get_Latest_GL_Date(ei.expenditure_item_id) >= trunc(:start_gl_date)';
5941: elsif p_end_gl_date is not null then
5942: where_clause := where_clause
5943: || ' AND pa_expenditures_utils.Get_Latest_GL_Date(ei.expenditure_item_id) >= trunc(:end_gl_date)';
5944: end if ;

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

5939: where_clause := where_clause
5940: || ' AND pa_expenditures_utils.Get_Latest_GL_Date(ei.expenditure_item_id) >= trunc(:start_gl_date)';
5941: elsif p_end_gl_date is not null then
5942: where_clause := where_clause
5943: || ' AND pa_expenditures_utils.Get_Latest_GL_Date(ei.expenditure_item_id) >= trunc(:end_gl_date)';
5944: end if ;
5945:
5946: if p_start_pa_date is not null
5947: and p_end_pa_date is not null then

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

5945:
5946: if p_start_pa_date is not null
5947: and p_end_pa_date is not null then
5948: where_clause := where_clause
5949: || ' AND pa_expenditures_utils.Get_Latest_PA_Date(ei.expenditure_item_id)'
5950: || ' BETWEEN trunc(:start_pa_date) AND trunc(:end_pa_date)';
5951: elsif p_start_pa_date is not null then
5952: where_clause := where_clause
5953: || ' AND pa_expenditures_utils.Get_Latest_PA_Date(ei.expenditure_item_id) >= trunc(:start_pa_date)';

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

5949: || ' AND pa_expenditures_utils.Get_Latest_PA_Date(ei.expenditure_item_id)'
5950: || ' BETWEEN trunc(:start_pa_date) AND trunc(:end_pa_date)';
5951: elsif p_start_pa_date is not null then
5952: where_clause := where_clause
5953: || ' AND pa_expenditures_utils.Get_Latest_PA_Date(ei.expenditure_item_id) >= trunc(:start_pa_date)';
5954: elsif p_end_pa_date is not null then
5955: where_clause := where_clause
5956: || ' AND pa_expenditures_utils.Get_Latest_PA_Date(ei.expenditure_item_id) >= trunc(:end_pa_date)';
5957: end if ;

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

5952: where_clause := where_clause
5953: || ' AND pa_expenditures_utils.Get_Latest_PA_Date(ei.expenditure_item_id) >= trunc(:start_pa_date)';
5954: elsif p_end_pa_date is not null then
5955: where_clause := where_clause
5956: || ' AND pa_expenditures_utils.Get_Latest_PA_Date(ei.expenditure_item_id) >= trunc(:end_pa_date)';
5957: end if ;
5958:
5959: if X_cc_recvr_organization_id is not null then
5960: where_clause := where_clause || ' AND ei.cc_recvr_organization_id = :cc_recvr_organization_id';

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

5966:
5967: if p_recvr_start_gl_date is not null
5968: and p_recvr_end_gl_date is not null then
5969: where_clause := where_clause
5970: || ' AND pa_expenditures_utils.Get_Latest_GL_Date(ei.expenditure_item_id)'
5971: || ' BETWEEN trunc(:recvr_start_gl_date) AND trunc(:recvr_end_gl_date)';
5972: elsif p_recvr_start_gl_date is not null then
5973: where_clause := where_clause
5974: || ' AND pa_expenditures_utils.Get_Latest_GL_Date(ei.expenditure_item_id) >= trunc(:recvr_start_gl_date)';

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

5970: || ' AND pa_expenditures_utils.Get_Latest_GL_Date(ei.expenditure_item_id)'
5971: || ' BETWEEN trunc(:recvr_start_gl_date) AND trunc(:recvr_end_gl_date)';
5972: elsif p_recvr_start_gl_date is not null then
5973: where_clause := where_clause
5974: || ' AND pa_expenditures_utils.Get_Latest_GL_Date(ei.expenditure_item_id) >= trunc(:recvr_start_gl_date)';
5975: elsif p_recvr_end_gl_date is not null then
5976: where_clause := where_clause
5977: || ' AND pa_expenditures_utils.Get_Latest_GL_Date(ei.expenditure_item_id) >= trunc(:recvr_end_gl_date)';
5978: end if ;

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

5973: where_clause := where_clause
5974: || ' AND pa_expenditures_utils.Get_Latest_GL_Date(ei.expenditure_item_id) >= trunc(:recvr_start_gl_date)';
5975: elsif p_recvr_end_gl_date is not null then
5976: where_clause := where_clause
5977: || ' AND pa_expenditures_utils.Get_Latest_GL_Date(ei.expenditure_item_id) >= trunc(:recvr_end_gl_date)';
5978: end if ;
5979:
5980: if p_recvr_start_pa_date is not null
5981: and p_recvr_end_pa_date is not null then

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

5979:
5980: if p_recvr_start_pa_date is not null
5981: and p_recvr_end_pa_date is not null then
5982: where_clause := where_clause
5983: || ' AND pa_expenditures_utils.Get_Latest_PA_Date(ei.expenditure_item_id)'
5984: || ' BETWEEN trunc(:recvr_start_pa_date) AND trunc(:recvr_end_pa_date)';
5985: elsif p_recvr_start_pa_date is not null then
5986: where_clause := where_clause
5987: || ' AND pa_expenditures_utils.Get_Latest_PA_Date(ei.expenditure_item_id) >= trunc(:recvr_start_pa_date)';

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

5983: || ' AND pa_expenditures_utils.Get_Latest_PA_Date(ei.expenditure_item_id)'
5984: || ' BETWEEN trunc(:recvr_start_pa_date) AND trunc(:recvr_end_pa_date)';
5985: elsif p_recvr_start_pa_date is not null then
5986: where_clause := where_clause
5987: || ' AND pa_expenditures_utils.Get_Latest_PA_Date(ei.expenditure_item_id) >= trunc(:recvr_start_pa_date)';
5988: elsif p_recvr_end_pa_date is not null then
5989: where_clause := where_clause
5990: || ' AND pa_expenditures_utils.Get_Latest_PA_Date(ei.expenditure_item_id) >= trunc(:recvr_end_pa_date)';
5991: end if ;

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

5986: where_clause := where_clause
5987: || ' AND pa_expenditures_utils.Get_Latest_PA_Date(ei.expenditure_item_id) >= trunc(:recvr_start_pa_date)';
5988: elsif p_recvr_end_pa_date is not null then
5989: where_clause := where_clause
5990: || ' AND pa_expenditures_utils.Get_Latest_PA_Date(ei.expenditure_item_id) >= trunc(:recvr_end_pa_date)';
5991: end if ;
5992:
5993: if x_capitalizable_flag is not null then
5994: where_clause := where_clause || ' AND 1 = (SELECT 1'

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;