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_EXPENDITURES

Line 2081: ,pa_expenditures exp

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
2085: and exp.expenditure_id = ei.expenditure_id

Line 2221: ,pa_expenditures exp

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
2225: and exp.expenditure_id = ei.expenditure_id

Line 2237: ,pa_expenditures exp

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;
2241:

Line 2249: l_organization_id pa_expenditures_all.incurred_by_organization_id%TYPE;

2245:
2246: l_debug_mode varchar2(1);
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:

Line 2250: l_person_id pa_expenditures_all.incurred_by_person_id%TYPE;

2246: l_debug_mode varchar2(1);
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);

Line 2380: l_organization_id pa_expenditures_all.incurred_by_organization_id%TYPE;

2376:
2377: l_debug_mode varchar2(1);
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:

Line 2381: l_person_id pa_expenditures_all.incurred_by_person_id%TYPE;

2377: l_debug_mode varchar2(1);
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);