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_ELEMENTS

Line 93: per_budget_elements pbe,

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
96: where pb.unit = 'FR_DELEGATES_PER_CATEGORY'
97: and pb.budget_type_code = 'OTA_BUDGET'

Line 145: per_budget_elements pbe,

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
148: where pb.unit = 'FR_DELEGATES_PER_CATEGORY'
149: and pb.budget_type_code = 'OTA_BUDGET'

Line 429: per_budget_elements pbe,

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
432: and pb.budget_type_code = 'OTA_BUDGET'
433: and pb.business_group_id = tpm.business_group_id

Line 484: per_budget_elements pbe,

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'
487: and pb.budget_type_code = 'OTA_BUDGET'
488: and pb.business_group_id = tpm.business_group_id