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_VALUES

Line 92: per_budget_values pbv,

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

Line 144: per_budget_values pbv,

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

Line 428: per_budget_values pbv,

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

Line 483: per_budget_values pbv,

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