[Home] [Help]
239: pn_mo_cache_utils.get_current_org_id)
240: , ''MM/DD/YYYY''))
241: ,''MM/DD/YYYY'') as rule_gl_date,
242: ps.schedule_date as schedule_date
243: FROM PN_PAYMENT_ITEMS pi, PN_PAYMENT_SCHEDULES_ALL ps,
244: PN_PAYMENT_TERMS_ALL pt, PN_LEASES_ALL le,
245: PN_LEASE_DETAILS_ALL pld, HZ_CUST_SITE_USES_ALL hzc,
246: HZ_CUST_SITE_USES_ALL hzc1, HZ_PARTIES party,
247: HZ_CUST_ACCOUNTS_ALL cust_acc, FND_LOOKUPS type_lookup,
293: PT.Location_id,
294: pt.payment_purpose_code as payment_purpose,
295: pt.payment_term_type_code as payment_type,
296: ps.schedule_date as schedule_date
297: FROM PN_PAYMENT_ITEMS pi, PN_PAYMENT_SCHEDULES_ALL ps,
298: PN_PAYMENT_TERMS_ALL pt, PN_LEASES_ALL le,
299: HZ_CUST_SITE_USES_ALL hzc, HZ_CUST_SITE_USES_ALL hzc1,
300: hz_parties party, hz_cust_accounts_ALL cust_acc,
301: fnd_lookups type_lookup, fnd_lookups purpose_lookup,
1722: pnp_debug_pkg.log('Updating payment schedules for payment sch id : ' ||
1723: to_char(exp_ar_tbl(l_grp).PN_Payment_Schedule_Id) );
1724:
1725:
1726: UPDATE PN_PAYMENT_SCHEDULES_ALL
1727: SET Transferred_By_User_Id = l_last_updated_by,
1728: Transfer_Date = l_last_update_date
1729: WHERE Payment_Schedule_Id = exp_ar_tbl(l_grp).PN_Payment_Schedule_Id;
1730:
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:
1976: l_rows_select_nogrp NUMBER;
1977: l_count_select_nogrp NUMBER;
1978: TYPE le_ar_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
2824:
2825: pnp_debug_pkg.log('Updating payment schedules for payment sch id : ' ||
2826: to_char(V_PN_Payment_Schedule_Id) );
2827:
2828: UPDATE PN_PAYMENT_SCHEDULES_ALL
2829: SET Transferred_By_User_Id = l_last_updated_by,
2830: Transfer_Date = l_last_update_date
2831: WHERE Payment_Schedule_Id = V_PN_Payment_Schedule_Id;
2832: