DBA Data[Home] [Help]

APPS.PNP_UTIL_FUNC dependencies on PN_TERM_TEMPLATES_ALL

Line 6945: FROM pn_term_templates_all

6941: RETURN BOOLEAN IS
6942:
6943: CURSOR term_temp_type_cur(p_term_temp_id IN NUMBER) IS
6944: SELECT term_template_type
6945: FROM pn_term_templates_all
6946: WHERE term_template_id = p_term_temp_id;
6947:
6948: CURSOR term_temp_bill_cur(p_term_temp_id IN NUMBER) IS
6949: SELECT payment_purpose_code,

Line 6956: FROM pn_term_templates_all

6952: customer_id,
6953: customer_site_use_id,
6954: ap_ar_term_id,
6955: cust_trx_type_id
6956: FROM pn_term_templates_all
6957: WHERE term_template_id = p_term_temp_id;
6958:
6959: CURSOR term_temp_pay_cur(p_term_temp_id IN NUMBER) IS
6960: SELECT payment_purpose_code,

Line 6966: FROM pn_term_templates_all

6962: currency_code,
6963: ap_ar_term_id,
6964: vendor_id,
6965: vendor_site_id
6966: FROM pn_term_templates_all
6967: WHERE term_template_id = p_term_temp_id;
6968:
6969: BEGIN
6970:

Line 7045: FROM pn_term_templates_all

7041: BEGIN
7042:
7043: SELECT name
7044: INTO l_term_temp_name
7045: FROM pn_term_templates_all
7046: WHERE term_template_id = p_term_temp_id;
7047:
7048: RETURN(l_term_temp_name);
7049: