DBA Data[Home] [Help]

APPS.PAY_PPMV4_UTILS_SS dependencies on PAY_PERSONAL_PAYMENT_METHODS_F

Line 1477: from pay_personal_payment_methods_f ppm

1473: ,p_effective_date in date
1474: ,p_run_type_id in number
1475: ) is
1476: select ppm.priority priority
1477: from pay_personal_payment_methods_f ppm
1478: , pay_org_payment_methods_f opm
1479: where ppm.assignment_id = p_assignment_id
1480: and nvl(ppm.run_type_id, hr_api.g_number) = nvl(p_run_type_id, hr_api.g_number)
1481: and p_effective_date between

Line 1654: from pay_personal_payment_methods_f ppm

1650: (p_personal_payment_method_id in number
1651: ,p_effective_date in date
1652: ) is
1653: select ppm.business_group_id
1654: from pay_personal_payment_methods_f ppm
1655: where ppm.personal_payment_method_id = p_personal_payment_method_id
1656: and p_effective_date between
1657: ppm.effective_start_date and ppm.effective_end_date
1658: ;