APPS.PN_CREATE_ACC dependencies on PN_PAYMENT_SCHEDULES_ALL

Line 27: PN_PAYMENT_SCHEDULES_ALL ps

23: FROM PN_PAYMENT_TERMS pt,
24: PN_LEASES_ALL le ,
25: PN_PAYMENT_ITEMS_ALL pi,
26: PN_PAYMENT_ITEMS_ALL pi1,
27: PN_PAYMENT_SCHEDULES_ALL ps
28: WHERE pt.lease_id = le.lease_id
29: AND le.lease_class_code in ('THIRD_PARTY','SUB_LEASE')
30: AND LE.LEASE_ID BETWEEN P_LOW_LEASE_ID AND P_HIGH_LEASE_ID
31: AND ps.lease_id = le.lease_id

Line 66: PN_PAYMENT_SCHEDULES_ALL ps

62: FROM PN_PAYMENT_TERMS pt,
63: PN_LEASES_ALL le ,
64: PN_PAYMENT_ITEMS_ALL pi,
65: PN_PAYMENT_ITEMS_ALL pi1,
66: PN_PAYMENT_SCHEDULES_ALL ps
67: WHERE pt.lease_id = le.lease_id
68: AND le.lease_class_code in ('THIRD_PARTY','SUB_LEASE')
69: AND LE.LEASE_ID BETWEEN P_LOW_LEASE_ID AND P_HIGH_LEASE_ID
70: AND ps.lease_id = le.lease_id

Line 111: pn_payment_schedules_all ps

107: FROM pn_payment_terms pt,
108: pn_leases_all le ,
109: pn_payment_items_all pi,
110: pn_payment_items_all pi1,
111: pn_payment_schedules_all ps
112: WHERE pt.lease_id = le.lease_id
113: AND le.lease_class_code = 'DIRECT'
114: and LE.LEASE_ID BETWEEN P_LOW_LEASE_ID AND P_HIGH_LEASE_ID
115: and ps.lease_id = le.lease_id

Line 151: pn_payment_schedules_all ps

147: FROM pn_payment_terms pt,
148: pn_leases_all le ,
149: pn_payment_items_all pi,
150: pn_payment_items_all pi1,
151: pn_payment_schedules_all ps
152: WHERE pt.lease_id = le.lease_id
153: AND le.lease_class_code = 'DIRECT'
154: AND LE.LEASE_ID BETWEEN P_LOW_LEASE_ID AND P_HIGH_LEASE_ID
155: AND ps.lease_id = le.lease_id

Line 218: TYPE schedule_id_tbl_typ IS TABLE OF pn_payment_schedules_all.payment_schedule_id%TYPE INDEX BY BINARY_INTEGER;

214: l_creation_date DATE;
215:
216: TYPE NUMBER_tbl_typ IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
217: TYPE item_id_tbl_typ IS TABLE OF pn_payment_items_all.payment_item_id%TYPE INDEX BY BINARY_INTEGER;
218: TYPE schedule_id_tbl_typ IS TABLE OF pn_payment_schedules_all.payment_schedule_id%TYPE INDEX BY BINARY_INTEGER;
219: TYPE event_id_tbl_typ IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
220:
221: term_ID_tbl NUMBER_tbl_typ;
222: LE_tbl NUMBER_tbl_typ;

Line 369: UPDATE PN_Payment_Schedules_all

365:
366: IF schedule_id_tbl.COUNT > 0 THEN
367:
368: FORALL i IN schedule_id_tbl.FIRST..schedule_id_tbl.LAST
369: UPDATE PN_Payment_Schedules_all
370: SET Transferred_By_User_Id = l_last_updated_by,
371: Transfer_Date = l_last_update_date,
372: last_updated_by = l_last_updated_by,
373: last_update_login = l_last_update_login,

Line 425: UPDATE PN_Payment_Schedules_all

421:
422: IF schedule_id_tbl.COUNT > 0 THEN
423:
424: FORALL i IN schedule_id_tbl.FIRST..schedule_id_tbl.LAST
425: UPDATE PN_Payment_Schedules_all
426: SET Transferred_By_User_Id = l_last_updated_by,
427: Transfer_Date = l_last_update_date,
428: last_updated_by = l_last_updated_by,
429: last_update_login = l_last_update_login,

