The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE INSERT_ROW(P_ROWID IN OUT NOCOPY VARCHAR2,
P_PERSONAL_PAYMENT_METHOD_ID IN OUT NOCOPY NUMBER,
P_EFFECTIVE_START_DATE DATE,
P_EFFECTIVE_END_DATE DATE,
P_BUSINESS_GROUP_ID NUMBER,
P_EXTERNAL_ACCOUNT_ID NUMBER,
P_ASSIGNMENT_ID NUMBER,
P_PERSON_ID NUMBER,
P_RUN_TYPE_ID NUMBER,
P_ORG_PAYMENT_METHOD_ID NUMBER,
P_AMOUNT NUMBER,
P_COMMENT_ID NUMBER,
P_PERCENTAGE NUMBER,
P_PRIORITY NUMBER,
P_PAYEE_TYPE VARCHAR2,
P_PAYEE_ID NUMBER,
P_ATTRIBUTE_CATEGORY VARCHAR2,
P_ATTRIBUTE1 VARCHAR2,
P_ATTRIBUTE2 VARCHAR2,
P_ATTRIBUTE3 VARCHAR2,
P_ATTRIBUTE4 VARCHAR2,
P_ATTRIBUTE5 VARCHAR2,
P_ATTRIBUTE6 VARCHAR2,
P_ATTRIBUTE7 VARCHAR2,
P_ATTRIBUTE8 VARCHAR2,
P_ATTRIBUTE9 VARCHAR2,
P_ATTRIBUTE10 VARCHAR2,
P_ATTRIBUTE11 VARCHAR2,
P_ATTRIBUTE12 VARCHAR2,
P_ATTRIBUTE13 VARCHAR2,
P_ATTRIBUTE14 VARCHAR2,
P_ATTRIBUTE15 VARCHAR2,
P_ATTRIBUTE16 VARCHAR2,
P_ATTRIBUTE17 VARCHAR2,
P_ATTRIBUTE18 VARCHAR2,
P_ATTRIBUTE19 VARCHAR2,
P_ATTRIBUTE20 VARCHAR2,
P_PRENOTE_DATE DATE,
/** sbilling **/
P_TERRITORY_CODE VARCHAR2,
P_PPM_INFORMATION_CATEGORY VARCHAR2,
P_PPM_INFORMATION1 VARCHAR2,
P_PPM_INFORMATION2 VARCHAR2,
P_PPM_INFORMATION3 VARCHAR2,
P_PPM_INFORMATION4 VARCHAR2,
P_PPM_INFORMATION5 VARCHAR2,
P_PPM_INFORMATION6 VARCHAR2,
P_PPM_INFORMATION7 VARCHAR2,
P_PPM_INFORMATION8 VARCHAR2,
P_PPM_INFORMATION9 VARCHAR2,
P_PPM_INFORMATION10 VARCHAR2,
P_PPM_INFORMATION11 VARCHAR2,
P_PPM_INFORMATION12 VARCHAR2,
P_PPM_INFORMATION13 VARCHAR2,
P_PPM_INFORMATION14 VARCHAR2,
P_PPM_INFORMATION15 VARCHAR2,
P_PPM_INFORMATION16 VARCHAR2,
P_PPM_INFORMATION17 VARCHAR2,
P_PPM_INFORMATION18 VARCHAR2,
P_PPM_INFORMATION19 VARCHAR2,
P_PPM_INFORMATION20 VARCHAR2,
P_PPM_INFORMATION21 VARCHAR2,
P_PPM_INFORMATION22 VARCHAR2,
P_PPM_INFORMATION23 VARCHAR2,
P_PPM_INFORMATION24 VARCHAR2,
P_PPM_INFORMATION25 VARCHAR2,
P_PPM_INFORMATION26 VARCHAR2,
P_PPM_INFORMATION27 VARCHAR2,
P_PPM_INFORMATION28 VARCHAR2,
P_PPM_INFORMATION29 VARCHAR2,
P_PPM_INFORMATION30 VARCHAR2
) IS
CURSOR C IS
SELECT ROWID
FROM PAY_PERSONAL_PAYMENT_METHODS_F
WHERE PERSONAL_PAYMENT_METHOD_ID = P_PERSONAL_PAYMENT_METHOD_ID;
SELECT pay_personal_payment_methods_s.nextval
FROM sys.dual;
INSERT INTO PAY_PERSONAL_PAYMENT_METHODS_F (PERSONAL_PAYMENT_METHOD_ID,
EFFECTIVE_START_DATE,
EFFECTIVE_END_DATE,
BUSINESS_GROUP_ID,
EXTERNAL_ACCOUNT_ID,
ASSIGNMENT_ID,
PERSON_ID,
RUN_TYPE_ID,
ORG_PAYMENT_METHOD_ID,
AMOUNT,
COMMENT_ID,
PERCENTAGE,
PRIORITY,
PAYEE_TYPE,
PAYEE_ID,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
ATTRIBUTE16,
ATTRIBUTE17,
ATTRIBUTE18,
ATTRIBUTE19,
ATTRIBUTE20,
PPM_INFORMATION_CATEGORY,
PPM_INFORMATION1,
PPM_INFORMATION2,
PPM_INFORMATION3,
PPM_INFORMATION4,
PPM_INFORMATION5,
PPM_INFORMATION6,
PPM_INFORMATION7,
PPM_INFORMATION8,
PPM_INFORMATION9,
PPM_INFORMATION10,
PPM_INFORMATION11,
PPM_INFORMATION12,
PPM_INFORMATION13,
PPM_INFORMATION14,
PPM_INFORMATION15,
PPM_INFORMATION16,
PPM_INFORMATION17,
PPM_INFORMATION18,
PPM_INFORMATION19,
PPM_INFORMATION20,
PPM_INFORMATION21,
PPM_INFORMATION22,
PPM_INFORMATION23,
PPM_INFORMATION24,
PPM_INFORMATION25,
PPM_INFORMATION26,
PPM_INFORMATION27,
PPM_INFORMATION28,
PPM_INFORMATION29,
PPM_INFORMATION30)
VALUES(P_PERSONAL_PAYMENT_METHOD_ID,P_EFFECTIVE_START_DATE,
P_EFFECTIVE_END_DATE,P_BUSINESS_GROUP_ID,P_EXTERNAL_ACCOUNT_ID,
P_ASSIGNMENT_ID,P_PERSON_ID,P_RUN_TYPE_ID,P_ORG_PAYMENT_METHOD_ID,P_AMOUNT,P_COMMENT_ID,
P_PERCENTAGE,P_PRIORITY,P_PAYEE_TYPE,P_PAYEE_ID,
P_ATTRIBUTE_CATEGORY,P_ATTRIBUTE1,
P_ATTRIBUTE2,P_ATTRIBUTE3,P_ATTRIBUTE4, P_ATTRIBUTE5,P_ATTRIBUTE6,
P_ATTRIBUTE7,P_ATTRIBUTE8,P_ATTRIBUTE9,P_ATTRIBUTE10,P_ATTRIBUTE11,
P_ATTRIBUTE12,P_ATTRIBUTE13,P_ATTRIBUTE14,P_ATTRIBUTE15,P_ATTRIBUTE16,
P_ATTRIBUTE17,P_ATTRIBUTE18,P_ATTRIBUTE19,P_ATTRIBUTE20,
P_PPM_INFORMATION_CATEGORY,P_PPM_INFORMATION1,P_PPM_INFORMATION2,
P_PPM_INFORMATION3,P_PPM_INFORMATION4,P_PPM_INFORMATION5,P_PPM_INFORMATION6,
P_PPM_INFORMATION7,P_PPM_INFORMATION8,P_PPM_INFORMATION9,P_PPM_INFORMATION10,
P_PPM_INFORMATION11,P_PPM_INFORMATION12,P_PPM_INFORMATION13,P_PPM_INFORMATION14,
P_PPM_INFORMATION15,P_PPM_INFORMATION16,P_PPM_INFORMATION17,P_PPM_INFORMATION18,
P_PPM_INFORMATION19,P_PPM_INFORMATION20,P_PPM_INFORMATION21,P_PPM_INFORMATION22,
P_PPM_INFORMATION23,P_PPM_INFORMATION24,P_PPM_INFORMATION25,P_PPM_INFORMATION26,
P_PPM_INFORMATION27,P_PPM_INFORMATION28,P_PPM_INFORMATION29,P_PPM_INFORMATION30 );
hr_utility.set_message_token('PROCEDURE','Insert_row');
UPDATE PAY_EXTERNAL_ACCOUNTS
SET PRENOTE_DATE = P_PRENOTE_DATE
WHERE EXTERNAL_ACCOUNT_ID = P_EXTERNAL_ACCOUNT_ID;
UPDATE PAY_EXTERNAL_ACCOUNTS
SET TERRITORY_CODE = P_TERRITORY_CODE
WHERE EXTERNAL_ACCOUNT_ID = P_EXTERNAL_ACCOUNT_ID;
END INSERT_ROW;
PROCEDURE UPDATE_ROW(P_ROWID VARCHAR2,
P_PERSONAL_PAYMENT_METHOD_ID NUMBER,
P_EFFECTIVE_START_DATE DATE,
P_EFFECTIVE_END_DATE DATE,
P_BUSINESS_GROUP_ID NUMBER,
P_EXTERNAL_ACCOUNT_ID NUMBER,
P_ASSIGNMENT_ID NUMBER,
P_PERSON_ID NUMBER,
P_RUN_TYPE_ID NUMBER,
P_ORG_PAYMENT_METHOD_ID NUMBER,
P_AMOUNT NUMBER,
P_COMMENT_ID NUMBER,
P_PERCENTAGE NUMBER,
P_PRIORITY NUMBER,
P_PAYEE_TYPE VARCHAR2,
P_PAYEE_ID NUMBER,
P_ATTRIBUTE_CATEGORY VARCHAR2,
P_ATTRIBUTE1 VARCHAR2,
P_ATTRIBUTE2 VARCHAR2,
P_ATTRIBUTE3 VARCHAR2,
P_ATTRIBUTE4 VARCHAR2,
P_ATTRIBUTE5 VARCHAR2,
P_ATTRIBUTE6 VARCHAR2,
P_ATTRIBUTE7 VARCHAR2,
P_ATTRIBUTE8 VARCHAR2,
P_ATTRIBUTE9 VARCHAR2,
P_ATTRIBUTE10 VARCHAR2,
P_ATTRIBUTE11 VARCHAR2,
P_ATTRIBUTE12 VARCHAR2,
P_ATTRIBUTE13 VARCHAR2,
P_ATTRIBUTE14 VARCHAR2,
P_ATTRIBUTE15 VARCHAR2,
P_ATTRIBUTE16 VARCHAR2,
P_ATTRIBUTE17 VARCHAR2,
P_ATTRIBUTE18 VARCHAR2,
P_ATTRIBUTE19 VARCHAR2,
P_ATTRIBUTE20 VARCHAR2,
P_PRENOTE_DATE DATE,
/** sbilling **/
P_TERRITORY_CODE VARCHAR2,
P_PPM_INFORMATION_CATEGORY VARCHAR2,
P_PPM_INFORMATION1 VARCHAR2,
P_PPM_INFORMATION2 VARCHAR2,
P_PPM_INFORMATION3 VARCHAR2,
P_PPM_INFORMATION4 VARCHAR2,
P_PPM_INFORMATION5 VARCHAR2,
P_PPM_INFORMATION6 VARCHAR2,
P_PPM_INFORMATION7 VARCHAR2,
P_PPM_INFORMATION8 VARCHAR2,
P_PPM_INFORMATION9 VARCHAR2,
P_PPM_INFORMATION10 VARCHAR2,
P_PPM_INFORMATION11 VARCHAR2,
P_PPM_INFORMATION12 VARCHAR2,
P_PPM_INFORMATION13 VARCHAR2,
P_PPM_INFORMATION14 VARCHAR2,
P_PPM_INFORMATION15 VARCHAR2,
P_PPM_INFORMATION16 VARCHAR2,
P_PPM_INFORMATION17 VARCHAR2,
P_PPM_INFORMATION18 VARCHAR2,
P_PPM_INFORMATION19 VARCHAR2,
P_PPM_INFORMATION20 VARCHAR2,
P_PPM_INFORMATION21 VARCHAR2,
P_PPM_INFORMATION22 VARCHAR2,
P_PPM_INFORMATION23 VARCHAR2,
P_PPM_INFORMATION24 VARCHAR2,
P_PPM_INFORMATION25 VARCHAR2,
P_PPM_INFORMATION26 VARCHAR2,
P_PPM_INFORMATION27 VARCHAR2,
P_PPM_INFORMATION28 VARCHAR2,
P_PPM_INFORMATION29 VARCHAR2,
P_PPM_INFORMATION30 VARCHAR2
) IS
BEGIN
UPDATE PAY_PERSONAL_PAYMENT_METHODS_F
SET PERSONAL_PAYMENT_METHOD_ID = P_PERSONAL_PAYMENT_METHOD_ID,
EFFECTIVE_START_DATE = P_EFFECTIVE_START_DATE,
EFFECTIVE_END_DATE = P_EFFECTIVE_END_DATE,
BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID,
EXTERNAL_ACCOUNT_ID = P_EXTERNAL_ACCOUNT_ID,
ASSIGNMENT_ID = P_ASSIGNMENT_ID,
PERSON_ID = P_PERSON_ID,
RUN_TYPE_ID = P_RUN_TYPE_ID,
ORG_PAYMENT_METHOD_ID = P_ORG_PAYMENT_METHOD_ID,
AMOUNT = P_AMOUNT,
COMMENT_ID = P_COMMENT_ID,
PERCENTAGE = P_PERCENTAGE,
PRIORITY = P_PRIORITY,
PAYEE_TYPE = P_PAYEE_TYPE,
PAYEE_ID = P_PAYEE_ID,
ATTRIBUTE_CATEGORY = P_ATTRIBUTE_CATEGORY,
ATTRIBUTE1 = P_ATTRIBUTE1,
ATTRIBUTE2 = P_ATTRIBUTE2,
ATTRIBUTE3 = P_ATTRIBUTE3,
ATTRIBUTE4 = P_ATTRIBUTE4,
ATTRIBUTE5 = P_ATTRIBUTE5,
ATTRIBUTE6 = P_ATTRIBUTE6,
ATTRIBUTE7 = P_ATTRIBUTE7,
ATTRIBUTE8 = P_ATTRIBUTE8,
ATTRIBUTE9 = P_ATTRIBUTE9,
ATTRIBUTE10 = P_ATTRIBUTE10,
ATTRIBUTE11 = P_ATTRIBUTE11,
ATTRIBUTE12 = P_ATTRIBUTE12,
ATTRIBUTE13 = P_ATTRIBUTE13,
ATTRIBUTE14 = P_ATTRIBUTE14,
ATTRIBUTE15 = P_ATTRIBUTE15,
ATTRIBUTE16 = P_ATTRIBUTE16,
ATTRIBUTE17 = P_ATTRIBUTE17,
ATTRIBUTE18 = P_ATTRIBUTE18,
ATTRIBUTE19 = P_ATTRIBUTE19,
ATTRIBUTE20 = P_ATTRIBUTE20,
PPM_INFORMATION_CATEGORY = P_PPM_INFORMATION_CATEGORY,
PPM_INFORMATION1 = P_PPM_INFORMATION1,
PPM_INFORMATION2 = P_PPM_INFORMATION2,
PPM_INFORMATION3 = P_PPM_INFORMATION3,
PPM_INFORMATION4 = P_PPM_INFORMATION4,
PPM_INFORMATION5 = P_PPM_INFORMATION5,
PPM_INFORMATION6 = P_PPM_INFORMATION6,
PPM_INFORMATION7 = P_PPM_INFORMATION7,
PPM_INFORMATION8 = P_PPM_INFORMATION8,
PPM_INFORMATION9 = P_PPM_INFORMATION9,
PPM_INFORMATION10 = P_PPM_INFORMATION10,
PPM_INFORMATION11 = P_PPM_INFORMATION11,
PPM_INFORMATION12 = P_PPM_INFORMATION12,
PPM_INFORMATION13 = P_PPM_INFORMATION13,
PPM_INFORMATION14 = P_PPM_INFORMATION14,
PPM_INFORMATION15 = P_PPM_INFORMATION15,
PPM_INFORMATION16 = P_PPM_INFORMATION16,
PPM_INFORMATION17 = P_PPM_INFORMATION17,
PPM_INFORMATION18 = P_PPM_INFORMATION18,
PPM_INFORMATION19 = P_PPM_INFORMATION19,
PPM_INFORMATION20 = P_PPM_INFORMATION20,
PPM_INFORMATION21 = P_PPM_INFORMATION21,
PPM_INFORMATION22 = P_PPM_INFORMATION22,
PPM_INFORMATION23 = P_PPM_INFORMATION23,
PPM_INFORMATION24 = P_PPM_INFORMATION24,
PPM_INFORMATION25 = P_PPM_INFORMATION25,
PPM_INFORMATION26 = P_PPM_INFORMATION26,
PPM_INFORMATION27 = P_PPM_INFORMATION27,
PPM_INFORMATION28 = P_PPM_INFORMATION28,
PPM_INFORMATION29 = P_PPM_INFORMATION29,
PPM_INFORMATION30 = P_PPM_INFORMATION30
WHERE ROWID = P_ROWID;
UPDATE PAY_EXTERNAL_ACCOUNTS
SET PRENOTE_DATE = P_PRENOTE_DATE
WHERE EXTERNAL_ACCOUNT_ID = P_EXTERNAL_ACCOUNT_ID;
UPDATE PAY_EXTERNAL_ACCOUNTS
SET TERRITORY_CODE = P_TERRITORY_CODE
WHERE EXTERNAL_ACCOUNT_ID = P_EXTERNAL_ACCOUNT_ID;
END UPDATE_ROW;
PROCEDURE DELETE_ROW(P_ROWID VARCHAR2,
P_PPM_ID NUMBER,
P_AFTER_THIS_DATE DATE,
P_PAYEE_TYPE VARCHAR2) IS
--
CURSOR el_ent_check IS
SELECT 'el_ents_exist'
FROM pay_element_entries_f
WHERE personal_payment_method_id = p_ppm_id
AND effective_end_date > p_after_this_date;
DELETE FROM PAY_PERSONAL_PAYMENT_METHODS_F
WHERE ROWID = P_ROWID;
END DELETE_ROW;
CURSOR C IS SELECT *
FROM PAY_PERSONAL_PAYMENT_METHODS_F
WHERE ROWID = P_ROWID
FOR UPDATE OF PERSONAL_PAYMENT_METHOD_ID NOWAIT;
CURSOR PRENOTE IS SELECT *
FROM PAY_EXTERNAL_ACCOUNTS
WHERE EXTERNAL_ACCOUNT_ID = P_EXTERNAL_ACCOUNT_ID
FOR UPDATE OF PRENOTE_DATE NOWAIT;
/* Bug 14113683 : Commenting the check on person id as Person id can never be updated through Pay Method form.
So, no code is reqd to check if the person id is updated. Also we are passing the person id as null (hardcoded)
always from the form PAYWSEPM.fmb to this proc expecting the person id to be null in PAY_PERSONAL_PAYMENT_METHODS_F */
/* ( (P_PERSON_ID = RECINFO.PERSON_ID)
OR ( (P_PERSON_ID IS NULL)
AND (RECINFO.PERSON_ID IS NULL) ) ) AND */
( (P_RUN_TYPE_ID = RECINFO.RUN_TYPE_ID)
OR ( (P_RUN_TYPE_ID IS NULL)
AND (RECINFO.RUN_TYPE_ID IS NULL) ) ) AND
( (P_ORG_PAYMENT_METHOD_ID = RECINFO.ORG_PAYMENT_METHOD_ID)
OR ( (P_ORG_PAYMENT_METHOD_ID IS NULL)
AND (RECINFO.ORG_PAYMENT_METHOD_ID IS NULL) ) ) AND
( (P_AMOUNT = RECINFO.AMOUNT)
OR ( (P_AMOUNT IS NULL)
AND (RECINFO.AMOUNT IS NULL) ) ) AND
( (P_COMMENT_ID = RECINFO.COMMENT_ID)
OR ( (P_COMMENT_ID IS NULL)
AND (RECINFO.COMMENT_ID IS NULL) ) ) AND
( (P_PERCENTAGE = RECINFO.PERCENTAGE)
OR ( (P_PERCENTAGE IS NULL)
AND (RECINFO.PERCENTAGE IS NULL) ) ) AND
( (P_PRIORITY = RECINFO.PRIORITY)
OR ( (P_PRIORITY IS NULL)
AND (RECINFO.PRIORITY IS NULL) ) ) AND
( (P_PAYEE_TYPE = RECINFO.PAYEE_TYPE)
OR ( (P_PAYEE_TYPE IS NULL)
AND (RECINFO.PAYEE_TYPE IS NULL) ) ) AND
( (P_PAYEE_ID = RECINFO.PAYEE_ID)
OR ( (P_PAYEE_ID IS NULL)
AND (RECINFO.PAYEE_ID IS NULL) ) ) AND
( (P_ATTRIBUTE_CATEGORY = RECINFO.ATTRIBUTE_CATEGORY)
OR ( (P_ATTRIBUTE_CATEGORY IS NULL)
AND (RECINFO.ATTRIBUTE_CATEGORY IS NULL) ) ) AND
( (P_ATTRIBUTE1 = RECINFO.ATTRIBUTE1)
OR ( (P_ATTRIBUTE1 IS NULL)
AND (RECINFO.ATTRIBUTE1 IS NULL) ) ) AND
( (P_ATTRIBUTE2 = RECINFO.ATTRIBUTE2)
OR ( (P_ATTRIBUTE2 IS NULL)
AND (RECINFO.ATTRIBUTE2 IS NULL) ) ) AND
( (P_ATTRIBUTE3 = RECINFO.ATTRIBUTE3)
OR ( (P_ATTRIBUTE3 IS NULL)
AND (RECINFO.ATTRIBUTE3 IS NULL) ) ) AND
( (P_ATTRIBUTE4 = RECINFO.ATTRIBUTE4)
OR ( (P_ATTRIBUTE4 IS NULL)
AND (RECINFO.ATTRIBUTE4 IS NULL) ) ) AND
( (P_ATTRIBUTE5 = RECINFO.ATTRIBUTE5)
OR ( (P_ATTRIBUTE5 IS NULL)
AND (RECINFO.ATTRIBUTE5 IS NULL) ) ) AND
( (P_ATTRIBUTE6 = RECINFO.ATTRIBUTE6)
OR ( (P_ATTRIBUTE6 IS NULL)
AND (RECINFO.ATTRIBUTE6 IS NULL) ) ) AND
( (P_ATTRIBUTE7 = RECINFO.ATTRIBUTE7)
OR ( (P_ATTRIBUTE7 IS NULL)
AND (RECINFO.ATTRIBUTE7 IS NULL) ) ) AND
( (P_ATTRIBUTE8 = RECINFO.ATTRIBUTE8)
OR ( (P_ATTRIBUTE8 IS NULL)
AND (RECINFO.ATTRIBUTE8 IS NULL) ) ) AND
( (P_ATTRIBUTE9 = RECINFO.ATTRIBUTE9)
OR ( (P_ATTRIBUTE9 IS NULL)
AND (RECINFO.ATTRIBUTE9 IS NULL) ) ) AND
( (P_ATTRIBUTE10 = RECINFO.ATTRIBUTE10)
OR ( (P_ATTRIBUTE10 IS NULL)
AND (RECINFO.ATTRIBUTE10 IS NULL) ) ) AND
( (P_ATTRIBUTE11 = RECINFO.ATTRIBUTE11)
OR ( (P_ATTRIBUTE11 IS NULL)
AND (RECINFO.ATTRIBUTE11 IS NULL) ) ) AND
( (P_ATTRIBUTE12 = RECINFO.ATTRIBUTE12)
OR ( (P_ATTRIBUTE12 IS NULL)
AND (RECINFO.ATTRIBUTE12 IS NULL) ) ) AND
( (P_ATTRIBUTE13 = RECINFO.ATTRIBUTE13)
OR ( (P_ATTRIBUTE13 IS NULL)
AND (RECINFO.ATTRIBUTE13 IS NULL) ) ) AND
( (P_ATTRIBUTE14 = RECINFO.ATTRIBUTE14)
OR ( (P_ATTRIBUTE14 IS NULL)
AND (RECINFO.ATTRIBUTE14 IS NULL) ) ) AND
( (P_ATTRIBUTE15 = RECINFO.ATTRIBUTE15)
OR ( (P_ATTRIBUTE15 IS NULL)
AND (RECINFO.ATTRIBUTE15 IS NULL) ) ) AND
( (P_ATTRIBUTE16 = RECINFO.ATTRIBUTE16)
OR ( (P_ATTRIBUTE16 IS NULL)
AND (RECINFO.ATTRIBUTE16 IS NULL) ) ) AND
( (P_ATTRIBUTE17 = RECINFO.ATTRIBUTE17)
OR ( (P_ATTRIBUTE17 IS NULL)
AND (RECINFO.ATTRIBUTE17 IS NULL) ) ) AND
( (P_ATTRIBUTE18 = RECINFO.ATTRIBUTE18)
OR ( (P_ATTRIBUTE18 IS NULL)
AND (RECINFO.ATTRIBUTE18 IS NULL) ) ) AND
( (P_ATTRIBUTE19 = RECINFO.ATTRIBUTE19)
OR ( (P_ATTRIBUTE19 IS NULL)
AND (RECINFO.ATTRIBUTE19 IS NULL) ) ) AND
( (P_ATTRIBUTE20 = RECINFO.ATTRIBUTE20)
OR ( (P_ATTRIBUTE20 IS NULL)
AND (RECINFO.ATTRIBUTE20 IS NULL) ) ) AND
((recinfo.PPM_INFORMATION_CATEGORY = P_PPM_INFORMATION_CATEGORY)
OR ((recinfo.PPM_INFORMATION_CATEGORY is null) AND (P_PPM_INFORMATION_CATEGORY is null)))
AND ((recinfo.PPM_INFORMATION1 = P_PPM_INFORMATION1)
OR ((recinfo.PPM_INFORMATION1 is null) AND (P_PPM_INFORMATION1 is null)))
AND ((recinfo.PPM_INFORMATION2 = P_PPM_INFORMATION2)
OR ((recinfo.PPM_INFORMATION2 is null) AND (P_PPM_INFORMATION2 is null)))
AND ((recinfo.PPM_INFORMATION3 = P_PPM_INFORMATION3)
OR ((recinfo.PPM_INFORMATION3 is null) AND (P_PPM_INFORMATION3 is null)))
AND ((recinfo.PPM_INFORMATION4 = P_PPM_INFORMATION4)
OR ((recinfo.PPM_INFORMATION4 is null) AND (P_PPM_INFORMATION4 is null)))
AND ((recinfo.PPM_INFORMATION5 = P_PPM_INFORMATION5)
OR ((recinfo.PPM_INFORMATION5 is null) AND (P_PPM_INFORMATION5 is null)))
AND ((recinfo.PPM_INFORMATION6 = P_PPM_INFORMATION6)
OR ((recinfo.PPM_INFORMATION6 is null) AND (P_PPM_INFORMATION6 is null)))
AND ((recinfo.PPM_INFORMATION7 = P_PPM_INFORMATION7)
OR ((recinfo.PPM_INFORMATION7 is null) AND (P_PPM_INFORMATION7 is null)))
AND ((recinfo.PPM_INFORMATION8 = P_PPM_INFORMATION8)
OR ((recinfo.PPM_INFORMATION8 is null) AND (P_PPM_INFORMATION8 is null)))
AND ((recinfo.PPM_INFORMATION9 = P_PPM_INFORMATION9)
OR ((recinfo.PPM_INFORMATION9 is null) AND (P_PPM_INFORMATION9 is null)))
AND ((recinfo.PPM_INFORMATION10 = P_PPM_INFORMATION10)
OR ((recinfo.PPM_INFORMATION10 is null) AND (P_PPM_INFORMATION10 is null)))
AND ((recinfo.PPM_INFORMATION11 = P_PPM_INFORMATION11)
OR ((recinfo.PPM_INFORMATION11 is null) AND (P_PPM_INFORMATION11 is null)))
AND ((recinfo.PPM_INFORMATION12 = P_PPM_INFORMATION12)
OR ((recinfo.PPM_INFORMATION12 is null) AND (P_PPM_INFORMATION12 is null)))
AND ((recinfo.PPM_INFORMATION13 = P_PPM_INFORMATION13)
OR ((recinfo.PPM_INFORMATION13 is null) AND (P_PPM_INFORMATION13 is null)))
AND ((recinfo.PPM_INFORMATION14 = P_PPM_INFORMATION14)
OR ((recinfo.PPM_INFORMATION14 is null) AND (P_PPM_INFORMATION14 is null)))
AND ((recinfo.PPM_INFORMATION15 = P_PPM_INFORMATION15)
OR ((recinfo.PPM_INFORMATION15 is null) AND (P_PPM_INFORMATION15 is null)))
AND ((recinfo.PPM_INFORMATION16 = P_PPM_INFORMATION16)
OR ((recinfo.PPM_INFORMATION16 is null) AND (P_PPM_INFORMATION16 is null)))
AND ((recinfo.PPM_INFORMATION17 = P_PPM_INFORMATION17)
OR ((recinfo.PPM_INFORMATION17 is null) AND (P_PPM_INFORMATION17 is null)))
AND ((recinfo.PPM_INFORMATION18 = P_PPM_INFORMATION18)
OR ((recinfo.PPM_INFORMATION18 is null) AND (P_PPM_INFORMATION18 is null)))
AND ((recinfo.PPM_INFORMATION19 = P_PPM_INFORMATION19)
OR ((recinfo.PPM_INFORMATION19 is null) AND (P_PPM_INFORMATION19 is null)))
AND ((recinfo.PPM_INFORMATION20 = P_PPM_INFORMATION20)
OR ((recinfo.PPM_INFORMATION20 is null) AND (P_PPM_INFORMATION20 is null)))
AND ((recinfo.PPM_INFORMATION21 = P_PPM_INFORMATION21)
OR ((recinfo.PPM_INFORMATION21 is null) AND (P_PPM_INFORMATION21 is null)))
AND ((recinfo.PPM_INFORMATION22 = P_PPM_INFORMATION22)
OR ((recinfo.PPM_INFORMATION22 is null) AND (P_PPM_INFORMATION22 is null)))
AND ((recinfo.PPM_INFORMATION23 = P_PPM_INFORMATION23)
OR ((recinfo.PPM_INFORMATION23 is null) AND (P_PPM_INFORMATION23 is null)))
AND ((recinfo.PPM_INFORMATION24 = P_PPM_INFORMATION24)
OR ((recinfo.PPM_INFORMATION24 is null) AND (P_PPM_INFORMATION24 is null)))
AND ((recinfo.PPM_INFORMATION25 = P_PPM_INFORMATION25)
OR ((recinfo.PPM_INFORMATION25 is null) AND (P_PPM_INFORMATION25 is null)))
AND ((recinfo.PPM_INFORMATION26 = P_PPM_INFORMATION26)
OR ((recinfo.PPM_INFORMATION26 is null) AND (P_PPM_INFORMATION26 is null)))
AND ((recinfo.PPM_INFORMATION27 = P_PPM_INFORMATION27)
OR ((recinfo.PPM_INFORMATION27 is null) AND (P_PPM_INFORMATION27 is null)))
AND ((recinfo.PPM_INFORMATION28 = P_PPM_INFORMATION28)
OR ((recinfo.PPM_INFORMATION28 is null) AND (P_PPM_INFORMATION28 is null)))
AND ((recinfo.PPM_INFORMATION29 = P_PPM_INFORMATION29)
OR ((recinfo.PPM_INFORMATION29 is null) AND (P_PPM_INFORMATION29 is null)))
AND ((recinfo.PPM_INFORMATION30 = P_PPM_INFORMATION30)
OR ((recinfo.PPM_INFORMATION30 is null) AND (P_PPM_INFORMATION30 is null)))
) THEN
--
-- Now take out the lock on the external_account record in
-- in case the prenote_date gets changed.
--
open prenote;
select payroll_id
from per_all_assignments_f
where assignment_id = to_number (p_asg_id)
and fnd_date.canonical_to_date(p_new_date) between effective_start_date
and effective_end_date;