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