DBA Data[Home] [Help]

APPS.PN_INDEX_RENT_UTILS dependencies on PN_PAYMENT_TERMS_ALL

Line 786: ,pn_payment_terms_all TERMS

782: CURSOR c_lookup
783: IS
784: SELECT DISTINCT LOOK.lookup_code lookup_code
785: FROM fnd_lookups LOOK
786: ,pn_payment_terms_all TERMS
787: WHERE LOOK.lookup_type = 'PN_PAYMENT_TERM_TYPE'
788: AND LOOK.enabled_flag = 'Y'
789: AND TERMS.lease_id = p_lease_id
790: AND DECODE(TERMS.index_period_id,NULL,'APPROVED',TERMS.status)='APPROVED'

Line 800: ,pn_payment_terms_all TERMS

796: CURSOR c_lookup_code
797: IS
798: SELECT DISTINCT LOOK.lookup_code lookup_code
799: FROM fnd_lookups LOOK
800: ,pn_payment_terms_all TERMS
801: WHERE LOOK.lookup_type = 'PN_PAYMENT_TERM_TYPE'
802: AND LOOK.enabled_flag = 'Y'
803: AND TERMS.lease_id = p_lease_id
804: AND DECODE(TERMS.index_period_id,NULL,'APPROVED',TERMS.status)='APPROVED'