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

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 1081: pa_expenditure_items_s.nextval

1077: IS
1078: X_expenditure_item_id NUMBER(15);
1079: BEGIN
1080: SELECT
1081: pa_expenditure_items_s.nextval
1082: INTO
1083: X_expenditure_item_id
1084: FROM
1085: sys.dual;

Line 2080: ,pa_expenditure_items ei

2076: ,detail.acct_exchange_rate
2077: ,detail.base_hours
2078: ,detail.rbc_element_type_id
2079: from pa_compensation_details detail
2080: ,pa_expenditure_items ei
2081: ,pa_expenditures exp
2082: where trunc(p_exp_item_date) between trunc(detail.start_date_active)
2083: and trunc(nvl(detail.end_date_active,p_exp_item_date))
2084: and detail.person_id = exp.incurred_by_person_id

Line 2220: ,pa_expenditure_items ei

2216: ,detail.acct_exchange_rate
2217: ,detail.base_hours
2218: ,detail.rbc_element_type_id
2219: from pa_compensation_details detail
2220: ,pa_expenditure_items ei
2221: ,pa_expenditures exp
2222: where trunc(p_exp_item_date) between trunc(detail.start_date_active)
2223: and trunc(nvl(detail.end_date_active,p_exp_item_date))
2224: and detail.person_id = exp.incurred_by_person_id

Line 2236: from pa_expenditure_items ei

2232: ,nvl(ei.override_to_organization_id
2233: ,exp.incurred_by_organization_id) orgj_id
2234: ,exp.incurred_by_person_id incurred_by_person_id
2235: ,ei.job_id JOB_ID
2236: from pa_expenditure_items ei
2237: ,pa_expenditures exp
2238: where exp.expenditure_id = ei.expenditure_id
2239: and ei.expenditure_item_id = p_exp_item_id
2240: and ei.po_line_id IS NULL;

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,