DBA Data[Home] [Help]

APPS.PN_R12_UTIL_PKG dependencies on PN_TERM_TEMPLATES_ALL

Line 634: FROM pn_term_templates_all

630: tax_code_id,
631: tax_group_id,
632: tax_classification_code,
633: term_template_type
634: FROM pn_term_templates_all
635: WHERE term_template_id = p_term_template_id;
636:
637: l_tcc pn_payment_terms.tax_classification_code%TYPE;
638:

Line 655: UPDATE pn_term_templates_all

651:
652: IF l_tcc IS NULL THEN
653: RETURN 'PN_NO_TCC_FOUND';
654: ELSE
655: UPDATE pn_term_templates_all
656: SET tax_classification_code = l_tcc,
657: tax_code_id = NULL,
658: tax_group_id = NULL
659: WHERE term_template_id = p_term_template_id;