APPS.HR_AE_VALIDATE_PKG dependencies on PAY_PERSONAL_PAYMENT_METHODS_F

Line 1295: FROM PAY_PERSONAL_PAYMENT_METHODS_F

1291: /* Check if more than one personal payment method does not have "EOS" flag as Yes */
1292:
1293: SELECT count(*)
1294: INTO l_count
1295: FROM PAY_PERSONAL_PAYMENT_METHODS_F
1296: WHERE ASSIGNMENT_ID = P_ASSIGNMENT_ID
1297: /* AND ORG_PAYMENT_METHOD_ID = P_ORG_PAYMENT_METHOD_ID */
1298: AND P_EFFECTIVE_DATE BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE
1299: AND PPM_INFORMATION_CATEGORY = 'AE_AE DIRECT DEPOSIT AED'

Line 1329: FROM PAY_PERSONAL_PAYMENT_METHODS_F

1325: l_count := 0;
1326:
1327: SELECT ASSIGNMENT_ID
1328: INTO l_assignment_id
1329: FROM PAY_PERSONAL_PAYMENT_METHODS_F
1330: WHERE PERSONAL_PAYMENT_METHOD_ID = P_PERSONAL_PAYMENT_METHOD_ID
1331: AND P_EFFECTIVE_DATE BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE;
1332:
1333: IF NVL(P_PPM_INFORMATION1,'N') = 'Y' THEN

Line 1338: FROM PAY_PERSONAL_PAYMENT_METHODS_F

1334: /* Check if more than one personal payment method does not have "EOS" flag as Yes */
1335:
1336: SELECT COUNT(*)
1337: INTO l_count
1338: FROM PAY_PERSONAL_PAYMENT_METHODS_F
1339: WHERE ASSIGNMENT_ID = l_assignment_id
1340: AND PERSONAL_PAYMENT_METHOD_ID <> P_PERSONAL_PAYMENT_METHOD_ID
1341: AND P_EFFECTIVE_DATE BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE
1342: AND PPM_INFORMATION_CATEGORY = 'AE_AE DIRECT DEPOSIT AED'