[Home] [Help]
700:
701: CURSOR csr_distributions (p_var_rent_id IN NUMBER)
702: IS
703: SELECT *
704: FROM pn_distributions_all
705: WHERE term_template_id = (SELECT term_template_id
706: FROM pn_var_rents_all
707: WHERE var_rent_id = p_var_rent_id);
708:
1821:
1822: CURSOR csr_distributions
1823: IS
1824: SELECT *
1825: FROM pn_distributions_all
1826: WHERE payment_term_id = p_payment_term_id;
1827:
1828: CURSOR payment_term_cur
1829: IS