APPS.PN_OPEX_TERMS_PKG dependencies on PN_PAYMENT_SCHEDULES_ALL

Line 31: l_payment_status_lookup_code pn_payment_schedules_all.payment_status_lookup_code%type;

27: l_area pn_payment_terms_all.area%TYPE;
28: l_area_type_code pn_payment_terms_all.area_type_code%TYPE;
29: l_org_id NUMBER;
30: l_schedule_day_char VARCHAR2(8);
31: l_payment_status_lookup_code pn_payment_schedules_all.payment_status_lookup_code%type;
32: i_cnt number;
33: l_est_payment_term_id pn_payment_terms_all.payment_term_id%TYPE;
34: l_catch_up_payment_term_id pn_payment_terms_all.payment_term_id%TYPE;
35: l_currency_code pn_payment_terms_all.currency_code%TYPE;

Line 632: l_payment_status_lookup_code pn_payment_schedules_all.payment_status_lookup_code%type;

628: l_area pn_payment_terms_all.area%TYPE;
629: l_area_type_code pn_payment_terms_all.area_type_code%TYPE;
630: l_org_id NUMBER;
631: l_schedule_day_char VARCHAR2(8);
632: l_payment_status_lookup_code pn_payment_schedules_all.payment_status_lookup_code%type;
633: i_cnt number;
634: l_payment_term_id pn_payment_terms_all.payment_term_id%TYPE;
635: l_currency_code pn_payment_terms_all.currency_code%TYPE;
636:

Line 1061: FROM pn_payment_schedules_all

1057: WHERE est_payment_id = est_pay_trm_id;
1058:
1059: CURSOR pay_sch_cur(p1_lease_id IN NUMBER , pl_contract_sch_date IN DATE) IS
1060: SELECT payment_schedule_id
1061: FROM pn_payment_schedules_all
1062: WHERE lease_id = p1_lease_id
1063: and payment_status_lookup_code = 'DRAFT'
1064: AND schedule_date >= pl_contract_sch_date;
1065:

Line 1080: pn_payment_schedules_all sch

1076: pmt.lease_id,
1077: ADD_MONTHS(TO_DATE((TO_CHAR(MAX(pmt.start_date),'dd') || '-' || to_char(max(sch.schedule_date) , 'mm-yyyy')),'dd-mm-yyyy'),
1078: DECODE(max(pmt.frequency_code),'MON', 0, 'QTR', 2, 'SA', 5 , 'YR', 11)) as last_sch_date
1079: FROM pn_payment_terms_all pmt,
1080: pn_payment_schedules_all sch
1081: WHERE sch.payment_status_lookup_code = 'APPROVED'
1082: AND pmt.payment_term_id = c_pay_term_id
1083: AND sch.lease_id = c_lease_id
1084: AND pmt.lease_id = c_lease_id

Line 1093: pn_payment_schedules_all sch

1089: SELECT
1090: pmt.lease_id,
1091: (TO_DATE((TO_CHAR(MAX(pmt.start_date),'dd') || '-' || to_char(max(sch.schedule_date) , 'mm-yyyy')),'dd-mm-yyyy')) as last_sch_date
1092: FROM pn_payment_terms_all pmt,
1093: pn_payment_schedules_all sch
1094: WHERE sch.payment_status_lookup_code = 'APPROVED'
1095: AND pmt.payment_term_id = c_pay_term_id
1096: AND sch.lease_id = c_lease_id
1097: AND pmt.lease_id = c_lease_id

Line 1192: -- Delete all schedules from pn_payment_schedules_all and payment_schedule id is not there in payment_items_all and schedule is in draft status

1188:
1189:
1190:
1191:
1192: -- Delete all schedules from pn_payment_schedules_all and payment_schedule id is not there in payment_items_all and schedule is in draft status
1193:
1194: l_sch_id := NULL;
1195: FOR sch_rec in pay_sch_cur(p_lease_id , prev_trm_end_date ) LOOP
1196:

Line 1206: DELETE FROM pn_payment_schedules_all

1202: WHERE payment_term_id = prev_pay_term_id
1203: AND payment_schedule_id = l_sch_id
1204: AND payment_item_type_lookup_code = 'CASH';
1205:
1206: DELETE FROM pn_payment_schedules_all
1207: WHERE NOT EXISTS (SELECT NULL
1208: FROM pn_payment_items_all
1209: WHERE payment_schedule_id = l_sch_id)
1210: AND payment_schedule_id = l_sch_id;

Line 1283: pn_payment_schedules_all sch,

1279:
1280: CURSOR schedule_end_date_cur IS
1281: SELECT (to_date((substr(to_char(max(pmt.start_date),'dd-mm-yyyy'),1,2) || substr(to_char(max(sch.schedule_date),'dd-mm-yyyy'),3)), 'dd-mm-yyyy')) schedule_date
1282: FROM pn_payment_terms_all pmt,
1283: pn_payment_schedules_all sch,
1284: pn_opex_est_payments_all est
1285: WHERE pmt.payment_term_id = est.payment_term_id
1286: AND est.est_payment_id = p_payment_term_id
1287: AND sch.payment_status_lookup_code = 'APPROVED'

Line 1308: pn_payment_schedules_all sch

1304: pmt.lease_id,
1305: ADD_MONTHS(TO_DATE((TO_CHAR(MAX(pmt.start_date),'dd') || '-' || to_char(max(sch.schedule_date) , 'mm-yyyy')),'dd-mm-yyyy'),
1306: DECODE(max(pmt.frequency_code),'MON', 0, 'QTR', 2, 'SA', 5 , 'YR', 11)) as last_sch_date
1307: FROM pn_payment_terms_all pmt,
1308: pn_payment_schedules_all sch
1309: WHERE sch.payment_status_lookup_code = 'APPROVED'
1310: AND pmt.payment_term_id = c_pay_term_id
1311: AND sch.lease_id = c_lease_id
1312: AND pmt.lease_id = c_lease_id

Line 1388: pn_payment_schedules_all sch

1384:
1385: CURSOR schedule_end_date_cur IS
1386: SELECT (to_date((substr(to_char(max(pmt.start_date),'dd-mm-yyyy'),1,2) || substr(to_char(max(sch.schedule_date),'dd-mm-yyyy'),3)), 'dd-mm-yyyy')) schedule_date
1387: FROM pn_payment_terms_all pmt,
1388: pn_payment_schedules_all sch
1389: WHERE pmt.payment_term_id = p_payment_term_id
1390: AND sch.payment_status_lookup_code = 'APPROVED'
1391: AND sch.lease_id = p_lease_id;
1392: