APPS.PA_TRANSACTIONS_PUB dependencies on PER_ALL_PEOPLE_F

Line 608: per_all_people_f per,

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
612: WHERE ei.transaction_source = x_transaction_source AND

Line 651: per_all_people_f per,

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,
655: hr_all_organization_units hr2

Line 694: --hr_all_organization_units hr2 is required and the join to per_all_people_f is not required.

690: x_employee_number IS NOT NULL
691: UNION ALL
692: --The third part of the UNION handles Usages (expenditure_type_class='USG')
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,

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,