APPS.PN_CREATE_ACC dependencies on PN_PAYMENT_SCHEDULES_ALL

Line 31: PN_PAYMENT_SCHEDULES_ALL ps

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

Line 70: PN_PAYMENT_SCHEDULES_ALL ps

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

Line 118: pn_payment_schedules_all ps

114: FROM pn_payment_terms pt,
115: pn_leases_all le ,
116: pn_payment_items_all pi,
117: pn_payment_items_all pi1,
118: pn_payment_schedules_all ps
119: WHERE pt.lease_id = le.lease_id
120: AND le.lease_class_code = 'DIRECT'
121: and LE.LEASE_ID BETWEEN P_LOW_LEASE_ID AND P_HIGH_LEASE_ID
122: and ps.lease_id = le.lease_id

Line 158: pn_payment_schedules_all ps

154: FROM pn_payment_terms pt,
155: pn_leases_all le ,
156: pn_payment_items_all pi,
157: pn_payment_items_all pi1,
158: pn_payment_schedules_all ps
159: WHERE pt.lease_id = le.lease_id
160: AND le.lease_class_code = 'DIRECT'
161: AND LE.LEASE_ID BETWEEN P_LOW_LEASE_ID AND P_HIGH_LEASE_ID
162: AND ps.lease_id = le.lease_id

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

638: l_due_date DATE;
639:
640: TYPE NUMBER_tbl_typ IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
641: TYPE item_id_tbl_typ IS TABLE OF pn_payment_items_all.payment_item_id%TYPE INDEX BY BINARY_INTEGER;
642: TYPE schedule_id_tbl_typ IS TABLE OF pn_payment_schedules_all.payment_schedule_id%TYPE INDEX BY BINARY_INTEGER;
643: TYPE event_id_tbl_typ IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
644:
645: term_ID_tbl NUMBER_tbl_typ;
646: LE_tbl NUMBER_tbl_typ;

Line 814: UPDATE PN_Payment_Schedules_all

810:
811: IF schedule_id_tbl.COUNT > 0 THEN
812:
813: FORALL i IN schedule_id_tbl.FIRST..schedule_id_tbl.LAST
814: UPDATE PN_Payment_Schedules_all
815: SET Transferred_By_User_Id = l_last_updated_by,
816: Transfer_Date = l_last_update_date,
817: last_updated_by = l_last_updated_by,
818: last_update_login = l_last_update_login,

Line 871: UPDATE PN_Payment_Schedules_all

867:
868: IF schedule_id_tbl.COUNT > 0 THEN
869:
870: FORALL i IN schedule_id_tbl.FIRST..schedule_id_tbl.LAST
871: UPDATE PN_Payment_Schedules_all
872: SET Transferred_By_User_Id = l_last_updated_by,
873: Transfer_Date = l_last_update_date,
874: last_updated_by = l_last_updated_by,
875: last_update_login = l_last_update_login,

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

929: l_sch_start_date pn_payment_schedules.schedule_date%TYPE;
930: l_sch_end_date pn_payment_schedules.schedule_date%TYPE;
931:
932: TYPE item_id_tbl_typ IS TABLE OF pn_payment_items_all.payment_item_id%TYPE INDEX BY BINARY_INTEGER;
933: TYPE schedule_id_tbl_typ IS TABLE OF pn_payment_schedules_all.payment_schedule_id%TYPE INDEX BY BINARY_INTEGER;
934: TYPE NUMBER_tbl_typ IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
935: TYPE event_id_tbl_typ IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
936:
937: term_ID_tbl NUMBER_tbl_typ;

Line 1106: UPDATE PN_Payment_Schedules_all

1102:
1103: IF schedule_id_tbl.COUNT > 0 THEN
1104:
1105: FORALL i IN schedule_id_tbl.FIRST..schedule_id_tbl.LAST
1106: UPDATE PN_Payment_Schedules_all
1107: SET Transferred_By_User_Id = l_last_updated_by,
1108: Transfer_Date = l_last_update_date,
1109: last_updated_by = l_last_updated_by,
1110: last_update_login = l_last_update_login,

Line 1163: UPDATE PN_Payment_Schedules_all

1159:
1160: IF schedule_id_tbl.COUNT > 0 THEN
1161:
1162: FORALL i IN schedule_id_tbl.FIRST..schedule_id_tbl.LAST
1163: UPDATE PN_Payment_Schedules_all
1164: SET Transferred_By_User_Id = l_last_updated_by,
1165: Transfer_Date = l_last_update_date,
1166: last_updated_by = l_last_updated_by,
1167: last_update_login = l_last_update_login,

Line 1638: PN_PAYMENT_SCHEDULES_ALL ps

1634: FROM PN_PAYMENT_TERMS pt,
1635: PN_LEASES_ALL le ,
1636: PN_PAYMENT_ITEMS_ALL pi,
1637: PN_PAYMENT_ITEMS_ALL pi1,
1638: PN_PAYMENT_SCHEDULES_ALL ps
1639: WHERE pt.lease_id = le.lease_id
1640: AND le.lease_class_code in ('THIRD_PARTY','SUB_LEASE')
1641: AND LE.LEASE_ID BETWEEN L_LOW_LEASE_ID AND L_HIGH_LEASE_ID
1642: AND ps.lease_id = le.lease_id

Line 2217: UPDATE PN_Payment_Schedules_all

2213: l_context := 'Updating Payment Schedules';
2214: pnp_debug_pkg.log('Updating billing schedules for billing sch id : ' ||
2215: to_char(V_PN_Payment_Schedule_Id) );
2216:
2217: UPDATE PN_Payment_Schedules_all
2218: SET Transferred_By_User_Id = l_last_updated_by,
2219: Transfer_Date = l_last_update_date,
2220: last_updated_by = l_last_updated_by,
2221: last_update_login = l_last_update_login,

Line 2391: pn_payment_schedules_all ps

2387: FROM pn_payment_terms pt,
2388: pn_leases_all le ,
2389: pn_payment_items_all pi,
2390: pn_payment_items_all pi1,
2391: pn_payment_schedules_all ps
2392: WHERE pt.lease_id = le.lease_id
2393: AND le.lease_class_code = 'DIRECT'
2394: and LE.LEASE_ID BETWEEN L_LOW_LEASE_ID AND L_HIGH_LEASE_ID
2395: and ps.lease_id = le.lease_id

Line 2978: UPDATE PN_Payment_Schedules_all

2974:
2975: pnp_debug_pkg.log('Updating Payment schedules for Payment sch id : ' ||
2976: to_char(V_PN_Payment_Schedule_Id) );
2977:
2978: UPDATE PN_Payment_Schedules_all
2979: SET Transferred_By_User_Id = l_last_updated_by,
2980: Transfer_Date = l_last_update_date,
2981: last_updated_by = l_last_updated_by,
2982: last_update_login = l_last_update_login,