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_XLA_SWEEP_TXN_PKG dependencies on PA_EXPENDITURE_ITEMS_ALL

Line 249: FROM pa_expenditure_items_all ei,

245: ei.projfunc_cost_rate_date,
246: ei.projfunc_cost_rate_type,
247: ei.projfunc_cost_exchange_rate,
248: ei.work_type_id
249: FROM pa_expenditure_items_all ei,
250: pa_cost_distribution_lines_all cdl,
251: pa_transaction_sources tr
252: WHERE tr.transaction_source(+) = ei.transaction_source
253: AND ei.expenditure_item_id = cdl.expenditure_item_id

Line 280: PA_Expenditure_items_all EI,

276: ei.document_distribution_id ,
277: ei.expenditure_type ,
278: cdl.Acct_Event_ID
279: From PA_Cost_Distribution_lines_ALL CDL,
280: PA_Expenditure_items_all EI,
281: PA_IMPLEMENTATIONS_ALL IMP ,
282: PA_EXPENDITURES_ALL EXP ,
283: PA_EXPENDITURE_GROUPS_ALL EXP_GRP
284: Where CDL.Transfer_Status_Code = 'X'

Line 518: l_adj_exp_item_id pa_expenditure_items_all.adjusted_expenditure_item_id%type;

514:
515: Procedure CHECK_MISC_TXNS
516: Is
517: v_gl_per_end_dt DATE;
518: l_adj_exp_item_id pa_expenditure_items_all.adjusted_expenditure_item_id%type;
519: l_exp_item_id pa_expenditure_items_all.expenditure_item_id%type;
520: l_gl_date DATE;
521: l_pji_summarized_flag VARCHAR2(1);
522: l_prvdr_accr_date DATE;

Line 519: l_exp_item_id pa_expenditure_items_all.expenditure_item_id%type;

515: Procedure CHECK_MISC_TXNS
516: Is
517: v_gl_per_end_dt DATE;
518: l_adj_exp_item_id pa_expenditure_items_all.adjusted_expenditure_item_id%type;
519: l_exp_item_id pa_expenditure_items_all.expenditure_item_id%type;
520: l_gl_date DATE;
521: l_pji_summarized_flag VARCHAR2(1);
522: l_prvdr_accr_date DATE;
523: l_billable_flag pa_cost_distribution_lines_all.billable_flag%type;

Line 526: l_denom_currency_code pa_expenditure_items_all.denom_currency_code%type;

522: l_prvdr_accr_date DATE;
523: l_billable_flag pa_cost_distribution_lines_all.billable_flag%type;
524: l_line_type VARCHAR2(1);
525: l_line_num NUMBER ;
526: l_denom_currency_code pa_expenditure_items_all.denom_currency_code%type;
527: l_acct_currency_code pa_expenditure_items_all.acct_currency_code%type;
528: l_acct_rate_date pa_expenditure_items_all.acct_rate_date%type;
529: l_acct_rate_type pa_expenditure_items_all.acct_rate_type%type;
530: l_acct_exchange_rate pa_expenditure_items_all.acct_exchange_rate%type;

Line 527: l_acct_currency_code pa_expenditure_items_all.acct_currency_code%type;

523: l_billable_flag pa_cost_distribution_lines_all.billable_flag%type;
524: l_line_type VARCHAR2(1);
525: l_line_num NUMBER ;
526: l_denom_currency_code pa_expenditure_items_all.denom_currency_code%type;
527: l_acct_currency_code pa_expenditure_items_all.acct_currency_code%type;
528: l_acct_rate_date pa_expenditure_items_all.acct_rate_date%type;
529: l_acct_rate_type pa_expenditure_items_all.acct_rate_type%type;
530: l_acct_exchange_rate pa_expenditure_items_all.acct_exchange_rate%type;
531: l_project_currency_code pa_expenditure_items_all.project_currency_code%type;

