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.OTA_FR_PLAN_DFORM dependencies on PER_BUDGET_VERSIONS

Line 91: per_budget_versions pbr,

87: select sum(pbv.value) delg_number
88: ,ec.lookup_code emp_code
89: ,ec.meaning emp_catg
90: from per_budgets pb,
91: per_budget_versions pbr,
92: per_budget_values pbv,
93: per_budget_elements pbe,
94: ota_training_plan_members tpm,
95: hr_lookups ec

Line 143: per_budget_versions pbr,

139: select count(pbv.budget_information1) evt_delg_number
140: ,ec.lookup_code evt_emp_code
141: ,ec.meaning evt_emp_catg
142: from per_budgets pb,
143: per_budget_versions pbr,
144: per_budget_values pbv,
145: per_budget_elements pbe,
146: ota_training_plan_members tpm,
147: hr_lookups ec

Line 427: per_budget_versions pbr,

423: c_training_plan_id number,
424: c_business_group_id number) is
425: select sum(pbv.value) value
426: from per_budgets pb,
427: per_budget_versions pbr,
428: per_budget_values pbv,
429: per_budget_elements pbe,
430: ota_training_plan_members tpm
431: where pb.unit = c_measure_code

Line 482: per_budget_versions pbr,

478: c_member_id number,
479: c_business_group_id number) is
480: select sum(pbv.value)
481: from per_budgets pb,
482: per_budget_versions pbr,
483: per_budget_values pbv,
484: per_budget_elements pbe,
485: ota_training_plan_members tpm
486: where pb.unit = 'FR_DURATION_HOURS'