Line 487: TYPE schedule_id_tbl_typ IS TABLE OF pn_payment_schedules_all.payment_schedule_id%TYPE INDEX BY BINARY_INTEGER;

483: l_sch_start_date pn_payment_schedules.schedule_date%TYPE;
484: l_sch_end_date pn_payment_schedules.schedule_date%TYPE;
485:
486: TYPE item_id_tbl_typ IS TABLE OF pn_payment_items_all.payment_item_id%TYPE INDEX BY BINARY_INTEGER;
487: TYPE schedule_id_tbl_typ IS TABLE OF pn_payment_schedules_all.payment_schedule_id%TYPE INDEX BY BINARY_INTEGER;
488: TYPE NUMBER_tbl_typ IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
489: TYPE event_id_tbl_typ IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
490:
491: term_ID_tbl NUMBER_tbl_typ;

Line 638: UPDATE PN_Payment_Schedules_all

634:
635: IF schedule_id_tbl.COUNT > 0 THEN
636:
637: FORALL i IN schedule_id_tbl.FIRST..schedule_id_tbl.LAST
638: UPDATE PN_Payment_Schedules_all
639: SET Transferred_By_User_Id = l_last_updated_by,
640: Transfer_Date = l_last_update_date,
641: last_updated_by = l_last_updated_by,
642: last_update_login = l_last_update_login,

Line 695: UPDATE PN_Payment_Schedules_all

691:
692: IF schedule_id_tbl.COUNT > 0 THEN
693:
694: FORALL i IN schedule_id_tbl.FIRST..schedule_id_tbl.LAST
695: UPDATE PN_Payment_Schedules_all
696: SET Transferred_By_User_Id = l_last_updated_by,
697: Transfer_Date = l_last_update_date,
698: last_updated_by = l_last_updated_by,
699: last_update_login = l_last_update_login,

Line 1170: PN_PAYMENT_SCHEDULES_ALL ps

1166: FROM PN_PAYMENT_TERMS pt,
1167: PN_LEASES_ALL le ,
1168: PN_PAYMENT_ITEMS_ALL pi,
1169: PN_PAYMENT_ITEMS_ALL pi1,
1170: PN_PAYMENT_SCHEDULES_ALL ps
1171: WHERE pt.lease_id = le.lease_id
1172: AND le.lease_class_code in ('THIRD_PARTY','SUB_LEASE')
1173: AND LE.LEASE_ID BETWEEN L_LOW_LEASE_ID AND L_HIGH_LEASE_ID
1174: AND ps.lease_id = le.lease_id

Line 1749: UPDATE PN_Payment_Schedules_all

1745: l_context := 'Updating Payment Schedules';
1746: pnp_debug_pkg.log('Updating billing schedules for billing sch id : ' ||
1747: to_char(V_PN_Payment_Schedule_Id) );
1748:
1749: UPDATE PN_Payment_Schedules_all
1750: SET Transferred_By_User_Id = l_last_updated_by,
1751: Transfer_Date = l_last_update_date,
1752: last_updated_by = l_last_updated_by,
1753: last_update_login = l_last_update_login,

Line 1923: pn_payment_schedules_all ps

1919: FROM pn_payment_terms pt,
1920: pn_leases_all le ,
1921: pn_payment_items_all pi,
1922: pn_payment_items_all pi1,
1923: pn_payment_schedules_all ps
1924: WHERE pt.lease_id = le.lease_id
1925: AND le.lease_class_code = 'DIRECT'
1926: and LE.LEASE_ID BETWEEN L_LOW_LEASE_ID AND L_HIGH_LEASE_ID
1927: and ps.lease_id = le.lease_id

Line 2510: UPDATE PN_Payment_Schedules_all

2506:
2507: pnp_debug_pkg.log('Updating Payment schedules for Payment sch id : ' ||
2508: to_char(V_PN_Payment_Schedule_Id) );
2509:
2510: UPDATE PN_Payment_Schedules_all
2511: SET Transferred_By_User_Id = l_last_updated_by,
2512: Transfer_Date = l_last_update_date,
2513: last_updated_by = l_last_updated_by,
2514: last_update_login = l_last_update_login,