Line 528: l_acct_rate_date pa_expenditure_items_all.acct_rate_date%type;

524: l_line_type VARCHAR2(1);
525: l_line_num NUMBER ;
526: l_denom_currency_code pa_expenditure_items_all.denom_currency_code%type;
527: l_acct_currency_code pa_expenditure_items_all.acct_currency_code%type;
528: l_acct_rate_date pa_expenditure_items_all.acct_rate_date%type;
529: l_acct_rate_type pa_expenditure_items_all.acct_rate_type%type;
530: l_acct_exchange_rate pa_expenditure_items_all.acct_exchange_rate%type;
531: l_project_currency_code pa_expenditure_items_all.project_currency_code%type;
532: l_project_rate_date pa_expenditure_items_all.project_rate_date%type;

Line 529: l_acct_rate_type pa_expenditure_items_all.acct_rate_type%type;

525: l_line_num NUMBER ;
526: l_denom_currency_code pa_expenditure_items_all.denom_currency_code%type;
527: l_acct_currency_code pa_expenditure_items_all.acct_currency_code%type;
528: l_acct_rate_date pa_expenditure_items_all.acct_rate_date%type;
529: l_acct_rate_type pa_expenditure_items_all.acct_rate_type%type;
530: l_acct_exchange_rate pa_expenditure_items_all.acct_exchange_rate%type;
531: l_project_currency_code pa_expenditure_items_all.project_currency_code%type;
532: l_project_rate_date pa_expenditure_items_all.project_rate_date%type;
533: l_project_rate_type pa_expenditure_items_all.project_rate_type%type;

Line 530: l_acct_exchange_rate pa_expenditure_items_all.acct_exchange_rate%type;

526: l_denom_currency_code pa_expenditure_items_all.denom_currency_code%type;
527: l_acct_currency_code pa_expenditure_items_all.acct_currency_code%type;
528: l_acct_rate_date pa_expenditure_items_all.acct_rate_date%type;
529: l_acct_rate_type pa_expenditure_items_all.acct_rate_type%type;
530: l_acct_exchange_rate pa_expenditure_items_all.acct_exchange_rate%type;
531: l_project_currency_code pa_expenditure_items_all.project_currency_code%type;
532: l_project_rate_date pa_expenditure_items_all.project_rate_date%type;
533: l_project_rate_type pa_expenditure_items_all.project_rate_type%type;
534: l_project_exchange_rate pa_expenditure_items_all.project_exchange_rate%type;

Line 531: l_project_currency_code pa_expenditure_items_all.project_currency_code%type;

527: l_acct_currency_code pa_expenditure_items_all.acct_currency_code%type;
528: l_acct_rate_date pa_expenditure_items_all.acct_rate_date%type;
529: l_acct_rate_type pa_expenditure_items_all.acct_rate_type%type;
530: l_acct_exchange_rate pa_expenditure_items_all.acct_exchange_rate%type;
531: l_project_currency_code pa_expenditure_items_all.project_currency_code%type;
532: l_project_rate_date pa_expenditure_items_all.project_rate_date%type;
533: l_project_rate_type pa_expenditure_items_all.project_rate_type%type;
534: l_project_exchange_rate pa_expenditure_items_all.project_exchange_rate%type;
535: l_projfunc_currency_code pa_expenditure_items_all.projfunc_currency_code%type;

Line 532: l_project_rate_date pa_expenditure_items_all.project_rate_date%type;

528: l_acct_rate_date pa_expenditure_items_all.acct_rate_date%type;
529: l_acct_rate_type pa_expenditure_items_all.acct_rate_type%type;
530: l_acct_exchange_rate pa_expenditure_items_all.acct_exchange_rate%type;
531: l_project_currency_code pa_expenditure_items_all.project_currency_code%type;
532: l_project_rate_date pa_expenditure_items_all.project_rate_date%type;
533: l_project_rate_type pa_expenditure_items_all.project_rate_type%type;
534: l_project_exchange_rate pa_expenditure_items_all.project_exchange_rate%type;
535: l_projfunc_currency_code pa_expenditure_items_all.projfunc_currency_code%type;
536: l_projfunc_cost_rate_date pa_expenditure_items_all.projfunc_cost_rate_date%type;

