APPS.PN_REC_CALC_PKG dependencies on PN_TERM_TEMPLATES_ALL

Line 44: TYPE template_name_tbl_type IS TABLE OF pn_term_templates_all.name%TYPE INDEX BY BINARY_INTEGER;

40: | 18-JUL-06 sdmahesh o Bug 5332426 Added handling for lazy upgrade
41: | of Term Templates for E-Tax
42: +===========================================================================*/
43:
44: TYPE template_name_tbl_type IS TABLE OF pn_term_templates_all.name%TYPE INDEX BY BINARY_INTEGER;
45: TYPE template_id_tbl_type IS TABLE OF pn_term_templates_all.term_template_id%TYPE INDEX BY BINARY_INTEGER;
46: template_name_tbl template_name_tbl_type;
47: template_id_tbl template_id_tbl_type;
48:

Line 45: TYPE template_id_tbl_type IS TABLE OF pn_term_templates_all.term_template_id%TYPE INDEX BY BINARY_INTEGER;

41: | of Term Templates for E-Tax
42: +===========================================================================*/
43:
44: TYPE template_name_tbl_type IS TABLE OF pn_term_templates_all.name%TYPE INDEX BY BINARY_INTEGER;
45: TYPE template_id_tbl_type IS TABLE OF pn_term_templates_all.term_template_id%TYPE INDEX BY BINARY_INTEGER;
46: template_name_tbl template_name_tbl_type;
47: template_id_tbl template_id_tbl_type;
48:
49: PROCEDURE CALCULATE_REC_AMOUNT_BATCH(

Line 4051: FROM pn_term_templates_all ptt,

4047:
4048: CURSOR csr_template (p_rec_agreement_id IN NUMBER)
4049: IS
4050: SELECT ptt.*
4051: FROM pn_term_templates_all ptt,
4052: pn_rec_agreements_all prec
4053: WHERE ptt.term_template_id = prec.term_template_id
4054: AND prec.rec_agreement_id = p_rec_agreement_id;
4055:

Line 4059: FROM pn_term_templates_all ptt,

4055:
4056: CURSOR csr_template_upg (p_rec_agreement_id IN NUMBER)
4057: IS
4058: SELECT ptt.*
4059: FROM pn_term_templates_all ptt,
4060: pn_rec_agreements_all prec
4061: WHERE ptt.term_template_id = prec.term_template_id
4062: AND (ptt.tax_code_id IS NOT NULL OR ptt.tax_group_id IS NOT NULL)
4063: AND ptt.tax_classification_code IS NULL

Line 4067: rec_template pn_term_templates_all%ROWTYPE;

4063: AND ptt.tax_classification_code IS NULL
4064: AND prec.rec_agreement_id = p_rec_agreement_id;
4065:
4066:
4067: rec_template pn_term_templates_all%ROWTYPE;
4068:
4069: CURSOR csr_lease_term IS
4070: SELECT term.*
4071: FROM pn_payment_terms_all term