APPS.PAY_PAYMENT_METHODS_PKG dependencies on PAY_PERSONAL_PAYMENT_METHODS_F

Line 78: FROM PAY_PERSONAL_PAYMENT_METHODS_F

74: ) IS
75:
76: CURSOR C IS
77: SELECT ROWID
78: FROM PAY_PERSONAL_PAYMENT_METHODS_F
79: WHERE PERSONAL_PAYMENT_METHOD_ID = P_PERSONAL_PAYMENT_METHOD_ID;
80:
81: CURSOR C2 IS
82: SELECT pay_personal_payment_methods_s.nextval

Line 91: INSERT INTO PAY_PERSONAL_PAYMENT_METHODS_F (PERSONAL_PAYMENT_METHOD_ID,

87: OPEN C2;
88: FETCH C2 INTO P_PERSONAL_PAYMENT_METHOD_ID;
89: CLOSE C2;
90:
91: INSERT INTO PAY_PERSONAL_PAYMENT_METHODS_F (PERSONAL_PAYMENT_METHOD_ID,
92: EFFECTIVE_START_DATE,
93: EFFECTIVE_END_DATE,
94: BUSINESS_GROUP_ID,
95: EXTERNAL_ACCOUNT_ID,

Line 283: UPDATE PAY_PERSONAL_PAYMENT_METHODS_F

279: P_PPM_INFORMATION30 VARCHAR2
280: ) IS
281:
282: BEGIN
283: UPDATE PAY_PERSONAL_PAYMENT_METHODS_F
284: SET PERSONAL_PAYMENT_METHOD_ID = P_PERSONAL_PAYMENT_METHOD_ID,
285: EFFECTIVE_START_DATE = P_EFFECTIVE_START_DATE,
286: EFFECTIVE_END_DATE = P_EFFECTIVE_END_DATE,
287: BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID,

Line 420: DELETE FROM PAY_PERSONAL_PAYMENT_METHODS_F

416: --
417: l_after_this_date := fnd_date.date_to_canonical(p_after_this_date);
418: --
419: IF hr_payments.check_pp (to_char (P_PPM_ID), l_after_this_date) THEN
420: DELETE FROM PAY_PERSONAL_PAYMENT_METHODS_F
421: WHERE ROWID = P_ROWID;
422: ELSE
423: hr_utility.set_message('801', 'HR_6498_PAY_DEL_PREPAY');
424: hr_utility.raise_error;

Line 498: FROM PAY_PERSONAL_PAYMENT_METHODS_F

494: P_PPM_INFORMATION28 VARCHAR2,
495: P_PPM_INFORMATION29 VARCHAR2,
496: P_PPM_INFORMATION30 VARCHAR2 ) IS
497: CURSOR C IS SELECT *
498: FROM PAY_PERSONAL_PAYMENT_METHODS_F
499: WHERE ROWID = P_ROWID
500: FOR UPDATE OF PERSONAL_PAYMENT_METHOD_ID NOWAIT;
501:
502: CURSOR PRENOTE IS SELECT *