APPS.PN_EXP_TO_AR dependencies on FND_LOOKUPS

Line 14: FROM fnd_lookups

10: WHERE payment_term_id = p_term_id;
11:
12: CURSOR get_desc (p_lookup_code varchar2) is
13: SELECT meaning
14: FROM fnd_lookups
15: WHERE lookup_type = 'PN_PAYMENT_PURPOSE_TYPE'
16: AND lookup_code = p_lookup_code;
17:
18: CURSOR get_rule_name (p_rule_id number) is

Line 247: HZ_CUST_ACCOUNTS_ALL cust_acc, FND_LOOKUPS type_lookup,

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,
250: RA_RULES rr
251: WHERE pi.payment_term_id = pt.payment_term_id

Line 248: FND_LOOKUPS purpose_lookup, HR_OPERATING_UNITS ou,

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,
250: RA_RULES rr
251: WHERE pi.payment_term_id = pt.payment_term_id
252: AND pi.payment_schedule_id = ps.payment_schedule_id

Line 301: fnd_lookups type_lookup, fnd_lookups purpose_lookup,

297: FROM PN_PAYMENT_ITEMS pi, PN_PAYMENT_SCHEDULES_ALL ps,
298: PN_PAYMENT_TERMS_ALL pt, PN_LEASES_ALL le,
299: HZ_CUST_SITE_USES_ALL hzc, HZ_CUST_SITE_USES_ALL hzc1,
300: hz_parties party, hz_cust_accounts_ALL cust_acc,
301: fnd_lookups type_lookup, fnd_lookups purpose_lookup,
302: hr_operating_units ou
303: WHERE pi.payment_term_id = pt.payment_term_id
304: AND pi.payment_schedule_id = ps.payment_schedule_id
305: AND pi.export_to_ar_flag = ''Y''