773: ) is
774: select opm.org_payment_method_id opmid
775: from pay_org_payment_methods_f opm
776: , per_all_assignments_f paa
777: , pay_org_pay_method_usages_f popmu
778: , pay_payment_types ppt
779: where paa.assignment_id = p_assignment_id
780: and p_effective_date between
781: paa.effective_start_date and paa.effective_end_date
798: ) is
799: select opm.org_payment_method_id opmid
800: from pay_org_payment_methods_f opm
801: , per_all_assignments_f paa
802: , pay_org_pay_method_usages_f popmu
803: , pay_payment_types ppt
804: where paa.assignment_id = p_assignment_id
805: and p_effective_date between
806: paa.effective_start_date and paa.effective_end_date
1009: select opm.org_payment_method_name name
1010: , opm.org_payment_method_id opmid
1011: from pay_org_payment_methods_f opm
1012: , per_all_assignments_f paa
1013: , pay_org_pay_method_usages_f popmu
1014: , pay_payment_types ppt
1015: where paa.assignment_id = p_assignment_id
1016: and p_effective_date between
1017: paa.effective_start_date and paa.effective_end_date