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.GMS_SWEEPER dependencies on PA_EXPENDITURES_ALL

Line 16: person_id pa_expenditures_all.incurred_by_person_id%type,

12: Amount gms_event_attribute.bill_amount%type,
13: Reason Varchar2(200));
14:
15: Type Fail_Rec is RECORD(resource_list_id gms_bc_packets.resource_list_member_id%type,
16: person_id pa_expenditures_all.incurred_by_person_id%type,
17: job_id pa_expenditure_items_all.job_id%type,
18: org_id pa_expenditures_all.incurred_by_organization_id%type,
19: expenditure_type pa_expenditure_items_all.expenditure_type%type,
20: nlr pa_expenditure_items_all.non_labor_resource%type,

Line 18: org_id pa_expenditures_all.incurred_by_organization_id%type,

14:
15: Type Fail_Rec is RECORD(resource_list_id gms_bc_packets.resource_list_member_id%type,
16: person_id pa_expenditures_all.incurred_by_person_id%type,
17: job_id pa_expenditure_items_all.job_id%type,
18: org_id pa_expenditures_all.incurred_by_organization_id%type,
19: expenditure_type pa_expenditure_items_all.expenditure_type%type,
20: nlr pa_expenditure_items_all.non_labor_resource%type,
21: exp_category pa_expenditure_types.expenditure_category%type,
22: rev_category pa_expenditure_types.revenue_category_code%type,

Line 772: pa_expenditures_all pea,

768: nvl(pea.incurred_by_organization_id ,item.override_to_organization_id) org_id,
769: gbc.rowid
770: from gms_burden_components gbc,
771: pa_expenditure_items_all item ,
772: pa_expenditures_all pea,
773: gms_award_distributions gad ,
774: pa_resource_list_members prm
775: where gbc.expenditure_item_id = gad.expenditure_item_id
776: and gbc.adl_line_num = gad.adl_line_num

Line 804: -- pa_expenditures_all pea,

800: -- nvl(gbi.burden_exp_type,item.expenditure_type),
801: -- nvl(pea.incurred_by_organization_id,item.override_to_organization_id) org_id, gbi.rowid
802: -- from gms_billing_cancellations gbi,
803: -- pa_expenditure_items_all item ,
804: -- pa_expenditures_all pea,
805: -- gms_award_distributions gad ,
806: -- pa_resource_list_members prm
807: -- where gbi.expenditure_item_id = gad.expenditure_item_id
808: -- and item.expenditure_item_id = gad.expenditure_item_id

Line 874: pa_expenditures_all pea,

870: gbc.rowid
871: --item.org_id -- Bug 4732065 commented for the bug 5481465
872: from gms_burden_components gbc,
873: pa_expenditure_items_all item,
874: pa_expenditures_all pea,
875: gms_award_distributions gad,
876: pa_resource_list_members prm
877: where gbc.expenditure_item_id = gad.expenditure_item_id
878: and gbc.adl_line_num = gad.adl_line_num

Line 908: pa_expenditures_all pea,

904: gbi.rowid
905: --item.org_id -- Bug 4732065 commented for the bug 5481465
906: from gms_billing_cancellations gbi,
907: pa_expenditure_items_all item,
908: pa_expenditures_all pea,
909: gms_award_distributions gad,
910: pa_resource_list_members prm
911: where gbi.expenditure_item_id = gad.expenditure_item_id
912: and item.expenditure_item_id = gad.expenditure_item_id