APPS.PN_EXP_TO_AR dependencies on PN_LEASE_DETAILS_ALL

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 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;