APPS.OTA_FR_PLAN_DFORM dependencies on OTA_TRAINING_PLAN_MEMBERS

Line 62: from ota_training_plan_members tpm

58: where course.activity_version_id = course_tl.activity_version_id(+)
59: and course_tl.language(+) = userenv('LANG')
60: and exists
61: (select null
62: from ota_training_plan_members tpm
63: where tpm.training_plan_id = c_training_plan_id
64: and tpm.activity_version_id = course.activity_version_id
65: and tpm.member_status_type_id <> 'CANCELLED')
66: union

Line 77: from ota_training_plan_members tpm

73: where category.activity_id = category_tl.activity_id(+)
74: and category_tl.language(+) = userenv('LANG')
75: and exists
76: (select null
77: from ota_training_plan_members tpm
78: where tpm.training_plan_id = c_training_plan_id
79: and tpm.activity_definition_id = category.activity_id
80: and tpm.member_status_type_id <> 'CANCELLED');
81: --

Line 94: ota_training_plan_members tpm,

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'
98: and pb.business_group_id = tpm.business_group_id

Line 146: ota_training_plan_members tpm,

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'
150: and pb.business_group_id = tpm.business_group_id

Line 430: ota_training_plan_members tpm

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
434: and pb.budget_id = pbr.budget_id

Line 485: ota_training_plan_members tpm

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
489: and pb.budget_id = pbr.budget_id