APPS.OTA_TPS_BUS dependencies on OTA_TRAINING_PLANS

Line 21: (p_training_plan_id IN ota_training_plans.training_plan_id%TYPE

17: -- |----------------------< set_security_group_id >--------------------------|
18: -- ---------------------------------------------------------------------------
19: --
20: PROCEDURE set_security_group_id
21: (p_training_plan_id IN ota_training_plans.training_plan_id%TYPE
22: ,p_associated_column1 IN varchar2
23: ) IS
24: --
25: -- Declare cursor

Line 30: , ota_training_plans tps

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

Line 97: , ota_training_plans tps

93: --
94: CURSOR csr_leg_code IS
95: SELECT pbg.legislation_code
96: FROM per_business_groups pbg
97: , ota_training_plans tps
98: WHERE tps.training_plan_id = p_training_plan_id
99: AND pbg.business_group_id = tps.business_group_id;
100: --
101: -- Declare local variables

Line 265: ,p_descflex_name => 'OTA_TRAINING_PLANS'

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_PLANS'
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'