APPS.PN_OPEX_TERMS_PKG dependencies on PN_TERM_TEMPLATES_ALL

Line 47: FROM pn_term_templates_all

43:
44: CURSOR term_template_cur (term_temp_id IN NUMBER)
45: IS
46: SELECT *
47: FROM pn_term_templates_all
48: WHERE term_template_id = term_temp_id;
49:
50: CURSOR agreement_cur(agr_id IN NUMBER)
51: IS

Line 78: template_rec pn_term_templates_all%ROWTYPE;

74: (SELECT MAX(payment_term_id) FROM pn_payment_terms_all
75: WHERE opex_agr_id = arg_id
76: AND opex_type = 'ESTPMT');
77:
78: template_rec pn_term_templates_all%ROWTYPE;
79: opex_est_pay_rec opex_est_pay_cur%ROWTYPE;
80: agreement_rec agreement_cur%ROWTYPE;
81: distributions_rec distributions_cur%ROWTYPE;
82: pay_term_rec prev_pay_term_cur%ROWTYPE;

Line 647: FROM pn_term_templates_all

643:
644: CURSOR term_template_cur (term_temp_id IN NUMBER)
645: IS
646: SELECT *
647: FROM pn_term_templates_all
648: WHERE term_template_id = term_temp_id;
649:
650: CURSOR agreement_cur(agr_id IN NUMBER)
651: IS

Line 678: template_rec pn_term_templates_all%ROWTYPE;

674: WHERE opex_agr_id = arg_id
675: AND opex_type = 'ESTPMT');
676:
677:
678: template_rec pn_term_templates_all%ROWTYPE;
679: agreement_rec agreement_cur%ROWTYPE;
680: distributions_rec distributions_cur%ROWTYPE;
681: pay_term_rec prev_pay_term_cur%ROWTYPE;
682: