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 4136: FROM pn_term_templates_all ptt,

4132:
4133: CURSOR csr_template (p_rec_agreement_id IN NUMBER)
4134: IS
4135: SELECT ptt.*
4136: FROM pn_term_templates_all ptt,
4137: pn_rec_agreements_all prec
4138: WHERE ptt.term_template_id = prec.term_template_id
4139: AND prec.rec_agreement_id = p_rec_agreement_id;
4140:

Line 4144: FROM pn_term_templates_all ptt,

4140:
4141: CURSOR csr_template_upg (p_rec_agreement_id IN NUMBER)
4142: IS
4143: SELECT ptt.*
4144: FROM pn_term_templates_all ptt,
4145: pn_rec_agreements_all prec
4146: WHERE ptt.term_template_id = prec.term_template_id
4147: AND (ptt.tax_code_id IS NOT NULL OR ptt.tax_group_id IS NOT NULL)
4148: AND ptt.tax_classification_code IS NULL

Line 4152: rec_template pn_term_templates_all%ROWTYPE;

4148: AND ptt.tax_classification_code IS NULL
4149: AND prec.rec_agreement_id = p_rec_agreement_id;
4150:
4151:
4152: rec_template pn_term_templates_all%ROWTYPE;
4153:
4154: CURSOR csr_lease_term IS
4155: SELECT term.*
4156: FROM pn_payment_terms_all term