DBA Data[Home] [Help]

APPS.PN_SCHEDULES_ITEMS dependencies on PN_REC_AGREEMENTS_ALL

Line 6106: FROM pn_rec_agreements_all agr

6102: for term with changed dates */
6103: CURSOR get_agreements_cur(p_term_id IN NUMBER) IS
6104: SELECT agr.rec_agreement_name
6105: ,agr.rec_agreement_num
6106: FROM pn_rec_agreements_all agr
6107: ,pn_rec_agr_lines_all line
6108: ,pn_payment_terms_all term
6109: WHERE agr.lease_id = g_lease_id
6110: AND agr.rec_agreement_id = line.rec_agreement_id