DBA Data[Home] [Help]

APPS.PER_ZA_USER_HOOK_PKG dependencies on PAY_PERSONAL_PAYMENT_METHODS_F

Line 2037: from pay_personal_payment_methods_f

2033: IF hr_utility.chk_product_install('Oracle Human Resources', 'ZA') THEN
2034: if P_PPM_INFORMATION1 in ('Y','0','7') then
2035: select count(*)
2036: into l_count
2037: from pay_personal_payment_methods_f
2038: where assignment_id = P_ASSIGNMENT_ID
2039: and personal_payment_method_id <>P_PERSONAL_PAYMENT_METHOD_ID
2040: and effective_start_date <= P_EFFECTIVE_END_DATE and effective_end_date >= P_EFFECTIVE_START_DATE
2041: and PPM_INFORMATION_CATEGORY in ('ZA_ACB','ZA_CHEQUE','ZA_CREDIT TRANSFER','ZA_MANUAL PAYMENT')

Line 2069: from pay_personal_payment_methods_f

2065: l_count := 0;
2066: IF hr_utility.chk_product_install('Oracle Human Resources', 'ZA') THEN
2067: select assignment_id
2068: into l_assignment_id
2069: from pay_personal_payment_methods_f
2070: where personal_payment_method_id = P_PERSONAL_PAYMENT_METHOD_ID
2071: and P_EFFECTIVE_DATE between effective_start_date and effective_end_date;
2072:
2073: if P_PPM_INFORMATION1 in ('Y','0','7') then

Line 2076: from pay_personal_payment_methods_f

2072:
2073: if P_PPM_INFORMATION1 in ('Y','0','7') then
2074: select count(*)
2075: into l_count
2076: from pay_personal_payment_methods_f
2077: where assignment_id = l_assignment_id
2078: and personal_payment_method_id <>P_PERSONAL_PAYMENT_METHOD_ID
2079: and PPM_INFORMATION_CATEGORY in ('ZA_ACB','ZA_CHEQUE','ZA_CREDIT TRANSFER','ZA_MANUAL PAYMENT')
2080: and effective_start_date <= P_EFFECTIVE_END_DATE and effective_end_date >= P_EFFECTIVE_START_DATE