APPS.PN_EXP_TO_AR dependencies on PN_LEASE_DETAILS

Line 89: FROM pn_lease_details_all

85: WHERE set_of_books_id = p_set_of_books_id;
86:
87: CURSOR get_send_flag(p_lease_id NUMBER) IS
88: SELECT nvl(send_entries,'Y')
89: FROM pn_lease_details_all
90: WHERE lease_id = p_lease_id;
91:
92: CURSOR get_opt_attr IS
93: SELECT gb.COLUMN_ID

Line 245: PN_LEASE_DETAILS_ALL pld, HZ_CUST_SITE_USES_ALL hzc,

241: ,''MM/DD/YYYY'') as rule_gl_date,
242: ps.schedule_date as schedule_date
243: FROM PN_PAYMENT_ITEMS pi, PN_PAYMENT_SCHEDULES_ALL ps,
244: PN_PAYMENT_TERMS_ALL pt, PN_LEASES_ALL le,
245: PN_LEASE_DETAILS_ALL pld, HZ_CUST_SITE_USES_ALL hzc,
246: HZ_CUST_SITE_USES_ALL hzc1, HZ_PARTIES party,
247: HZ_CUST_ACCOUNTS_ALL cust_acc, FND_LOOKUPS type_lookup,
248: FND_LOOKUPS purpose_lookup, HR_OPERATING_UNITS ou,
249: PN_DISTRIBUTIONS_ALL pd, RA_CUST_TRX_TYPES_ALL cust_trx,

Line 669: v_send_entries PN_LEASE_DETAILS.send_entries%TYPE;

665: v_normalize PN_PAYMENT_TERMS.normalize%TYPE;
666: v_pn_accounted_date PN_PAYMENT_ITEMS.accounted_date%TYPE;
667: v_pn_rate PN_PAYMENT_ITEMS.rate%TYPE;
668: v_location_id PN_LOCATIONS.LOCATION_ID%TYPE;
669: v_send_entries PN_LEASE_DETAILS.send_entries%TYPE;
670: v_rec_account PN_DISTRIBUTIONS.account_id%TYPE;
671: v_gl_date RA_CUST_TRX_LINE_GL_DIST.gl_date%TYPE;
672: v_conv_rate_type PN_CURRENCIES.conversion_type%TYPE;
673: v_conv_rate PN_PAYMENT_ITEMS.rate%TYPE;

Line 1960: l_send_flag PN_LEASE_DETAILS_ALL.send_entries%TYPE := 'Y';

1956: l_func_curr_code GL_SETS_OF_BOOKS.currency_code%TYPE;
1957: l_conv_rate_type PN_CURRENCIES.conversion_type%TYPE;
1958: l_conv_rate PN_PAYMENT_ITEMS.rate%TYPE;
1959: v_location_id PN_LOCATIONS.location_id%TYPE;
1960: l_send_flag PN_LEASE_DETAILS_ALL.send_entries%TYPE := 'Y';
1961: l_lease_id NUMBER := 0;
1962: v_pur_code PN_PAYMENT_TERMS.payment_purpose_code%TYPE;
1963: v_pur_type_code PN_PAYMENT_TERMS.payment_term_type_code%TYPE;
1964: l_post_to_gl RA_CUST_TRX_TYPES_ALL.post_to_gl%TYPE;