1759:
1760: /* Cursor to check if bank details are attached with ppm */
1761: CURSOR csr_chk_bank(p_ppm_id NUMBER) IS
1762: SELECT ppm.external_account_id
1763: FROM pay_personal_payment_methods_f ppm
1764: WHERE ppm.personal_payment_method_id = p_ppm_id
1765: AND p_date_earned BETWEEN ppm.effective_start_date
1766: AND ppm.effective_end_date;
1767:
1807: ppttl.payment_type_name pay_type,
1808: ppp.value value
1809: FROM pay_external_accounts pea,
1810: pay_org_payment_methods_f pop,
1811: pay_personal_payment_methods_f ppm,
1812: pay_assignment_actions paa,
1813: pay_payment_types ppt,
1814: pay_payment_types_tl ppttl,
1815: pay_pre_payments ppp