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_TRANSACTIONS_PUB dependencies on PA_EXPENDITURES_ALL

Line 599: -- 2) pa_expenditures_all.incurred_by_person_id may or may not exist for Usages, and

595: --The following Cursor will select the item in Projects based upon the parameters passed
596: --to the API. It is a UNION because
597: -- 1) pa_expenditure_items_all.non_labor_resource and pa_expenditure_items_all.organization_id
598: -- (non labor resource owning organization) only exist for Usages (expenditure_type_class = 'USG')
599: -- 2) pa_expenditures_all.incurred_by_person_id may or may not exist for Usages, and
600: -- does not exist for Supplier Invoices.
601:
602: CURSOR item_in_projects IS
603: --The first part of the UNION handles all expenditure_type_classes EXCEPT

Line 607: pa_expenditures_all exp,

603: --The first part of the UNION handles all expenditure_type_classes EXCEPT
604: --Usages (USG) and Supplier Invoices (VI).
605: SELECT net_zero_adjustment_flag
606: FROM pa_expenditure_items_all ei,
607: pa_expenditures_all exp,
608: per_all_people_f per,
609: pa_projects_all proj,
610: pa_tasks task,
611: hr_all_organization_units hr1

Line 650: pa_expenditures_all exp,

646: --when IN parameter x_employee_number is NOT NULL. The additional join to
647: --hr_all_organization_units hr2 is required.
648: SELECT net_zero_adjustment_flag
649: FROM pa_expenditure_items_all ei,
650: pa_expenditures_all exp,
651: per_all_people_f per,
652: pa_projects_all proj,
653: pa_tasks task,
654: hr_all_organization_units hr1,

Line 697: pa_expenditures_all exp,

693: --when IN PARAMETER x_exployee_number IS NULL. The additional join to
694: --hr_all_organization_units hr2 is required and the join to per_all_people_f is not required.
695: SELECT net_zero_adjustment_flag
696: FROM pa_expenditure_items_all ei,
697: pa_expenditures_all exp,
698: pa_projects_all proj,
699: pa_tasks task,
700: hr_all_organization_units hr1,
701: hr_all_organization_units hr2

Line 736: --The join to per_all_people_f is not required as pa_expenditures_all.incurred_by_person_id

732: x_expenditure_type_class = 'USG' AND
733: x_employee_number IS NULL
734: UNION ALL
735: --The fourth part of the UNION handles Supplier Invoices (expenditure_type_class='VI').
736: --The join to per_all_people_f is not required as pa_expenditures_all.incurred_by_person_id
737: --is NULL for Supplier Invoices.
738: SELECT net_zero_adjustment_flag
739: FROM pa_expenditure_items_all ei,
740: pa_expenditures_all exp,

Line 740: pa_expenditures_all exp,

736: --The join to per_all_people_f is not required as pa_expenditures_all.incurred_by_person_id
737: --is NULL for Supplier Invoices.
738: SELECT net_zero_adjustment_flag
739: FROM pa_expenditure_items_all ei,
740: pa_expenditures_all exp,
741: pa_projects_all proj,
742: pa_tasks task,
743: hr_all_organization_units hr1
744: WHERE ei.transaction_source = x_transaction_source AND