APPS.PN_INDEX_LEASE_COMMON_PKG dependencies on PN_INDEX_AMOUNT_PKG

Line 92: pn_index_amount_pkg.c_index_pay_term_type_recur

88: AND ppt.index_period_id > l_zero_period
89: AND ( p_chk_index_ind = 'Y'
90: AND ppt.index_term_indicator IN
91: (
92: pn_index_amount_pkg.c_index_pay_term_type_recur
93: ,pn_index_amount_pkg.c_index_pay_term_type_backbill)
94: OR NVL (p_chk_index_ind, 'N') = 'N'));
95: ELSE
96: SELECT '1'

Line 93: ,pn_index_amount_pkg.c_index_pay_term_type_backbill)

89: AND ( p_chk_index_ind = 'Y'
90: AND ppt.index_term_indicator IN
91: (
92: pn_index_amount_pkg.c_index_pay_term_type_recur
93: ,pn_index_amount_pkg.c_index_pay_term_type_backbill)
94: OR NVL (p_chk_index_ind, 'N') = 'N'));
95: ELSE
96: SELECT '1'
97: INTO v

Line 107: pn_index_amount_pkg.c_index_pay_term_type_recur

103: AND ppt.status = 'APPROVED'
104: AND ( p_chk_index_ind = 'Y'
105: AND ppt.index_term_indicator IN
106: (
107: pn_index_amount_pkg.c_index_pay_term_type_recur
108: ,pn_index_amount_pkg.c_index_pay_term_type_backbill)
109: OR NVL (p_chk_index_ind, 'N') = 'N'));
110: END IF; --p_index_lease_period_id is null
111: EXCEPTION

Line 108: ,pn_index_amount_pkg.c_index_pay_term_type_backbill)

104: AND ( p_chk_index_ind = 'Y'
105: AND ppt.index_term_indicator IN
106: (
107: pn_index_amount_pkg.c_index_pay_term_type_recur
108: ,pn_index_amount_pkg.c_index_pay_term_type_backbill)
109: OR NVL (p_chk_index_ind, 'N') = 'N'));
110: END IF; --p_index_lease_period_id is null
111: EXCEPTION
112: WHEN NO_DATA_FOUND

Line 224: IF (rec_payment_term.lease_class_code = pn_index_amount_pkg.c_lease_class_direct) THEN

220: -- checking if any of required fields for a direct lease is missing
221: -- if any field is missing, returning message
222: --
223:
224: IF (rec_payment_term.lease_class_code = pn_index_amount_pkg.c_lease_class_direct) THEN
225: IF ( rec_payment_term.payment_term_id IS NULL
226: OR rec_payment_term.payment_purpose_code IS NULL
227: OR rec_payment_term.payment_term_type_code IS NULL
228: OR rec_payment_term.frequency_code IS NULL