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 669: hr_all_organization_units hr1

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
671: ei.orig_transaction_reference = x_orig_transaction_reference AND
672: ei.system_linkage_function = x_expenditure_type_class AND
673: ei.expenditure_type = x_expenditure_type AND

Line 705: --hr_all_organization_units hr2 is required.

701: x_expenditure_type_class <> 'VI'
702: UNION ALL
703: --The second part of the UNION handles Usages (expenditure_type_class='USG')
704: --when IN parameter x_employee_number is NOT NULL. The additional join to
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,

Line 712: hr_all_organization_units hr1,

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
714: WHERE ei.transaction_source = x_transaction_source AND
715: ei.orig_transaction_reference = x_orig_transaction_reference AND
716: ei.system_linkage_function = x_expenditure_type_class AND

Line 713: hr_all_organization_units hr2

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
714: WHERE ei.transaction_source = x_transaction_source AND
715: ei.orig_transaction_reference = x_orig_transaction_reference AND
716: ei.system_linkage_function = x_expenditure_type_class AND
717: ei.expenditure_type = x_expenditure_type AND

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

754: FROM pa_expenditure_items_all ei,
755: pa_expenditures_all exp,
756: pa_projects_all proj,
757: pa_tasks task,
758: hr_all_organization_units hr1,
759: hr_all_organization_units hr2
760: WHERE ei.transaction_source = x_transaction_source AND
761: ei.orig_transaction_reference = x_orig_transaction_reference AND
762: ei.system_linkage_function = x_expenditure_type_class AND

Line 759: hr_all_organization_units hr2

755: pa_expenditures_all exp,
756: pa_projects_all proj,
757: pa_tasks task,
758: hr_all_organization_units hr1,
759: hr_all_organization_units hr2
760: WHERE ei.transaction_source = x_transaction_source AND
761: ei.orig_transaction_reference = x_orig_transaction_reference AND
762: ei.system_linkage_function = x_expenditure_type_class AND
763: ei.expenditure_type = x_expenditure_type AND

Line 801: hr_all_organization_units hr1

797: FROM pa_expenditure_items_all ei,
798: pa_expenditures_all exp,
799: pa_projects_all proj,
800: pa_tasks task,
801: hr_all_organization_units hr1
802: WHERE ei.transaction_source = x_transaction_source AND
803: ei.orig_transaction_reference = x_orig_transaction_reference AND
804: ei.system_linkage_function = x_expenditure_type_class AND
805: ei.expenditure_type = x_expenditure_type AND