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 HR_ALL_ORGANIZATION_UNITS

Line 611: hr_all_organization_units hr1

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
613: ei.orig_transaction_reference = x_orig_transaction_reference AND
614: ei.system_linkage_function = x_expenditure_type_class AND
615: ei.expenditure_type = x_expenditure_type AND

Line 647: --hr_all_organization_units hr2 is required.

643: x_expenditure_type_class <> 'VI'
644: UNION ALL
645: --The second part of the UNION handles Usages (expenditure_type_class='USG')
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,

Line 654: hr_all_organization_units hr1,

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
656: WHERE ei.transaction_source = x_transaction_source AND
657: ei.orig_transaction_reference = x_orig_transaction_reference AND
658: ei.system_linkage_function = x_expenditure_type_class AND

Line 655: hr_all_organization_units hr2

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
656: WHERE ei.transaction_source = x_transaction_source AND
657: ei.orig_transaction_reference = x_orig_transaction_reference AND
658: ei.system_linkage_function = x_expenditure_type_class AND
659: ei.expenditure_type = x_expenditure_type AND

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 700: hr_all_organization_units hr1,

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
702: WHERE ei.transaction_source = x_transaction_source AND
703: ei.orig_transaction_reference = x_orig_transaction_reference AND
704: ei.system_linkage_function = x_expenditure_type_class AND

Line 701: hr_all_organization_units hr2

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
702: WHERE ei.transaction_source = x_transaction_source AND
703: ei.orig_transaction_reference = x_orig_transaction_reference AND
704: ei.system_linkage_function = x_expenditure_type_class AND
705: ei.expenditure_type = x_expenditure_type AND

Line 743: hr_all_organization_units hr1

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
745: ei.orig_transaction_reference = x_orig_transaction_reference AND
746: ei.system_linkage_function = x_expenditure_type_class AND
747: ei.expenditure_type = x_expenditure_type AND