APPS.OTA_TPM_BUS dependencies on OTA_TRAINING_PLAN_MEMBERS

Line 30: ,ota_training_plan_members tpm

26: --
27: CURSOR csr_sec_grp IS
28: SELECT inf.org_information14
29: FROM hr_organization_information inf
30: ,ota_training_plan_members tpm
31: WHERE tpm.training_plan_member_id = p_training_plan_member_id
32: AND inf.organization_id = tpm.business_group_id
33: AND inf.org_information_context || '' = 'Business Group Information';
34:

Line 97: , ota_training_plan_members ota

93: --
94: CURSOR csr_leg_code IS
95: SELECT pbg.legislation_code
96: FROM per_business_groups pbg
97: , ota_training_plan_members ota
98: WHERE ota.training_plan_member_id = p_training_plan_member_id
99: AND pbg.business_group_id = ota.business_group_id;
100: --
101: -- Declare local variables

Line 265: ,p_descflex_name => 'OTA_TRAINING_PLAN_MEMBERS'

261: -- b) During insert.
262: --
263: hr_dflex_utility.ins_or_upd_descflex_attribs
264: (p_appl_short_name => 'OTA'
265: ,p_descflex_name => 'OTA_TRAINING_PLAN_MEMBERS'
266: ,p_attribute_category => p_rec.attribute_category
267: ,p_attribute1_name => 'ATTRIBUTE1'
268: ,p_attribute1_value => p_rec.attribute1
269: ,p_attribute2_name => 'ATTRIBUTE2'