APPS.PN_EXP_TO_AR dependencies on PN_PAYMENT_ITEMS_ALL

Line 1697: UPDATE PN_PAYMENT_ITEMS_ALL

1693: l_context := 'Updating Payment Items';
1694: pnp_debug_pkg.log('Updating payment items for payment item id : ' ||
1695: to_char(exp_ar_tbl(l_grp).pn_payment_item_id) );
1696:
1697: UPDATE PN_PAYMENT_ITEMS_ALL
1698: SET transferred_to_ar_flag = 'Y' ,
1699: ar_ref_code = exp_ar_tbl(l_grp).pn_payment_item_id,
1700: last_updated_by = l_last_updated_by,
1701: last_update_login = l_last_update_login,

Line 1788: from pn_payment_items_all

1784:
1785: FOR i IN 1..l_index_2-1
1786: LOOP
1787: select actual_amount into l_actual_amount
1788: from pn_payment_items_all
1789: where payment_item_id=err_ar_tbl(i).pn_payment_item_id;
1790:
1791: fnd_message.set_name ('PN','PN_LEASE_NUMBER');
1792: l_message := fnd_message.get || ' ' || err_ar_tbl(i).pn_lease_num || ' ';

Line 1969: v_pn_payment_term_id1 PN_PAYMENT_ITEMS_ALL.payment_term_id%TYPE;

1965: l_derive_date_flag RA_BATCH_SOURCES.derive_date_flag%TYPE;
1966: l_rule_start_date RA_INTERFACE_LINES.rule_start_date%TYPE := NULL;
1967: l_rows_nogrp INTEGER;
1968: l_count_nogrp INTEGER;
1969: v_pn_payment_term_id1 PN_PAYMENT_ITEMS_ALL.payment_term_id%TYPE;
1970: v_pn_le_id1 PN_PAYMENT_TERMS_ALL.legal_entity_id%TYPE;
1971: v_pn_customer_id1 PN_PAYMENT_ITEMS_ALL.customer_id%TYPE;
1972: v_pn_trx_type_id1 PN_PAYMENT_TERMS.cust_trx_type_id%TYPE;
1973: v_pn_org_id1 PN_PAYMENT_TERMS_ALL.org_id%TYPE;

Line 1971: v_pn_customer_id1 PN_PAYMENT_ITEMS_ALL.customer_id%TYPE;

1967: l_rows_nogrp INTEGER;
1968: l_count_nogrp INTEGER;
1969: v_pn_payment_term_id1 PN_PAYMENT_ITEMS_ALL.payment_term_id%TYPE;
1970: v_pn_le_id1 PN_PAYMENT_TERMS_ALL.legal_entity_id%TYPE;
1971: v_pn_customer_id1 PN_PAYMENT_ITEMS_ALL.customer_id%TYPE;
1972: v_pn_trx_type_id1 PN_PAYMENT_TERMS.cust_trx_type_id%TYPE;
1973: v_pn_org_id1 PN_PAYMENT_TERMS_ALL.org_id%TYPE;
1974: v_schedule_date PN_PAYMENT_SCHEDULES_ALL.schedule_date%TYPE;
1975:

Line 2799: UPDATE PN_PAYMENT_ITEMS_ALL

2795: l_context := 'Updating Payment Items';
2796: pnp_debug_pkg.log('Updating payment items for payment item id : ' ||
2797: to_char(v_pn_payment_item_id) );
2798:
2799: UPDATE PN_PAYMENT_ITEMS_ALL
2800: SET transferred_to_ar_flag = 'Y' ,
2801: ar_ref_code = v_pn_payment_item_id,
2802: last_updated_by = l_last_updated_by,
2803: last_update_login = l_last_update_login,

Line 2900: from pn_payment_items_all

2896:
2897: FOR i IN 1..l_index_2-1
2898: LOOP
2899: select actual_amount into l_actual_amount
2900: from pn_payment_items_all
2901: where payment_item_id=err_ar_tbl(i).pn_payment_item_id;
2902:
2903: fnd_message.set_name ('PN','PN_LEASE_NUMBER');
2904: l_message := fnd_message.get || ' ' || err_ar_tbl(i).pn_lease_num || ' ';