APPS.PNT_PAYMENT_SCHEDULES_PKG dependencies on PN_PAYMENT_SCHEDULES_ALL

Line 41: FROM pn_payment_schedules_all

37: IS
38:
39: CURSOR later_notin_draft IS
40: SELECT 'x'
41: FROM pn_payment_schedules_all
42: WHERE lease_id = x_lease_id
43: AND payment_status_lookup_code <> 'DRAFT'
44: AND schedule_date > x_schedule_date
45: AND to_char(schedule_date,'DD') = to_char(x_schedule_date,'DD');

Line 49: FROM pn_payment_schedules_all

45: AND to_char(schedule_date,'DD') = to_char(x_schedule_date,'DD');
46:
47: CURSOR prior_in_draft IS
48: SELECT 'x'
49: FROM pn_payment_schedules_all
50: WHERE lease_id = x_lease_id
51: AND payment_status_lookup_code = 'DRAFT'
52: AND schedule_date < x_schedule_date;
53:

Line 74: FROM pn_payment_schedules_all

70: SELECT 1
71: INTO dummy
72: FROM DUAL
73: WHERE NOT EXISTS (SELECT 1
74: FROM pn_payment_schedules_all
75: WHERE lease_id = x_lease_id
76: AND TO_CHAR(schedule_date,'YYYY-MON-DD') = TO_CHAR(x_schedule_date,'YYYY-MON-DD')
77: AND (( x_rowid IS NULL ) or (rowid <> x_rowid))
78: );

Line 186: FROM pn_payment_schedules_all

182: ) IS
183:
184: CURSOR next_schedule IS
185: SELECT payment_schedule_id
186: FROM pn_payment_schedules_all
187: WHERE lease_id = x_lease_id
188: AND schedule_date > x_schedule_date
189: AND payment_status_lookup_code = 'DRAFT'
190: ORDER BY schedule_date;

Line 318: FROM pn_payment_schedules_all

314: CURSOR on_hold_cur IS
315: SELECT 'A'
316: FROM DUAL
317: WHERE EXISTS (SELECT NULL
318: FROM pn_payment_schedules_all
319: WHERE lease_id = x_lease_id
320: AND schedule_date < x_schedule_date
321: AND on_hold = 'Y');
322:

Line 396: FROM pn_payment_schedules_all

392: AND currency_code <> p_functional_currency);
393:
394: CURSOR org_cur IS
395: SELECT org_id
396: FROM pn_payment_schedules_all
397: WHERE payment_schedule_id = p_payment_schedule_id;
398:
399: l_org_id NUMBER;
400:

Line 502: FROM pn_payment_schedules_all

498: x_org_id IN NUMBER
499: ) IS
500: CURSOR c IS
501: SELECT ROWID
502: FROM pn_payment_schedules_all
503: WHERE payment_schedule_id = x_payment_schedule_id;
504:
505: CURSOR org_cur IS
506: SELECT org_id FROM pn_leases_all WHERE lease_id = x_lease_id;

Line 528: INSERT INTO pn_payment_schedules_all

524: ELSE
525: l_org_id := x_org_id;
526: END IF;
527:
528: INSERT INTO pn_payment_schedules_all
529: (
530: PAYMENT_SCHEDULE_ID,
531: LAST_UPDATE_DATE,
532: LAST_UPDATED_BY,

Line 663: FROM pn_payment_schedules_all

659: IS
660:
661: CURSOR c1 IS
662: SELECT *
663: FROM pn_payment_schedules_all
664: WHERE payment_schedule_id = x_payment_schedule_id
665: FOR UPDATE OF payment_schedule_id NOWAIT;
666:
667: tlinfo c1%rowtype;

Line 854: UPDATE PN_PAYMENT_SCHEDULES_ALL

850: X_LAST_UPDATED_BY,
851: X_LAST_UPDATE_DATE,
852: X_LAST_UPDATE_LOGIN );
853:
854: UPDATE PN_PAYMENT_SCHEDULES_ALL
855: SET SCHEDULE_DATE = X_SCHEDULE_DATE,
856: APPROVED_BY_USER_ID = X_APPROVED_BY_USER_ID,
857: TRANSFERRED_BY_USER_ID = X_TRANSFERRED_BY_USER_ID,
858: PAYMENT_STATUS_LOOKUP_CODE = X_PAYMENT_STATUS_LOOKUP_CODE,

Line 932: DELETE FROM pn_payment_schedules_all

928: -------------------------------------------------------------------------------
929: PROCEDURE Delete_Row ( X_PAYMENT_SCHEDULE_ID IN NUMBER) IS
930: BEGIN
931:
932: DELETE FROM pn_payment_schedules_all
933: WHERE payment_schedule_id = x_payment_schedule_id;
934:
935: IF (SQL%NOTFOUND) THEN
936: RAISE NO_DATA_FOUND;

Line 1006: FROM pn_payment_schedules_all

1002: AND pi1.payment_item_id = l_item_id ;
1003:
1004: CURSOR org_cur IS
1005: SELECT org_id
1006: FROM pn_payment_schedules_all
1007: WHERE payment_schedule_id = p_pnt_sched_id;
1008:
1009: l_org_id NUMBER;
1010:

Line 1135: FROM pn_payment_schedules_all

1131: AND payment_item_type_lookup_code = 'CASH';
1132:
1133: CURSOR org_cur IS
1134: SELECT org_id
1135: FROM pn_payment_schedules_all
1136: WHERE payment_schedule_id = p_pnt_sched_id;
1137:
1138: l_org_id NUMBER;
1139: