APPS.PA_TRANSACTIONS_PUB dependencies on PER_ALL_PEOPLE_F

Line 666: per_all_people_f per,

662: --Usages (USG) and Supplier Invoices (VI).
663: SELECT net_zero_adjustment_flag
664: FROM pa_expenditure_items_all ei,
665: pa_expenditures_all exp,
666: per_all_people_f per,
667: pa_projects_all proj,
668: pa_tasks task,
669: hr_all_organization_units hr1
670: WHERE ei.transaction_source = x_transaction_source AND

Line 709: per_all_people_f per,

705: --hr_all_organization_units hr2 is required.
706: SELECT net_zero_adjustment_flag
707: FROM pa_expenditure_items_all ei,
708: pa_expenditures_all exp,
709: per_all_people_f per,
710: pa_projects_all proj,
711: pa_tasks task,
712: hr_all_organization_units hr1,
713: hr_all_organization_units hr2

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

748: x_employee_number IS NOT NULL
749: UNION ALL
750: --The third part of the UNION handles Usages (expenditure_type_class='USG')
751: --when IN PARAMETER x_exployee_number IS NULL. The additional join to
752: --hr_all_organization_units hr2 is required and the join to per_all_people_f is not required.
753: SELECT net_zero_adjustment_flag
754: FROM pa_expenditure_items_all ei,
755: pa_expenditures_all exp,
756: pa_projects_all proj,

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

790: x_expenditure_type_class = 'USG' AND
791: x_employee_number IS NULL
792: UNION ALL
793: --The fourth part of the UNION handles Supplier Invoices (expenditure_type_class='VI').
794: --The join to per_all_people_f is not required as pa_expenditures_all.incurred_by_person_id
795: --is NULL for Supplier Invoices.
796: SELECT net_zero_adjustment_flag
797: FROM pa_expenditure_items_all ei,
798: pa_expenditures_all exp,