APPS.PN_INDEX_LEASE_COMMON_PKG dependencies on PN_TERM_TEMPLATES_ALL

Line 785: FROM pn_index_leases_all pil, pn_term_templates_all ptt

781: SELECT 1
782: INTO l_template_used
783: FROM DUAL
784: WHERE EXISTS ( SELECT pil.index_lease_id
785: FROM pn_index_leases_all pil, pn_term_templates_all ptt
786: WHERE ptt.term_template_id = pil.term_template_id
787: AND ptt.term_template_id = p_term_template_id);
788: RETURN l_template_used;
789: EXCEPTION

Line 953: FROM pn_term_templates_all

949: l_term_template VARCHAR2 (100);
950: BEGIN
951: SELECT name
952: INTO l_term_template
953: FROM pn_term_templates_all
954: WHERE term_template_id = p_term_template_id;
955: RETURN l_term_template;
956: EXCEPTION
957: WHEN OTHERS