APPS.HR_AE_VALIDATE_PKG dependencies on PAY_PERSONAL_PAYMENT_METHODS_F

Line 1233: FROM PAY_PERSONAL_PAYMENT_METHODS_F

1229: /* Check if more than one personal payment method does not have "EOS" flag as Yes */
1230:
1231: SELECT count(*)
1232: INTO l_count
1233: FROM PAY_PERSONAL_PAYMENT_METHODS_F
1234: WHERE ASSIGNMENT_ID = P_ASSIGNMENT_ID
1235: /* AND ORG_PAYMENT_METHOD_ID = P_ORG_PAYMENT_METHOD_ID */
1236: AND P_EFFECTIVE_DATE BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE
1237: AND PPM_INFORMATION_CATEGORY = 'AE_AE DIRECT DEPOSIT AED'

Line 1267: FROM PAY_PERSONAL_PAYMENT_METHODS_F

1263: l_count := 0;
1264:
1265: SELECT ASSIGNMENT_ID
1266: INTO l_assignment_id
1267: FROM PAY_PERSONAL_PAYMENT_METHODS_F
1268: WHERE PERSONAL_PAYMENT_METHOD_ID = P_PERSONAL_PAYMENT_METHOD_ID
1269: AND P_EFFECTIVE_DATE BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE;
1270:
1271: IF NVL(P_PPM_INFORMATION1,'N') = 'Y' THEN

Line 1276: FROM PAY_PERSONAL_PAYMENT_METHODS_F

1272: /* Check if more than one personal payment method does not have "EOS" flag as Yes */
1273:
1274: SELECT COUNT(*)
1275: INTO l_count
1276: FROM PAY_PERSONAL_PAYMENT_METHODS_F
1277: WHERE ASSIGNMENT_ID = l_assignment_id
1278: AND PERSONAL_PAYMENT_METHOD_ID <> P_PERSONAL_PAYMENT_METHOD_ID
1279: AND P_EFFECTIVE_DATE BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE
1280: AND PPM_INFORMATION_CATEGORY = 'AE_AE DIRECT DEPOSIT AED'