DBA Data[Home] [Help]

APPS.PAY_PPMV4_SS dependencies on PAY_ORG_PAY_METHOD_USAGES_F

Line 777: , pay_org_pay_method_usages_f popmu

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

Line 802: , pay_org_pay_method_usages_f popmu

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

Line 1013: , pay_org_pay_method_usages_f popmu

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