Line 533: l_project_rate_type pa_expenditure_items_all.project_rate_type%type;

529: l_acct_rate_type pa_expenditure_items_all.acct_rate_type%type;
530: l_acct_exchange_rate pa_expenditure_items_all.acct_exchange_rate%type;
531: l_project_currency_code pa_expenditure_items_all.project_currency_code%type;
532: l_project_rate_date pa_expenditure_items_all.project_rate_date%type;
533: l_project_rate_type pa_expenditure_items_all.project_rate_type%type;
534: l_project_exchange_rate pa_expenditure_items_all.project_exchange_rate%type;
535: l_projfunc_currency_code pa_expenditure_items_all.projfunc_currency_code%type;
536: l_projfunc_cost_rate_date pa_expenditure_items_all.projfunc_cost_rate_date%type;
537: l_projfunc_cost_rate_type pa_expenditure_items_all.projfunc_cost_rate_type%type;

Line 534: l_project_exchange_rate pa_expenditure_items_all.project_exchange_rate%type;

530: l_acct_exchange_rate pa_expenditure_items_all.acct_exchange_rate%type;
531: l_project_currency_code pa_expenditure_items_all.project_currency_code%type;
532: l_project_rate_date pa_expenditure_items_all.project_rate_date%type;
533: l_project_rate_type pa_expenditure_items_all.project_rate_type%type;
534: l_project_exchange_rate pa_expenditure_items_all.project_exchange_rate%type;
535: l_projfunc_currency_code pa_expenditure_items_all.projfunc_currency_code%type;
536: l_projfunc_cost_rate_date pa_expenditure_items_all.projfunc_cost_rate_date%type;
537: l_projfunc_cost_rate_type pa_expenditure_items_all.projfunc_cost_rate_type%type;
538: l_projfunc_cost_exchange_rate pa_expenditure_items_all.projfunc_cost_exchange_rate%type;

Line 535: l_projfunc_currency_code pa_expenditure_items_all.projfunc_currency_code%type;

531: l_project_currency_code pa_expenditure_items_all.project_currency_code%type;
532: l_project_rate_date pa_expenditure_items_all.project_rate_date%type;
533: l_project_rate_type pa_expenditure_items_all.project_rate_type%type;
534: l_project_exchange_rate pa_expenditure_items_all.project_exchange_rate%type;
535: l_projfunc_currency_code pa_expenditure_items_all.projfunc_currency_code%type;
536: l_projfunc_cost_rate_date pa_expenditure_items_all.projfunc_cost_rate_date%type;
537: l_projfunc_cost_rate_type pa_expenditure_items_all.projfunc_cost_rate_type%type;
538: l_projfunc_cost_exchange_rate pa_expenditure_items_all.projfunc_cost_exchange_rate%type;
539: l_work_type_id pa_expenditure_items_all.work_type_id%type;

Line 536: l_projfunc_cost_rate_date pa_expenditure_items_all.projfunc_cost_rate_date%type;

532: l_project_rate_date pa_expenditure_items_all.project_rate_date%type;
533: l_project_rate_type pa_expenditure_items_all.project_rate_type%type;
534: l_project_exchange_rate pa_expenditure_items_all.project_exchange_rate%type;
535: l_projfunc_currency_code pa_expenditure_items_all.projfunc_currency_code%type;
536: l_projfunc_cost_rate_date pa_expenditure_items_all.projfunc_cost_rate_date%type;
537: l_projfunc_cost_rate_type pa_expenditure_items_all.projfunc_cost_rate_type%type;
538: l_projfunc_cost_exchange_rate pa_expenditure_items_all.projfunc_cost_exchange_rate%type;
539: l_work_type_id pa_expenditure_items_all.work_type_id%type;
540:

