APPS.OKE_FUNDING_PUB dependencies on PA_AGREEMENTS_ALL

Line 130: from pa_agreements_all

126: ) is
127:
128: cursor c_agreement(x_length number) is
129: select 'x'
130: from pa_agreements_all
131: where agreement_id = p_agreement_id
132: and pm_product_code = G_PRODUCT_CODE
133: and substr(pm_agreement_reference, -1 * x_length, x_length) = '-'|| p_funding_source_id;
134:

Line 667: from pa_agreements_all where pm_product_code = 'OKE'

663: l_agreement_exist VARCHAR2(1);
664:
665: cursor get_term is
666: select term_id
667: from pa_agreements_all where pm_product_code = 'OKE'
668: and pm_agreement_reference LIKE '%-' || to_char(p_funding_in_rec.funding_source_id);
669:
670: l_receivables_term_id number;
671: BEGIN