APPS.ASN_METHODOLOGY_PVT dependencies on ASO_SUP_TMPL_SECT_MAP

Line 35: FROM ASO_SUP_TMPL_SECT_MAP

31: WHERE sales_methodology_id = p_meth_id;
32:
33: CURSOR c_tmpl_sect_map(p_template_id NUMBER) IS
34: SELECT section_id, display_sequence
35: FROM ASO_SUP_TMPL_SECT_MAP
36: WHERE template_id = p_template_id;
37:
38: CURSOR c_next_meth_stage_instance_id IS
39: SELECT AS_METH_STAGE_INSTANCES_S.nextval

Line 64: FROM ASO_SUP_TMPL_SECT_MAP tempsec,

60: SELECT secomp.sect_comp_map_id
61: ,null
62: ,secomp.default_response_id
63: ,'N'
64: FROM ASO_SUP_TMPL_SECT_MAP tempsec,
65: ASO_SUP_SECT_COMP_MAP secomp
66: WHERE secomp.section_id = tempsec.SECTION_ID
67: AND tempsec.TEMPLATE_ID = p_template_id
68: AND secomp.default_response_id IS NOT NULL;