DBA Data[Home] [Help]

APPS.PN_GENERATE_PMT_SCHED dependencies on PN_LEASES_V

Line 86: pn_leases_v pn_leases /*sdm? shud form view be replaced*/

82: ppta.customer_site_use_id,
83: ppta.set_of_books_id,
84: ppta.currency_code
85: FROM pn_payment_terms_all ppta, /*sdm14jul*/
86: pn_leases_v pn_leases /*sdm? shud form view be replaced*/
87: WHERE ppta.lease_id = pn_leases.lease_id /*sdm14jul*/
88: AND ppta.lease_id = p_lease_id /*sdm14jul*/
89: AND not exists
90: ( SELECT 'x'

Line 126: FROM pn_leases_v pls, /*sdm should form view be replaced?*/

122: ppt.vendor_site_id,
123: ppt.customer_site_use_id,
124: ppt.set_of_books_id,
125: ppt.currency_code
126: FROM pn_leases_v pls, /*sdm should form view be replaced?*/
127: pn_payment_terms_all ppt /*sdm14jul*/
128: WHERE ppt.lease_id = pls.lease_id
129: AND ppt.lease_id = pn_lease_id
130: AND ppt.payment_term_id = p_paymentTermId