DBA Data[Home] [Help]

APPS.OTA_FR_PLAN_DFORM dependencies on PER_BUDGETS

Line 90: from per_budgets pb,

86: c_business_group_id number)IS
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,

Line 142: from per_budgets pb,

138: c_business_group_id number) IS
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,

Line 426: from per_budgets pb,

422: c_member_level varchar2,
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

Line 481: from per_budgets pb,

477: c_member_level varchar,
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