DBA Data[Home] [Help]

APPS.PAY_PPMV4_UTILS_SS dependencies on PAY_PERSONAL_PAYMENT_METHODS_F

Line 949: from pay_personal_payment_methods_f ppm

945: ,p_effective_date in date
946: ,p_run_type_id in number
947: ) is
948: select ppm.priority priority
949: from pay_personal_payment_methods_f ppm
950: , pay_org_payment_methods_f opm
951: where ppm.assignment_id = p_assignment_id
952: and nvl(ppm.run_type_id, hr_api.g_number) = nvl(p_run_type_id, hr_api.g_number)
953: and p_effective_date between

Line 1095: from pay_personal_payment_methods_f ppm

1091: (p_personal_payment_method_id in number
1092: ,p_effective_date in date
1093: ) is
1094: select ppm.business_group_id
1095: from pay_personal_payment_methods_f ppm
1096: where ppm.personal_payment_method_id = p_personal_payment_method_id
1097: and p_effective_date between
1098: ppm.effective_start_date and ppm.effective_end_date
1099: ;