APPS.PN_RETRO_ADJUSTMENT_PKG dependencies on PN_PAYMENT_TERMS_ALL

Line 31: p_payment_term_id pn_payment_terms_all.payment_term_id%TYPE,

27: p_end_date pn_payment_terms.end_date%TYPE,
28: p_sch_day pn_payment_terms.schedule_day%TYPE,
29: p_amount pn_payment_terms.actual_amount%TYPE,
30: p_term_freq pn_payment_terms.frequency_code%TYPE,
31: p_payment_term_id pn_payment_terms_all.payment_term_id%TYPE,
32: x_sched_tbl OUT NOCOPY payment_item_tbl_type
33: )
34: IS
35: l_current_end_date pn_payment_terms.end_date%TYPE;

Line 74: WHERE LEASE_ID = (select distinct lease_id from pn_payment_terms_all where payment_term_id = p_payment_term_id);

70:
71: SELECT cal_start
72: INTO l_cal_yr_st_dt
73: FROM PN_LEASES_ALL
74: WHERE LEASE_ID = (select distinct lease_id from pn_payment_terms_all where payment_term_id = p_payment_term_id);
75:
76:
77: IF l_cal_yr_st_dt IS NOT NULL THEN
78: l_yr_start_dt := to_date(l_cal_yr_st_dt || '-' || to_char(p_start_date,'YYYY'),'DD-MM-YYYY');

Line 1328: FROM pn_payment_terms_all

1324: currency_code,
1325: rate,
1326: estimated_amount,
1327: org_id
1328: FROM pn_payment_terms_all
1329: WHERE payment_term_id = p_term_id;
1330:
1331: l_new_itm_id_tbl item_id_tbl_type;
1332: l_payment_id_tbl item_id_tbl_type;

Line 1861: FROM pn_payment_terms_all

1857: currency_code,
1858: rate,
1859: estimated_amount,
1860: org_id
1861: FROM pn_payment_terms_all
1862: WHERE payment_term_id = p_term_id;
1863:
1864: l_vendor_id pn_payment_terms.vendor_id%TYPE;
1865: l_vendor_site_id pn_payment_terms.vendor_site_id%TYPE;