APPS.PN_EXP_TO_AR dependencies on PN_PAYMENT_SCHEDULES_ALL

Line 243: FROM PN_PAYMENT_ITEMS pi, PN_PAYMENT_SCHEDULES_ALL ps,

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,

Line 296: FROM PN_PAYMENT_ITEMS pi, PN_PAYMENT_SCHEDULES_ALL ps,

292: PT.Location_id,
293: pt.payment_purpose_code as payment_purpose,
294: pt.payment_term_type_code as payment_type,
295: ps.schedule_date as schedule_date
296: FROM PN_PAYMENT_ITEMS pi, PN_PAYMENT_SCHEDULES_ALL ps,
297: PN_PAYMENT_TERMS_ALL pt, PN_LEASES_ALL le,
298: HZ_CUST_SITE_USES_ALL hzc, HZ_CUST_SITE_USES_ALL hzc1,
299: hz_parties party, hz_cust_accounts_ALL cust_acc,
300: fnd_lookups type_lookup, fnd_lookups purpose_lookup,

Line 1711: UPDATE PN_PAYMENT_SCHEDULES_ALL

1707: pnp_debug_pkg.log('Updating payment schedules for payment sch id : ' ||
1708: to_char(exp_ar_tbl(l_grp).PN_Payment_Schedule_Id) );
1709:
1710:
1711: UPDATE PN_PAYMENT_SCHEDULES_ALL
1712: SET Transferred_By_User_Id = l_last_updated_by,
1713: Transfer_Date = l_last_update_date
1714: WHERE Payment_Schedule_Id = exp_ar_tbl(l_grp).PN_Payment_Schedule_Id;
1715:

Line 1928: v_schedule_date PN_PAYMENT_SCHEDULES_ALL.schedule_date%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:
1930: l_rows_select_nogrp NUMBER;
1931: l_count_select_nogrp NUMBER;
1932: TYPE le_ar_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;

Line 2777: UPDATE PN_PAYMENT_SCHEDULES_ALL

2773:
2774: pnp_debug_pkg.log('Updating payment schedules for payment sch id : ' ||
2775: to_char(V_PN_Payment_Schedule_Id) );
2776:
2777: UPDATE PN_PAYMENT_SCHEDULES_ALL
2778: SET Transferred_By_User_Id = l_last_updated_by,
2779: Transfer_Date = l_last_update_date
2780: WHERE Payment_Schedule_Id = V_PN_Payment_Schedule_Id;
2781: