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 1065: FROM pn_payment_schedules_all

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

Line 1085: pn_payment_schedules_all sch

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

Line 1098: pn_payment_schedules_all sch

1094: SELECT
1095: pmt.lease_id,
1096: (TO_DATE((TO_CHAR(MAX(pmt.start_date),'dd') || '-' || to_char(max(sch.schedule_date) , 'mm-yyyy')),'dd-mm-yyyy')) as last_sch_date
1097: FROM pn_payment_terms_all pmt,
1098: pn_payment_schedules_all sch
1099: WHERE sch.payment_status_lookup_code = 'APPROVED'
1100: AND pmt.payment_term_id = c_pay_term_id
1101: AND sch.lease_id = c_lease_id
1102: AND pmt.lease_id = c_lease_id

Line 1204: -- 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

1200:
1201:
1202:
1203:
1204: -- 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
1205:
1206: l_sch_id := NULL;
1207: FOR sch_rec in pay_sch_cur(p_lease_id , prev_trm_end_date ) LOOP
1208:

Line 1218: DELETE FROM pn_payment_schedules_all

1214: WHERE payment_term_id = prev_pay_term_id
1215: AND payment_schedule_id = l_sch_id
1216: AND payment_item_type_lookup_code = 'CASH';
1217:
1218: DELETE FROM pn_payment_schedules_all
1219: WHERE NOT EXISTS (SELECT NULL
1220: FROM pn_payment_items_all
1221: WHERE payment_schedule_id = l_sch_id)
1222: AND payment_schedule_id = l_sch_id;

Line 1312: pn_payment_schedules_all sch,

1308:
1309: CURSOR schedule_end_date_cur IS
1310: 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
1311: FROM pn_payment_terms_all pmt,
1312: pn_payment_schedules_all sch,
1313: pn_opex_est_payments_all est
1314: WHERE pmt.payment_term_id = est.payment_term_id
1315: AND est.est_payment_id = p_payment_term_id
1316: AND sch.payment_status_lookup_code = 'APPROVED'

Line 1337: pn_payment_schedules_all sch

1333: pmt.lease_id,
1334: ADD_MONTHS(TO_DATE((TO_CHAR(MAX(pmt.start_date),'dd') || '-' || to_char(max(sch.schedule_date) , 'mm-yyyy')),'dd-mm-yyyy'),
1335: DECODE(max(pmt.frequency_code),'MON', 0, 'QTR', 2, 'SA', 5 , 'YR', 11)) as last_sch_date
1336: FROM pn_payment_terms_all pmt,
1337: pn_payment_schedules_all sch
1338: WHERE sch.payment_status_lookup_code = 'APPROVED'
1339: AND pmt.payment_term_id = c_pay_term_id
1340: AND sch.lease_id = c_lease_id
1341: AND pmt.lease_id = c_lease_id

Line 1417: pn_payment_schedules_all sch

1413:
1414: CURSOR schedule_end_date_cur IS
1415: 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
1416: FROM pn_payment_terms_all pmt,
1417: pn_payment_schedules_all sch
1418: WHERE pmt.payment_term_id = p_payment_term_id
1419: AND sch.payment_status_lookup_code = 'APPROVED'
1420: AND sch.lease_id = p_lease_id;
1421: