DBA Data[Home] [Help]

APPS.PAY_PPMV4_SS dependencies on PAY_ORG_PAY_METHOD_USAGES_F

Line 846: , pay_org_pay_method_usages_f popmu

842: ) is
843: select opm.org_payment_method_id opmid
844: from pay_org_payment_methods_f opm
845: , per_all_assignments_f paa
846: , pay_org_pay_method_usages_f popmu
847: , pay_payment_types ppt
848: where paa.assignment_id = p_assignment_id
849: and p_effective_date between
850: paa.effective_start_date and paa.effective_end_date

Line 871: , pay_org_pay_method_usages_f popmu

867: ) is
868: select opm.org_payment_method_id opmid
869: from pay_org_payment_methods_f opm
870: , per_all_assignments_f paa
871: , pay_org_pay_method_usages_f popmu
872: , pay_payment_types ppt
873: where paa.assignment_id = p_assignment_id
874: and p_effective_date between
875: paa.effective_start_date and paa.effective_end_date

Line 1088: , pay_org_pay_method_usages_f popmu

1084: select opm.org_payment_method_name name
1085: , opm.org_payment_method_id opmid
1086: from pay_org_payment_methods_f opm
1087: , per_all_assignments_f paa
1088: , pay_org_pay_method_usages_f popmu
1089: , pay_payment_types ppt
1090: where paa.assignment_id = p_assignment_id
1091: and p_effective_date between
1092: paa.effective_start_date and paa.effective_end_date