Line 537: l_projfunc_cost_rate_type pa_expenditure_items_all.projfunc_cost_rate_type%type;

533: l_project_rate_type pa_expenditure_items_all.project_rate_type%type;
534: l_project_exchange_rate pa_expenditure_items_all.project_exchange_rate%type;
535: l_projfunc_currency_code pa_expenditure_items_all.projfunc_currency_code%type;
536: l_projfunc_cost_rate_date pa_expenditure_items_all.projfunc_cost_rate_date%type;
537: l_projfunc_cost_rate_type pa_expenditure_items_all.projfunc_cost_rate_type%type;
538: l_projfunc_cost_exchange_rate pa_expenditure_items_all.projfunc_cost_exchange_rate%type;
539: l_work_type_id pa_expenditure_items_all.work_type_id%type;
540:
541:

Line 538: l_projfunc_cost_exchange_rate pa_expenditure_items_all.projfunc_cost_exchange_rate%type;

534: l_project_exchange_rate pa_expenditure_items_all.project_exchange_rate%type;
535: l_projfunc_currency_code pa_expenditure_items_all.projfunc_currency_code%type;
536: l_projfunc_cost_rate_date pa_expenditure_items_all.projfunc_cost_rate_date%type;
537: l_projfunc_cost_rate_type pa_expenditure_items_all.projfunc_cost_rate_type%type;
538: l_projfunc_cost_exchange_rate pa_expenditure_items_all.projfunc_cost_exchange_rate%type;
539: l_work_type_id pa_expenditure_items_all.work_type_id%type;
540:
541:
542: l_acct_event_id pa_cost_distribution_lines_all.acct_event_id%type;

Line 539: l_work_type_id pa_expenditure_items_all.work_type_id%type;

535: l_projfunc_currency_code pa_expenditure_items_all.projfunc_currency_code%type;
536: l_projfunc_cost_rate_date pa_expenditure_items_all.projfunc_cost_rate_date%type;
537: l_projfunc_cost_rate_type pa_expenditure_items_all.projfunc_cost_rate_type%type;
538: l_projfunc_cost_exchange_rate pa_expenditure_items_all.projfunc_cost_exchange_rate%type;
539: l_work_type_id pa_expenditure_items_all.work_type_id%type;
540:
541:
542: l_acct_event_id pa_cost_distribution_lines_all.acct_event_id%type;
543: l_transfer_status_Code pa_cost_distribution_lines_all.transfer_status_code%type;

Line 606: PA_EXPENDITURE_ITEMS_ALL EI

602: l_acct_event_id,
603: l_transfer_status_code,
604: l_org_id
605: FROM PA_COST_DISTRIBUTION_LINES_ALL CDL,
606: PA_EXPENDITURE_ITEMS_ALL EI
607: WHERE CDL.EXPENDITURE_ITEM_ID = EI.EXPENDITURE_ITEM_ID
608: AND EI.ADJUSTED_EXPENDITURE_ITEM_ID = g_expenditure_item_id(g_currec);
609:
610: log_message ('Deriving Next Period for Reversing EI');

Line 754: pa_expenditure_items_all exp

750: bc_cm.liquidate_gl_date = g_gl_date_new_tab(i)
751: WHERE ( bc_cm.document_header_id,bc_cm.document_distribution_id,expenditure_type)
752: IN ( SELECT exp.document_header_id,exp.document_distribution_id,exp.expenditure_type
753: FROM PA_Cost_Distribution_lines cdl_raw,
754: pa_expenditure_items_all exp
755: WHERE cdl_raw.burden_sum_source_run_id = g_buren_Sum_Dest_Run_Id(i)
756: AND exp.expenditure_item_id = cdl_raw.expenditure_item_id
757: AND cdl_raw.line_num = 1
758: AND g_cdl_line_type(i) ='R'