APPS.PN_INDEX_AMOUNT_PKG dependencies on PN_PAYMENT_ITEMS_ALL

Line 2546: pn_payment_items_all ppi

2542: ,ip_normalize IN VARCHAR2
2543: ,ip_index_period_id IN NUMBER)IS
2544: SELECT ppt.payment_term_id, ppt.actual_amount,ppt.frequency_code
2545: FROM pn_payment_terms_all ppt,
2546: pn_payment_items_all ppi
2547: WHERE ppt.index_period_id = ip_index_period_id
2548: AND ppt.status =c_payment_term_status_approved
2549: AND ppt.index_term_indicator = ip_index_term_indicator
2550: AND ppt.payment_purpose_code = ip_payment_purpose_code

Line 3206: FROM pn_payment_items_all item,

3202: ,p_distribution_string VARCHAR2
3203: ,p_normalize pn_payment_terms.normalize%TYPE
3204: ) IS
3205: SELECT sum(item.actual_amount) sum_overlap_amt
3206: FROM pn_payment_items_all item,
3207: pn_payment_terms_all term
3208: WHERE item.payment_term_id = term.payment_term_id
3209: AND item.due_date BETWEEN p_assessment_date AND p_end_date
3210: AND term.index_period_id = p_index_period_id

Line 4200: FROM pn_payment_items_all item,

4196: p_overlap_amt OUT NOCOPY NUMBER)
4197: IS
4198: CURSOR get_overlap_sum IS
4199: SELECT sum(item.actual_amount) sum_overlap_amt
4200: FROM pn_payment_items_all item,
4201: pn_payment_terms_all term
4202: WHERE item.payment_term_id = term.payment_term_id
4203: AND term.term_template_id = p_term_template_id
4204: AND term.index_period_id = p_index_period_id