APPS.PN_MODIFY_PMT_SCHED dependencies on PN_PAYMENT_TERMS_ALL

Line 33: FROM pn_payment_terms_all /*sdm14jul*/

29: frequency_code,
30: lease_id,
31: set_of_books_id,
32: currency_code
33: FROM pn_payment_terms_all /*sdm14jul*/
34: WHERE lease_id = p_lease_id
35: FOR UPDATE OF end_date;
36:
37: pt_rec pt_cur%ROWTYPE;

Line 125: delete from pn_payment_terms_all /*sdm14jul*/

121: delete from pn_lease_milestones
122: where payment_term_id = pt_rec.payment_term_id
123: and RESPONSIBILITY_LOOKUP_CODE = 'PAYMENT_TERM';*/
124:
125: delete from pn_payment_terms_all /*sdm14jul*/
126: where current of pt_cur;
127:
128: ELSE IF ((pt_rec.end_date > lease_end_date) or (items_paid <> 0)) THEN
129:

Line 220: update pn_payment_terms_all /*sdm14jul*/

216: );
217:
218: IF (lease_end_date) > (pt_rec.start_date) THEN
219:
220: update pn_payment_terms_all /*sdm14jul*/
221: set end_date = lease_end_date,
222: last_update_date = sysdate,
223: last_updated_by = pn_user_id
224: where payment_term_id = pt_rec.payment_term_id;

Line 238: update pn_payment_terms_all /*sdm14jul*/

234: or description like 'Security Deposit refund due');*/
235:
236: ELSE
237:
238: update pn_payment_terms_all /*sdm14jul*/
239: set end_date = pt_rec.start_date,
240: last_update_date = sysdate,
241: last_updated_by = pn_user_id
242: where payment_term_id = pt_rec.payment_term_id;

Line 535: FROM pn_payment_terms_all

531: if nvl(amount,0) <> 0 then
532:
533: /*sdm14jul*/
534: SELECT org_id INTO l_org_id
535: FROM pn_payment_terms_all
536: WHERE payment_term_id = pt_rec.payment_term_id;
537:
538: INSERT INTO pn_payment_items_all /*sdm14jul*/
539: (