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

Line 603: l_job_id pa_expenditure_items_all.job_id%type;

599: FUNCTION GetEmpCostRate ( X_person_id IN NUMBER
600: , X_date IN DATE ) RETURN NUMBER
601: IS
602: X_cost_rate NUMBER(22,5);
603: l_job_id pa_expenditure_items_all.job_id%type;
604: l_costing_rule pa_compensation_details_all.compensation_rule_set%type;
605: l_start_date_active date;
606: l_end_date_active date;
607: l_organization_id number;

Line 2251: l_job_id pa_expenditure_items_all.job_id%TYPE;

2247:
2248: l_org_id pa_implementations_all.org_id%TYPE;
2249: l_organization_id pa_expenditures_all.incurred_by_organization_id%TYPE;
2250: l_person_id pa_expenditures_all.incurred_by_person_id%TYPE;
2251: l_job_id pa_expenditure_items_all.job_id%TYPE;
2252: l_txn_date pa_expenditure_items_all.expenditure_item_date%TYPE;
2253:
2254: lx_override_type varchar2(150);
2255: lx_org_labor_sch_rule_id pa_org_labor_sch_rule.org_labor_sch_rule_id%TYPE;

Line 2252: l_txn_date pa_expenditure_items_all.expenditure_item_date%TYPE;

2248: l_org_id pa_implementations_all.org_id%TYPE;
2249: l_organization_id pa_expenditures_all.incurred_by_organization_id%TYPE;
2250: l_person_id pa_expenditures_all.incurred_by_person_id%TYPE;
2251: l_job_id pa_expenditure_items_all.job_id%TYPE;
2252: l_txn_date pa_expenditure_items_all.expenditure_item_date%TYPE;
2253:
2254: lx_override_type varchar2(150);
2255: lx_org_labor_sch_rule_id pa_org_labor_sch_rule.org_labor_sch_rule_id%TYPE;
2256: lx_costing_rule pa_compensation_rule_sets.compensation_rule_set%TYPE;

Line 2262: lx_cost_rate_curr_code pa_expenditure_items_all.denom_currency_code%TYPE;

2258: lx_ot_project_id pa_projects_all.project_id%TYPE;
2259: lx_ot_task_id pa_tasks.task_id%TYPE;
2260: lx_base_hours pa_org_labor_sch_rule.base_hours%TYPE;
2261: lx_rbc_elem_type_id pa_org_labor_sch_rule.rbc_element_type_id%TYPE;
2262: lx_cost_rate_curr_code pa_expenditure_items_all.denom_currency_code%TYPE;
2263: lx_acct_rate_type pa_expenditure_items_all.acct_rate_type%TYPE;
2264: lx_acct_rate_date_code pa_implementations_all.acct_rate_date_code%TYPE;
2265: lx_acct_exch_rate pa_compensation_details_all.acct_exchange_rate%TYPE;
2266: lx_err_stage number;

Line 2263: lx_acct_rate_type pa_expenditure_items_all.acct_rate_type%TYPE;

2259: lx_ot_task_id pa_tasks.task_id%TYPE;
2260: lx_base_hours pa_org_labor_sch_rule.base_hours%TYPE;
2261: lx_rbc_elem_type_id pa_org_labor_sch_rule.rbc_element_type_id%TYPE;
2262: lx_cost_rate_curr_code pa_expenditure_items_all.denom_currency_code%TYPE;
2263: lx_acct_rate_type pa_expenditure_items_all.acct_rate_type%TYPE;
2264: lx_acct_rate_date_code pa_implementations_all.acct_rate_date_code%TYPE;
2265: lx_acct_exch_rate pa_compensation_details_all.acct_exchange_rate%TYPE;
2266: lx_err_stage number;
2267: lx_err_code varchar2(150);

Line 2382: l_job_id pa_expenditure_items_all.job_id%TYPE;

2378:
2379: l_org_id pa_implementations_all.org_id%TYPE;
2380: l_organization_id pa_expenditures_all.incurred_by_organization_id%TYPE;
2381: l_person_id pa_expenditures_all.incurred_by_person_id%TYPE;
2382: l_job_id pa_expenditure_items_all.job_id%TYPE;
2383: l_txn_date pa_expenditure_items_all.expenditure_item_date%TYPE;
2384:
2385: lx_override_type varchar2(150);
2386: lx_org_labor_sch_rule_id pa_org_labor_sch_rule.org_labor_sch_rule_id%TYPE;

Line 2383: l_txn_date pa_expenditure_items_all.expenditure_item_date%TYPE;

2379: l_org_id pa_implementations_all.org_id%TYPE;
2380: l_organization_id pa_expenditures_all.incurred_by_organization_id%TYPE;
2381: l_person_id pa_expenditures_all.incurred_by_person_id%TYPE;
2382: l_job_id pa_expenditure_items_all.job_id%TYPE;
2383: l_txn_date pa_expenditure_items_all.expenditure_item_date%TYPE;
2384:
2385: lx_override_type varchar2(150);
2386: lx_org_labor_sch_rule_id pa_org_labor_sch_rule.org_labor_sch_rule_id%TYPE;
2387: lx_costing_rule pa_compensation_rule_sets.compensation_rule_set%TYPE;

Line 2393: lx_cost_rate_curr_code pa_expenditure_items_all.denom_currency_code%TYPE;

2389: lx_ot_project_id pa_projects_all.project_id%TYPE;
2390: lx_ot_task_id pa_tasks.task_id%TYPE;
2391: lx_base_hours pa_org_labor_sch_rule.base_hours%TYPE;
2392: lx_rbc_elem_type_id pa_org_labor_sch_rule.rbc_element_type_id%TYPE;
2393: lx_cost_rate_curr_code pa_expenditure_items_all.denom_currency_code%TYPE;
2394: lx_acct_rate_type pa_expenditure_items_all.acct_rate_type%TYPE;
2395: lx_acct_rate_date_code pa_implementations_all.acct_rate_date_code%TYPE;
2396: lx_acct_exch_rate pa_compensation_details_all.acct_exchange_rate%TYPE;
2397: lx_err_stage number;

Line 2394: lx_acct_rate_type pa_expenditure_items_all.acct_rate_type%TYPE;

2390: lx_ot_task_id pa_tasks.task_id%TYPE;
2391: lx_base_hours pa_org_labor_sch_rule.base_hours%TYPE;
2392: lx_rbc_elem_type_id pa_org_labor_sch_rule.rbc_element_type_id%TYPE;
2393: lx_cost_rate_curr_code pa_expenditure_items_all.denom_currency_code%TYPE;
2394: lx_acct_rate_type pa_expenditure_items_all.acct_rate_type%TYPE;
2395: lx_acct_rate_date_code pa_implementations_all.acct_rate_date_code%TYPE;
2396: lx_acct_exch_rate pa_compensation_details_all.acct_exchange_rate%TYPE;
2397: lx_err_stage number;
2398: lx_err_code varchar2(150);

Line 2482: from pa_expenditure_items_all a

2478: b.module_code, x.costing_method,
2479: decode(b.module_code, 'PAXREVTXN', 'A', 'B') ord
2480: from
2481: (select a.expenditure_item_id, cost_distributed_flag, costing_method
2482: from pa_expenditure_items_all a
2483: where a.adjusted_expenditure_item_id IS NULL
2484: --and cost_distributed_flag = 'Y'
2485: start with expenditure_item_id = p_xfer_item_id
2486: connect by prior a.expenditure_item_id = a.transferred_from_exp_item_id) x,