APPS.PN_EXP_TO_AR dependencies on PN_PAYMENT_ITEMS_ALL

Line 1682: UPDATE PN_PAYMENT_ITEMS_ALL

1678: l_context := 'Updating Payment Items';
1679: pnp_debug_pkg.log('Updating payment items for payment item id : ' ||
1680: to_char(exp_ar_tbl(l_grp).pn_payment_item_id) );
1681:
1682: UPDATE PN_PAYMENT_ITEMS_ALL
1683: SET transferred_to_ar_flag = 'Y' ,
1684: ar_ref_code = exp_ar_tbl(l_grp).pn_payment_item_id,
1685: last_updated_by = l_last_updated_by,
1686: last_update_login = l_last_update_login,

Line 1923: v_pn_payment_term_id1 PN_PAYMENT_ITEMS_ALL.payment_term_id%TYPE;

1919: l_derive_date_flag RA_BATCH_SOURCES.derive_date_flag%TYPE;
1920: l_rule_start_date RA_INTERFACE_LINES.rule_start_date%TYPE := NULL;
1921: l_rows_nogrp INTEGER;
1922: l_count_nogrp INTEGER;
1923: v_pn_payment_term_id1 PN_PAYMENT_ITEMS_ALL.payment_term_id%TYPE;
1924: v_pn_le_id1 PN_PAYMENT_TERMS_ALL.legal_entity_id%TYPE;
1925: v_pn_customer_id1 PN_PAYMENT_ITEMS_ALL.customer_id%TYPE;
1926: v_pn_trx_type_id1 PN_PAYMENT_TERMS.cust_trx_type_id%TYPE;
1927: v_pn_org_id1 PN_PAYMENT_TERMS_ALL.org_id%TYPE;

Line 1925: v_pn_customer_id1 PN_PAYMENT_ITEMS_ALL.customer_id%TYPE;

1921: l_rows_nogrp INTEGER;
1922: l_count_nogrp INTEGER;
1923: v_pn_payment_term_id1 PN_PAYMENT_ITEMS_ALL.payment_term_id%TYPE;
1924: v_pn_le_id1 PN_PAYMENT_TERMS_ALL.legal_entity_id%TYPE;
1925: v_pn_customer_id1 PN_PAYMENT_ITEMS_ALL.customer_id%TYPE;
1926: v_pn_trx_type_id1 PN_PAYMENT_TERMS.cust_trx_type_id%TYPE;
1927: v_pn_org_id1 PN_PAYMENT_TERMS_ALL.org_id%TYPE;
1928: v_schedule_date PN_PAYMENT_SCHEDULES_ALL.schedule_date%TYPE;
1929:

Line 2748: UPDATE PN_PAYMENT_ITEMS_ALL

2744: l_context := 'Updating Payment Items';
2745: pnp_debug_pkg.log('Updating payment items for payment item id : ' ||
2746: to_char(v_pn_payment_item_id) );
2747:
2748: UPDATE PN_PAYMENT_ITEMS_ALL
2749: SET transferred_to_ar_flag = 'Y' ,
2750: ar_ref_code = v_pn_payment_item_id,
2751: last_updated_by = l_last_updated_by,
2752: last_update_login = l_last_update_login,