APPS.PN_VARIABLE_TERM_PKG dependencies on PN_TERM_TEMPLATES_ALL

Line 712: FROM pn_term_templates_all

708:
709: CURSOR csr_template (p_var_rent_id IN NUMBER)
710: IS
711: SELECT *
712: FROM pn_term_templates_all
713: WHERE term_template_id = (SELECT term_template_id
714: FROM pn_var_rents_all
715: WHERE var_rent_id = p_var_rent_id);
716:

Line 722: rec_template pn_term_templates_all%ROWTYPE;

718: SELECT currency_code
719: FROM pn_var_rents_all
720: WHERE var_rent_id = p_var_rent_id;
721:
722: rec_template pn_term_templates_all%ROWTYPE;
723: term_count NUMBER := 0;
724: l_currency_code pn_var_rents_all.currency_code%TYPE;
725: --l_global_rec pn_mo_cache_utils.GlobalsRecord;
726: