APPS.OTA_LST_BUS dependencies on OTA_LP_SECTIONS

Line 33: ,ota_lp_sections lpc

29: cursor csr_sec_grp is
30: select pbg.security_group_id,
31: pbg.legislation_code
32: from per_business_groups_perf pbg
33: ,ota_lp_sections lpc
34: where lpc.learning_path_section_id = p_learning_path_section_id
35: and pbg.business_group_id = lpc.business_group_id;
36: --
37: -- Declare local variables

Line 106: ,ota_lp_sections lpc

102: -- Modified for Bug# 4310348
103: cursor csr_leg_code is
104: select pbg.legislation_code
105: from per_business_groups_perf pbg
106: ,ota_lp_sections lpc
107: where lpc.learning_path_section_id = p_learning_path_section_id
108: and pbg.business_group_id = lpc.business_group_id;
109: --
110: -- Declare local variables

Line 227: ,p_learning_path_section_id in ota_lp_sections.learning_path_section_id%TYPE

223: -- ----------------------------------------------------------------------------
224: Procedure insert_validate
225: (p_effective_date in date
226: ,p_rec in ota_lst_shd.g_rec_type
227: ,p_learning_path_section_id in ota_lp_sections.learning_path_section_id%TYPE
228: ) is
229: --
230: l_proc varchar2(72) := g_package||'insert_validate';
231: --