APPS.PNP_UTIL_FUNC dependencies on PN_TERM_TEMPLATES

Line 6784: FROM pn_term_templates_all

6780: RETURN BOOLEAN IS
6781:
6782: CURSOR term_temp_type_cur(p_term_temp_id IN NUMBER) IS
6783: SELECT term_template_type
6784: FROM pn_term_templates_all
6785: WHERE term_template_id = p_term_temp_id;
6786:
6787: CURSOR term_temp_bill_cur(p_term_temp_id IN NUMBER) IS
6788: SELECT payment_purpose_code,

Line 6795: FROM pn_term_templates_all

6791: customer_id,
6792: customer_site_use_id,
6793: ap_ar_term_id,
6794: cust_trx_type_id
6795: FROM pn_term_templates_all
6796: WHERE term_template_id = p_term_temp_id;
6797:
6798: CURSOR term_temp_pay_cur(p_term_temp_id IN NUMBER) IS
6799: SELECT payment_purpose_code,

Line 6805: FROM pn_term_templates_all

6801: currency_code,
6802: ap_ar_term_id,
6803: vendor_id,
6804: vendor_site_id
6805: FROM pn_term_templates_all
6806: WHERE term_template_id = p_term_temp_id;
6807:
6808: BEGIN
6809:

Line 6852: | FROM pn_term_templates.

6848: | get_term_template_name
6849: |
6850: | DESCRIPTION
6851: | This FUNCTION RETURNs Term Template Name for a given Term Template Id
6852: | FROM pn_term_templates.
6853: |
6854: | SCOPE - PUBLIC
6855: |
6856: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED

Line 6878: l_term_temp_name pn_term_templates.name%type;

6874: FUNCTION get_term_template_name (p_term_temp_id IN NUMBER)
6875:
6876: RETURN VARCHAR2 IS
6877:
6878: l_term_temp_name pn_term_templates.name%type;
6879:
6880: BEGIN
6881:
6882: SELECT name

Line 6884: FROM pn_term_templates_all

6880: BEGIN
6881:
6882: SELECT name
6883: INTO l_term_temp_name
6884: FROM pn_term_templates_all
6885: WHERE term_template_id = p_term_temp_id;
6886:
6887: RETURN(l_term_temp_name);
6888: