APPS.OTA_TPC_BUS dependencies on OTA_TRAINING_PLAN_COSTS

Line 21: (p_training_plan_cost_id in ota_training_plan_costs.training_plan_cost_id%TYPE

17: -- |----------------------< set_security_group_id >--------------------------|
18: -- ---------------------------------------------------------------------------
19: --
20: Procedure set_security_group_id
21: (p_training_plan_cost_id in ota_training_plan_costs.training_plan_cost_id%TYPE
22: ) is
23: --
24: -- Declare cursor
25: --

Line 30: ,ota_training_plan_costs tpc

26: --
27: cursor csr_sec_grp is
28: select inf.org_information14
29: from hr_organization_information inf
30: ,ota_training_plan_costs tpc
31: where tpc.training_plan_cost_id = p_training_plan_cost_id
32: and inf.organization_id = tpc.business_group_id
33: and inf.org_information_context || '' = 'Business Group Information';
34: --

Line 91: , ota_training_plan_costs tpc

87: --
88: cursor csr_leg_code is
89: select pbg.legislation_code
90: from per_business_groups pbg
91: , ota_training_plan_costs tpc
92: where tpc.training_plan_cost_id = p_training_plan_cost_id
93: and pbg.business_group_id = tpc.business_group_id;
94: --
95: -- Declare local variables

Line 438: ,p_descflex_name => 'OTA_TRAINING_PLAN_COSTS'

434: --
435: hr_utility.set_location(' Step :'|| l_proc,15);
436: hr_dflex_utility.ins_or_upd_descflex_attribs
437: (p_appl_short_name => 'OTA'
438: ,p_descflex_name => 'OTA_TRAINING_PLAN_COSTS'
439: ,p_attribute_category => p_rec.attribute_category
440: ,p_attribute1_name => 'ATTRIBUTE1'
441: ,p_attribute1_value => p_rec.attribute1
442: ,p_attribute2_name => 'ATTRIBUTE2'