61: begin
62: --
63: -- Check mandatory parameters have been set
64: --
65: hr_api.mandatory_arg_error
66: (p_api_name => l_proc
67: ,p_argument => 'org payment method id'
68: ,p_argument_value => p_org_payment_method_id
69: );
67: ,p_argument => 'org payment method id'
68: ,p_argument_value => p_org_payment_method_id
69: );
70: --
71: hr_api.mandatory_arg_error
72: (p_api_name => l_proc
73: ,p_argument => 'effective date'
74: ,p_argument_value => p_effective_date
75: );
288: and pp2.effective_start_date >= p_effective_date)
289: for update nowait;
290: --
291: l_proc varchar2(72) := g_package||'return_payee_date';
292: l_payee_date date := hr_api.g_eot;
293: --
294: begin
295: --
296: hr_utility.set_location('Entering:'||l_proc, 5);
369: ))
370: for update nowait;
371: --
372: l_proc varchar2(72) := g_package||'return_priority_date';
373: l_priority_date date := hr_api.g_eot;
374: --
375: begin
376: --
377: hr_utility.set_location('Entering:'||l_proc, 5);
432: hr_utility.set_location('Entering:'||l_proc, 5);
433: --
434: -- check mandatory arguments
435: --
436: hr_api.mandatory_arg_error
437: (p_api_name => l_proc,
438: p_argument => 'assignment_id',
439: p_argument_value => p_assignment_id);
440: hr_api.mandatory_arg_error
436: hr_api.mandatory_arg_error
437: (p_api_name => l_proc,
438: p_argument => 'assignment_id',
439: p_argument_value => p_assignment_id);
440: hr_api.mandatory_arg_error
441: (p_api_name => l_proc,
442: p_argument => 'business_group_id',
443: p_argument_value => p_business_group_id);
444: hr_api.mandatory_arg_error
440: hr_api.mandatory_arg_error
441: (p_api_name => l_proc,
442: p_argument => 'business_group_id',
443: p_argument_value => p_business_group_id);
444: hr_api.mandatory_arg_error
445: (p_api_name => l_proc,
446: p_argument => 'org_payment_method_id',
447: p_argument_value => p_org_payment_method_id);
448: hr_api.mandatory_arg_error
444: hr_api.mandatory_arg_error
445: (p_api_name => l_proc,
446: p_argument => 'org_payment_method_id',
447: p_argument_value => p_org_payment_method_id);
448: hr_api.mandatory_arg_error
449: (p_api_name => l_proc,
450: p_argument => 'datetrack_mode',
451: p_argument_value => p_datetrack_mode);
452: hr_api.mandatory_arg_error
448: hr_api.mandatory_arg_error
449: (p_api_name => l_proc,
450: p_argument => 'datetrack_mode',
451: p_argument_value => p_datetrack_mode);
452: hr_api.mandatory_arg_error
453: (p_api_name => l_proc,
454: p_argument => 'effective_date',
455: p_argument_value => p_effective_date);
456: hr_api.mandatory_arg_error
452: hr_api.mandatory_arg_error
453: (p_api_name => l_proc,
454: p_argument => 'effective_date',
455: p_argument_value => p_effective_date);
456: hr_api.mandatory_arg_error
457: (p_api_name => l_proc,
458: p_argument => 'validation_start_date',
459: p_argument_value => p_validation_start_date);
460: hr_api.mandatory_arg_error
456: hr_api.mandatory_arg_error
457: (p_api_name => l_proc,
458: p_argument => 'validation_start_date',
459: p_argument_value => p_validation_start_date);
460: hr_api.mandatory_arg_error
461: (p_api_name => l_proc,
462: p_argument => 'validation_end_date',
463: p_argument_value => p_validation_end_date);
464: --
556: hr_utility.set_location('Entering:'|| l_proc, 1);
557: --
558: -- Check mandatory parameters have been set
559: --
560: hr_api.mandatory_arg_error
561: (p_api_name => l_proc
562: ,p_argument => 'org_payment_method_id'
563: ,p_argument_value => p_org_payment_method_id);
564: --
561: (p_api_name => l_proc
562: ,p_argument => 'org_payment_method_id'
563: ,p_argument_value => p_org_payment_method_id);
564: --
565: hr_api.mandatory_arg_error
566: (p_api_name => l_proc
567: ,p_argument => 'effective_date'
568: ,p_argument_value => p_effective_date);
569: --
683: select oru.business_group_id
684: from hr_all_organization_units oru
685: where oru.organization_id = p_payee_id
686: and p_effective_date between oru.date_from and
687: nvl(oru.date_to, hr_api.g_eot);
688: --
689: -- Check that the organization is active and of type 'HR_PAYEE'
690: --
691: cursor csr_chk_organization_active is
723: hr_utility.set_location('Entering:'||l_proc, 5);
724: --
725: -- Ensure that all mandatory arguments are not null.
726: --
727: hr_api.mandatory_arg_error
728: (p_api_name => l_proc
729: ,p_argument => 'business_group_id'
730: ,p_argument_value => p_business_group_id
731: );
729: ,p_argument => 'business_group_id'
730: ,p_argument_value => p_business_group_id
731: );
732: --
733: hr_api.mandatory_arg_error
734: (p_api_name => l_proc
735: ,p_argument => 'assignment_id'
736: ,p_argument_value => p_assignment_id
737: );
809: hr_utility.set_location('Entering:'||l_proc, 5);
810: --
811: -- Ensure that all mandatory arguments are not null.
812: --
813: hr_api.mandatory_arg_error
814: (p_api_name => l_proc
815: ,p_argument => 'org_payment_method_id'
816: ,p_argument_value => p_org_payment_method_id
817: );
815: ,p_argument => 'org_payment_method_id'
816: ,p_argument_value => p_org_payment_method_id
817: );
818: --
819: hr_api.mandatory_arg_error
820: (p_api_name => l_proc
821: ,p_argument => 'effective_date'
822: ,p_argument_value => p_effective_date
823: );
833: ,p_effective_date => p_effective_date
834: ,p_object_version_number => p_object_version_number);
835: --
836: if (l_api_updating and
837: nvl(pay_ppm_shd.g_old_rec.payee_id, hr_api.g_number) <>
838: nvl(p_payee_id, hr_api.g_number)) or
839: (l_api_updating and
840: nvl(pay_ppm_shd.g_old_rec.payee_type, hr_api.g_varchar2) <>
841: nvl(p_payee_type, hr_api.g_varchar2)) or
834: ,p_object_version_number => p_object_version_number);
835: --
836: if (l_api_updating and
837: nvl(pay_ppm_shd.g_old_rec.payee_id, hr_api.g_number) <>
838: nvl(p_payee_id, hr_api.g_number)) or
839: (l_api_updating and
840: nvl(pay_ppm_shd.g_old_rec.payee_type, hr_api.g_varchar2) <>
841: nvl(p_payee_type, hr_api.g_varchar2)) or
842: (not l_api_updating) then
836: if (l_api_updating and
837: nvl(pay_ppm_shd.g_old_rec.payee_id, hr_api.g_number) <>
838: nvl(p_payee_id, hr_api.g_number)) or
839: (l_api_updating and
840: nvl(pay_ppm_shd.g_old_rec.payee_type, hr_api.g_varchar2) <>
841: nvl(p_payee_type, hr_api.g_varchar2)) or
842: (not l_api_updating) then
843: open csr_chk_garnishment;
844: fetch csr_chk_garnishment into l_exists;
837: nvl(pay_ppm_shd.g_old_rec.payee_id, hr_api.g_number) <>
838: nvl(p_payee_id, hr_api.g_number)) or
839: (l_api_updating and
840: nvl(pay_ppm_shd.g_old_rec.payee_type, hr_api.g_varchar2) <>
841: nvl(p_payee_type, hr_api.g_varchar2)) or
842: (not l_api_updating) then
843: open csr_chk_garnishment;
844: fetch csr_chk_garnishment into l_exists;
845: if csr_chk_garnishment%notfound then
918: hr_utility.set_location('Entering:'|| l_proc, 1);
919: --
920: -- Check mandatory parameters have been set
921: --
922: hr_api.mandatory_arg_error
923: (p_api_name => l_proc
924: ,p_argument => 'org payment method id'
925: ,p_argument_value => p_org_payment_method_id
926: );
924: ,p_argument => 'org payment method id'
925: ,p_argument_value => p_org_payment_method_id
926: );
927: --
928: hr_api.mandatory_arg_error
929: (p_api_name => l_proc
930: ,p_argument => 'effective date'
931: ,p_argument_value => p_effective_date
932: );
939: (p_personal_payment_method_id => p_personal_payment_method_id
940: ,p_effective_date => p_effective_date
941: ,p_object_version_number => p_object_version_number);
942: --
943: if ((l_api_updating and nvl(pay_ppm_shd.g_old_rec.amount,hr_api.g_number)
944: <> nvl(p_amount,hr_api.g_number)) or
945: (l_api_updating and nvl(pay_ppm_shd.g_old_rec.percentage,hr_api.g_number)
946: <> nvl(p_percentage,hr_api.g_number)) or
947: (NOT l_api_updating)) then
940: ,p_effective_date => p_effective_date
941: ,p_object_version_number => p_object_version_number);
942: --
943: if ((l_api_updating and nvl(pay_ppm_shd.g_old_rec.amount,hr_api.g_number)
944: <> nvl(p_amount,hr_api.g_number)) or
945: (l_api_updating and nvl(pay_ppm_shd.g_old_rec.percentage,hr_api.g_number)
946: <> nvl(p_percentage,hr_api.g_number)) or
947: (NOT l_api_updating)) then
948: hr_utility.set_location(l_proc, 2);
941: ,p_object_version_number => p_object_version_number);
942: --
943: if ((l_api_updating and nvl(pay_ppm_shd.g_old_rec.amount,hr_api.g_number)
944: <> nvl(p_amount,hr_api.g_number)) or
945: (l_api_updating and nvl(pay_ppm_shd.g_old_rec.percentage,hr_api.g_number)
946: <> nvl(p_percentage,hr_api.g_number)) or
947: (NOT l_api_updating)) then
948: hr_utility.set_location(l_proc, 2);
949: --
942: --
943: if ((l_api_updating and nvl(pay_ppm_shd.g_old_rec.amount,hr_api.g_number)
944: <> nvl(p_amount,hr_api.g_number)) or
945: (l_api_updating and nvl(pay_ppm_shd.g_old_rec.percentage,hr_api.g_number)
946: <> nvl(p_percentage,hr_api.g_number)) or
947: (NOT l_api_updating)) then
948: hr_utility.set_location(l_proc, 2);
949: --
950: -- Check the related balance type
1099: hr_utility.set_location('Entering:'|| l_proc, 1);
1100: --
1101: -- Check mandatory parameters have been set
1102: --
1103: hr_api.mandatory_arg_error
1104: (p_api_name => l_proc
1105: ,p_argument => 'org payment method id'
1106: ,p_argument_value => p_org_payment_method_id
1107: );
1105: ,p_argument => 'org payment method id'
1106: ,p_argument_value => p_org_payment_method_id
1107: );
1108: --
1109: hr_api.mandatory_arg_error
1110: (p_api_name => l_proc
1111: ,p_argument => 'effective date'
1112: ,p_argument_value => p_effective_date
1113: );
1121: ,p_effective_date => p_effective_date
1122: ,p_object_version_number => p_object_version_number);
1123: --
1124: if ((l_api_updating and nvl(pay_ppm_shd.g_old_rec.external_account_id,
1125: hr_api.g_number)
1126: <> nvl(p_external_account_id,hr_api.g_number)) or
1127: (NOT l_api_updating)) then
1128: hr_utility.set_location(l_proc, 2);
1129: --
1122: ,p_object_version_number => p_object_version_number);
1123: --
1124: if ((l_api_updating and nvl(pay_ppm_shd.g_old_rec.external_account_id,
1125: hr_api.g_number)
1126: <> nvl(p_external_account_id,hr_api.g_number)) or
1127: (NOT l_api_updating)) then
1128: hr_utility.set_location(l_proc, 2);
1129: --
1130: -- Check if related payment type is Magnetic Tape
1251: hr_utility.set_location('Entering:'|| l_proc, 1);
1252: --
1253: -- Check mandatory parameters have been set
1254: --
1255: hr_api.mandatory_arg_error
1256: (p_api_name => l_proc
1257: ,p_argument => 'org_payment_method_id'
1258: ,p_argument_value => p_org_payment_method_id
1259: );
1257: ,p_argument => 'org_payment_method_id'
1258: ,p_argument_value => p_org_payment_method_id
1259: );
1260: --
1261: hr_api.mandatory_arg_error
1262: (p_api_name => l_proc
1263: ,p_argument => 'assignment_id'
1264: ,p_argument_value => p_assignment_id
1265: );
1263: ,p_argument => 'assignment_id'
1264: ,p_argument_value => p_assignment_id
1265: );
1266: --
1267: hr_api.mandatory_arg_error
1268: (p_api_name => l_proc
1269: ,p_argument => 'effective_date'
1270: ,p_argument_value => p_effective_date
1271: );
1278: (p_personal_payment_method_id => p_personal_payment_method_id
1279: ,p_effective_date => p_effective_date
1280: ,p_object_version_number => p_object_version_number);
1281: --
1282: if ((l_api_updating and nvl(pay_ppm_shd.g_old_rec.priority,hr_api.g_number)
1283: <> nvl(p_priority,hr_api.g_number)) or
1284: (NOT l_api_updating)) then
1285: hr_utility.set_location(l_proc, 2);
1286: --
1279: ,p_effective_date => p_effective_date
1280: ,p_object_version_number => p_object_version_number);
1281: --
1282: if ((l_api_updating and nvl(pay_ppm_shd.g_old_rec.priority,hr_api.g_number)
1283: <> nvl(p_priority,hr_api.g_number)) or
1284: (NOT l_api_updating)) then
1285: hr_utility.set_location(l_proc, 2);
1286: --
1287: -- Check if priority is null
1450: hr_utility.set_location('Entering:'|| l_proc, 1);
1451: --
1452: -- Check mandatory parameters have been set
1453: --
1454: hr_api.mandatory_arg_error
1455: (p_api_name => l_proc
1456: ,p_argument => 'effective_date'
1457: ,p_argument_value => p_effective_date
1458: );
1456: ,p_argument => 'effective_date'
1457: ,p_argument_value => p_effective_date
1458: );
1459: --
1460: hr_api.mandatory_arg_error
1461: (p_api_name => l_proc
1462: ,p_argument => 'datetrack_mode'
1463: ,p_argument_value => p_datetrack_mode
1464: );
1532: end if;
1533: --
1534: hr_utility.set_location(l_proc, 6);
1535: --
1536: if nvl(p_rec.business_group_id, hr_api.g_number) <>
1537: nvl(pay_ppm_shd.g_old_rec.business_group_id, hr_api.g_number) then
1538: l_argument := 'business_group_id';
1539: raise l_error;
1540: end if;
1533: --
1534: hr_utility.set_location(l_proc, 6);
1535: --
1536: if nvl(p_rec.business_group_id, hr_api.g_number) <>
1537: nvl(pay_ppm_shd.g_old_rec.business_group_id, hr_api.g_number) then
1538: l_argument := 'business_group_id';
1539: raise l_error;
1540: end if;
1541: hr_utility.set_location(l_proc, 7);
1545: raise l_error;
1546: end if;
1547: hr_utility.set_location(l_proc, 8);
1548: --
1549: if nvl(p_rec.org_payment_method_id, hr_api.g_number) <>
1550: nvl(pay_ppm_shd.g_old_rec.org_payment_method_id, hr_api.g_number) then
1551: l_argument := 'org_payment_method_id';
1552: raise l_error;
1553: end if;
1546: end if;
1547: hr_utility.set_location(l_proc, 8);
1548: --
1549: if nvl(p_rec.org_payment_method_id, hr_api.g_number) <>
1550: nvl(pay_ppm_shd.g_old_rec.org_payment_method_id, hr_api.g_number) then
1551: l_argument := 'org_payment_method_id';
1552: raise l_error;
1553: end if;
1554: hr_utility.set_location(l_proc, 9);
1554: hr_utility.set_location(l_proc, 9);
1555: --
1556: exception
1557: when l_error then
1558: hr_api.argument_changed_error
1559: (p_api_name => l_proc
1560: ,p_argument => l_argument);
1561: when others then
1562: raise;
1592: --
1593: -- {End Of Comments}
1594: -- ----------------------------------------------------------------------------
1595: Procedure dt_update_validate
1596: (p_org_payment_method_id in number default hr_api.g_number,
1597: p_assignment_id in number default hr_api.g_number,
1598: p_datetrack_mode in varchar2,
1599: p_validation_start_date in date,
1600: p_validation_end_date in date) Is
1593: -- {End Of Comments}
1594: -- ----------------------------------------------------------------------------
1595: Procedure dt_update_validate
1596: (p_org_payment_method_id in number default hr_api.g_number,
1597: p_assignment_id in number default hr_api.g_number,
1598: p_datetrack_mode in varchar2,
1599: p_validation_start_date in date,
1600: p_validation_end_date in date) Is
1601: --
1607: hr_utility.set_location('Entering:'||l_proc, 5);
1608: --
1609: -- Ensure that the p_datetrack_mode argument is not null
1610: --
1611: hr_api.mandatory_arg_error
1612: (p_api_name => l_proc,
1613: p_argument => 'datetrack_mode',
1614: p_argument_value => p_datetrack_mode);
1615: --
1619: --
1620: --
1621: -- Ensure the arguments are not null
1622: --
1623: hr_api.mandatory_arg_error
1624: (p_api_name => l_proc,
1625: p_argument => 'validation_start_date',
1626: p_argument_value => p_validation_start_date);
1627: --
1624: (p_api_name => l_proc,
1625: p_argument => 'validation_start_date',
1626: p_argument_value => p_validation_start_date);
1627: --
1628: hr_api.mandatory_arg_error
1629: (p_api_name => l_proc,
1630: p_argument => 'validation_end_date',
1631: p_argument_value => p_validation_end_date);
1632: --
1629: (p_api_name => l_proc,
1630: p_argument => 'validation_end_date',
1631: p_argument_value => p_validation_end_date);
1632: --
1633: If ((nvl(p_org_payment_method_id, hr_api.g_number) <> hr_api.g_number) and
1634: NOT (dt_api.check_min_max_dates
1635: (p_base_table_name => 'pay_org_payment_methods_f',
1636: p_base_key_column => 'org_payment_method_id',
1637: p_base_key_value => p_org_payment_method_id,
1639: p_to_date => p_validation_end_date))) Then
1640: l_table_name := 'org payment methods';
1641: Raise l_integrity_error;
1642: End If;
1643: If ((nvl(p_assignment_id, hr_api.g_number) <> hr_api.g_number) and
1644: NOT (dt_api.check_min_max_dates
1645: (p_base_table_name => 'per_all_assignments_f',
1646: p_base_key_column => 'assignment_id',
1647: p_base_key_value => p_assignment_id,
1724: hr_utility.set_location('Entering:'||l_proc, 5);
1725: --
1726: -- Ensure that the p_datetrack_mode argument is not null
1727: --
1728: hr_api.mandatory_arg_error
1729: (p_api_name => l_proc,
1730: p_argument => 'datetrack_mode',
1731: p_argument_value => p_datetrack_mode);
1732: --
1746: --
1747: --
1748: -- Ensure the arguments are not null
1749: --
1750: hr_api.mandatory_arg_error
1751: (p_api_name => l_proc,
1752: p_argument => 'validation_start_date',
1753: p_argument_value => p_validation_start_date);
1754: --
1751: (p_api_name => l_proc,
1752: p_argument => 'validation_start_date',
1753: p_argument_value => p_validation_start_date);
1754: --
1755: hr_api.mandatory_arg_error
1756: (p_api_name => l_proc,
1757: p_argument => 'validation_end_date',
1758: p_argument_value => p_validation_end_date);
1759: --
1756: (p_api_name => l_proc,
1757: p_argument => 'validation_end_date',
1758: p_argument_value => p_validation_end_date);
1759: --
1760: hr_api.mandatory_arg_error
1761: (p_api_name => l_proc,
1762: p_argument => 'personal_payment_method_id',
1763: p_argument_value => p_personal_payment_method_id);
1764: --
1807: -- Business Rules in payppm.bru is provided.
1808: --
1809: -- Validate Business Group ID
1810: --
1811: hr_api.validate_bus_grp_id(p_rec.business_group_id);
1812: --
1813: -- Validate Org Payment Method ID
1814: --
1815: chk_org_payment_method_id
2032: hr_utility.set_location('Entering:'|| l_proc, 10);
2033: --
2034: -- Ensure that all the mandatory parameter are not null
2035: --
2036: hr_api.mandatory_arg_error(p_api_name => l_proc,
2037: p_argument => 'personal_payment_method_id',
2038: p_argument_value => p_personal_payment_method_id);
2039: --
2040: open csr_leg_code;
2066: begin
2067: hr_utility.set_location('Entering:'||l_proc,10);
2068: --
2069: if ((p_rec.personal_payment_method_id is not null) and (
2070: nvl(pay_ppm_shd.g_old_rec.ppm_information_category, hr_api.g_varchar2) <>
2071: nvl(p_rec.ppm_information_category, hr_api.g_varchar2) or
2072: nvl(pay_ppm_shd.g_old_rec.ppm_information1, hr_api.g_varchar2) <>
2073: nvl(p_rec.ppm_information1, hr_api.g_varchar2) or
2074: nvl(pay_ppm_shd.g_old_rec.ppm_information2, hr_api.g_varchar2) <>
2067: hr_utility.set_location('Entering:'||l_proc,10);
2068: --
2069: if ((p_rec.personal_payment_method_id is not null) and (
2070: nvl(pay_ppm_shd.g_old_rec.ppm_information_category, hr_api.g_varchar2) <>
2071: nvl(p_rec.ppm_information_category, hr_api.g_varchar2) or
2072: nvl(pay_ppm_shd.g_old_rec.ppm_information1, hr_api.g_varchar2) <>
2073: nvl(p_rec.ppm_information1, hr_api.g_varchar2) or
2074: nvl(pay_ppm_shd.g_old_rec.ppm_information2, hr_api.g_varchar2) <>
2075: nvl(p_rec.ppm_information2, hr_api.g_varchar2) or
2068: --
2069: if ((p_rec.personal_payment_method_id is not null) and (
2070: nvl(pay_ppm_shd.g_old_rec.ppm_information_category, hr_api.g_varchar2) <>
2071: nvl(p_rec.ppm_information_category, hr_api.g_varchar2) or
2072: nvl(pay_ppm_shd.g_old_rec.ppm_information1, hr_api.g_varchar2) <>
2073: nvl(p_rec.ppm_information1, hr_api.g_varchar2) or
2074: nvl(pay_ppm_shd.g_old_rec.ppm_information2, hr_api.g_varchar2) <>
2075: nvl(p_rec.ppm_information2, hr_api.g_varchar2) or
2076: nvl(pay_ppm_shd.g_old_rec.ppm_information3, hr_api.g_varchar2) <>
2069: if ((p_rec.personal_payment_method_id is not null) and (
2070: nvl(pay_ppm_shd.g_old_rec.ppm_information_category, hr_api.g_varchar2) <>
2071: nvl(p_rec.ppm_information_category, hr_api.g_varchar2) or
2072: nvl(pay_ppm_shd.g_old_rec.ppm_information1, hr_api.g_varchar2) <>
2073: nvl(p_rec.ppm_information1, hr_api.g_varchar2) or
2074: nvl(pay_ppm_shd.g_old_rec.ppm_information2, hr_api.g_varchar2) <>
2075: nvl(p_rec.ppm_information2, hr_api.g_varchar2) or
2076: nvl(pay_ppm_shd.g_old_rec.ppm_information3, hr_api.g_varchar2) <>
2077: nvl(p_rec.ppm_information3, hr_api.g_varchar2) or
2070: nvl(pay_ppm_shd.g_old_rec.ppm_information_category, hr_api.g_varchar2) <>
2071: nvl(p_rec.ppm_information_category, hr_api.g_varchar2) or
2072: nvl(pay_ppm_shd.g_old_rec.ppm_information1, hr_api.g_varchar2) <>
2073: nvl(p_rec.ppm_information1, hr_api.g_varchar2) or
2074: nvl(pay_ppm_shd.g_old_rec.ppm_information2, hr_api.g_varchar2) <>
2075: nvl(p_rec.ppm_information2, hr_api.g_varchar2) or
2076: nvl(pay_ppm_shd.g_old_rec.ppm_information3, hr_api.g_varchar2) <>
2077: nvl(p_rec.ppm_information3, hr_api.g_varchar2) or
2078: nvl(pay_ppm_shd.g_old_rec.ppm_information4, hr_api.g_varchar2) <>
2071: nvl(p_rec.ppm_information_category, hr_api.g_varchar2) or
2072: nvl(pay_ppm_shd.g_old_rec.ppm_information1, hr_api.g_varchar2) <>
2073: nvl(p_rec.ppm_information1, hr_api.g_varchar2) or
2074: nvl(pay_ppm_shd.g_old_rec.ppm_information2, hr_api.g_varchar2) <>
2075: nvl(p_rec.ppm_information2, hr_api.g_varchar2) or
2076: nvl(pay_ppm_shd.g_old_rec.ppm_information3, hr_api.g_varchar2) <>
2077: nvl(p_rec.ppm_information3, hr_api.g_varchar2) or
2078: nvl(pay_ppm_shd.g_old_rec.ppm_information4, hr_api.g_varchar2) <>
2079: nvl(p_rec.ppm_information4, hr_api.g_varchar2) or
2072: nvl(pay_ppm_shd.g_old_rec.ppm_information1, hr_api.g_varchar2) <>
2073: nvl(p_rec.ppm_information1, hr_api.g_varchar2) or
2074: nvl(pay_ppm_shd.g_old_rec.ppm_information2, hr_api.g_varchar2) <>
2075: nvl(p_rec.ppm_information2, hr_api.g_varchar2) or
2076: nvl(pay_ppm_shd.g_old_rec.ppm_information3, hr_api.g_varchar2) <>
2077: nvl(p_rec.ppm_information3, hr_api.g_varchar2) or
2078: nvl(pay_ppm_shd.g_old_rec.ppm_information4, hr_api.g_varchar2) <>
2079: nvl(p_rec.ppm_information4, hr_api.g_varchar2) or
2080: nvl(pay_ppm_shd.g_old_rec.ppm_information5, hr_api.g_varchar2) <>
2073: nvl(p_rec.ppm_information1, hr_api.g_varchar2) or
2074: nvl(pay_ppm_shd.g_old_rec.ppm_information2, hr_api.g_varchar2) <>
2075: nvl(p_rec.ppm_information2, hr_api.g_varchar2) or
2076: nvl(pay_ppm_shd.g_old_rec.ppm_information3, hr_api.g_varchar2) <>
2077: nvl(p_rec.ppm_information3, hr_api.g_varchar2) or
2078: nvl(pay_ppm_shd.g_old_rec.ppm_information4, hr_api.g_varchar2) <>
2079: nvl(p_rec.ppm_information4, hr_api.g_varchar2) or
2080: nvl(pay_ppm_shd.g_old_rec.ppm_information5, hr_api.g_varchar2) <>
2081: nvl(p_rec.ppm_information5, hr_api.g_varchar2) or
2074: nvl(pay_ppm_shd.g_old_rec.ppm_information2, hr_api.g_varchar2) <>
2075: nvl(p_rec.ppm_information2, hr_api.g_varchar2) or
2076: nvl(pay_ppm_shd.g_old_rec.ppm_information3, hr_api.g_varchar2) <>
2077: nvl(p_rec.ppm_information3, hr_api.g_varchar2) or
2078: nvl(pay_ppm_shd.g_old_rec.ppm_information4, hr_api.g_varchar2) <>
2079: nvl(p_rec.ppm_information4, hr_api.g_varchar2) or
2080: nvl(pay_ppm_shd.g_old_rec.ppm_information5, hr_api.g_varchar2) <>
2081: nvl(p_rec.ppm_information5, hr_api.g_varchar2) or
2082: nvl(pay_ppm_shd.g_old_rec.ppm_information6, hr_api.g_varchar2) <>
2075: nvl(p_rec.ppm_information2, hr_api.g_varchar2) or
2076: nvl(pay_ppm_shd.g_old_rec.ppm_information3, hr_api.g_varchar2) <>
2077: nvl(p_rec.ppm_information3, hr_api.g_varchar2) or
2078: nvl(pay_ppm_shd.g_old_rec.ppm_information4, hr_api.g_varchar2) <>
2079: nvl(p_rec.ppm_information4, hr_api.g_varchar2) or
2080: nvl(pay_ppm_shd.g_old_rec.ppm_information5, hr_api.g_varchar2) <>
2081: nvl(p_rec.ppm_information5, hr_api.g_varchar2) or
2082: nvl(pay_ppm_shd.g_old_rec.ppm_information6, hr_api.g_varchar2) <>
2083: nvl(p_rec.ppm_information6, hr_api.g_varchar2) or
2076: nvl(pay_ppm_shd.g_old_rec.ppm_information3, hr_api.g_varchar2) <>
2077: nvl(p_rec.ppm_information3, hr_api.g_varchar2) or
2078: nvl(pay_ppm_shd.g_old_rec.ppm_information4, hr_api.g_varchar2) <>
2079: nvl(p_rec.ppm_information4, hr_api.g_varchar2) or
2080: nvl(pay_ppm_shd.g_old_rec.ppm_information5, hr_api.g_varchar2) <>
2081: nvl(p_rec.ppm_information5, hr_api.g_varchar2) or
2082: nvl(pay_ppm_shd.g_old_rec.ppm_information6, hr_api.g_varchar2) <>
2083: nvl(p_rec.ppm_information6, hr_api.g_varchar2) or
2084: nvl(pay_ppm_shd.g_old_rec.ppm_information7, hr_api.g_varchar2) <>
2077: nvl(p_rec.ppm_information3, hr_api.g_varchar2) or
2078: nvl(pay_ppm_shd.g_old_rec.ppm_information4, hr_api.g_varchar2) <>
2079: nvl(p_rec.ppm_information4, hr_api.g_varchar2) or
2080: nvl(pay_ppm_shd.g_old_rec.ppm_information5, hr_api.g_varchar2) <>
2081: nvl(p_rec.ppm_information5, hr_api.g_varchar2) or
2082: nvl(pay_ppm_shd.g_old_rec.ppm_information6, hr_api.g_varchar2) <>
2083: nvl(p_rec.ppm_information6, hr_api.g_varchar2) or
2084: nvl(pay_ppm_shd.g_old_rec.ppm_information7, hr_api.g_varchar2) <>
2085: nvl(p_rec.ppm_information7, hr_api.g_varchar2) or
2078: nvl(pay_ppm_shd.g_old_rec.ppm_information4, hr_api.g_varchar2) <>
2079: nvl(p_rec.ppm_information4, hr_api.g_varchar2) or
2080: nvl(pay_ppm_shd.g_old_rec.ppm_information5, hr_api.g_varchar2) <>
2081: nvl(p_rec.ppm_information5, hr_api.g_varchar2) or
2082: nvl(pay_ppm_shd.g_old_rec.ppm_information6, hr_api.g_varchar2) <>
2083: nvl(p_rec.ppm_information6, hr_api.g_varchar2) or
2084: nvl(pay_ppm_shd.g_old_rec.ppm_information7, hr_api.g_varchar2) <>
2085: nvl(p_rec.ppm_information7, hr_api.g_varchar2) or
2086: nvl(pay_ppm_shd.g_old_rec.ppm_information8, hr_api.g_varchar2) <>
2079: nvl(p_rec.ppm_information4, hr_api.g_varchar2) or
2080: nvl(pay_ppm_shd.g_old_rec.ppm_information5, hr_api.g_varchar2) <>
2081: nvl(p_rec.ppm_information5, hr_api.g_varchar2) or
2082: nvl(pay_ppm_shd.g_old_rec.ppm_information6, hr_api.g_varchar2) <>
2083: nvl(p_rec.ppm_information6, hr_api.g_varchar2) or
2084: nvl(pay_ppm_shd.g_old_rec.ppm_information7, hr_api.g_varchar2) <>
2085: nvl(p_rec.ppm_information7, hr_api.g_varchar2) or
2086: nvl(pay_ppm_shd.g_old_rec.ppm_information8, hr_api.g_varchar2) <>
2087: nvl(p_rec.ppm_information8, hr_api.g_varchar2) or
2080: nvl(pay_ppm_shd.g_old_rec.ppm_information5, hr_api.g_varchar2) <>
2081: nvl(p_rec.ppm_information5, hr_api.g_varchar2) or
2082: nvl(pay_ppm_shd.g_old_rec.ppm_information6, hr_api.g_varchar2) <>
2083: nvl(p_rec.ppm_information6, hr_api.g_varchar2) or
2084: nvl(pay_ppm_shd.g_old_rec.ppm_information7, hr_api.g_varchar2) <>
2085: nvl(p_rec.ppm_information7, hr_api.g_varchar2) or
2086: nvl(pay_ppm_shd.g_old_rec.ppm_information8, hr_api.g_varchar2) <>
2087: nvl(p_rec.ppm_information8, hr_api.g_varchar2) or
2088: nvl(pay_ppm_shd.g_old_rec.ppm_information9, hr_api.g_varchar2) <>
2081: nvl(p_rec.ppm_information5, hr_api.g_varchar2) or
2082: nvl(pay_ppm_shd.g_old_rec.ppm_information6, hr_api.g_varchar2) <>
2083: nvl(p_rec.ppm_information6, hr_api.g_varchar2) or
2084: nvl(pay_ppm_shd.g_old_rec.ppm_information7, hr_api.g_varchar2) <>
2085: nvl(p_rec.ppm_information7, hr_api.g_varchar2) or
2086: nvl(pay_ppm_shd.g_old_rec.ppm_information8, hr_api.g_varchar2) <>
2087: nvl(p_rec.ppm_information8, hr_api.g_varchar2) or
2088: nvl(pay_ppm_shd.g_old_rec.ppm_information9, hr_api.g_varchar2) <>
2089: nvl(p_rec.ppm_information9, hr_api.g_varchar2) or
2082: nvl(pay_ppm_shd.g_old_rec.ppm_information6, hr_api.g_varchar2) <>
2083: nvl(p_rec.ppm_information6, hr_api.g_varchar2) or
2084: nvl(pay_ppm_shd.g_old_rec.ppm_information7, hr_api.g_varchar2) <>
2085: nvl(p_rec.ppm_information7, hr_api.g_varchar2) or
2086: nvl(pay_ppm_shd.g_old_rec.ppm_information8, hr_api.g_varchar2) <>
2087: nvl(p_rec.ppm_information8, hr_api.g_varchar2) or
2088: nvl(pay_ppm_shd.g_old_rec.ppm_information9, hr_api.g_varchar2) <>
2089: nvl(p_rec.ppm_information9, hr_api.g_varchar2) or
2090: nvl(pay_ppm_shd.g_old_rec.ppm_information10, hr_api.g_varchar2) <>
2083: nvl(p_rec.ppm_information6, hr_api.g_varchar2) or
2084: nvl(pay_ppm_shd.g_old_rec.ppm_information7, hr_api.g_varchar2) <>
2085: nvl(p_rec.ppm_information7, hr_api.g_varchar2) or
2086: nvl(pay_ppm_shd.g_old_rec.ppm_information8, hr_api.g_varchar2) <>
2087: nvl(p_rec.ppm_information8, hr_api.g_varchar2) or
2088: nvl(pay_ppm_shd.g_old_rec.ppm_information9, hr_api.g_varchar2) <>
2089: nvl(p_rec.ppm_information9, hr_api.g_varchar2) or
2090: nvl(pay_ppm_shd.g_old_rec.ppm_information10, hr_api.g_varchar2) <>
2091: nvl(p_rec.ppm_information10, hr_api.g_varchar2) or
2084: nvl(pay_ppm_shd.g_old_rec.ppm_information7, hr_api.g_varchar2) <>
2085: nvl(p_rec.ppm_information7, hr_api.g_varchar2) or
2086: nvl(pay_ppm_shd.g_old_rec.ppm_information8, hr_api.g_varchar2) <>
2087: nvl(p_rec.ppm_information8, hr_api.g_varchar2) or
2088: nvl(pay_ppm_shd.g_old_rec.ppm_information9, hr_api.g_varchar2) <>
2089: nvl(p_rec.ppm_information9, hr_api.g_varchar2) or
2090: nvl(pay_ppm_shd.g_old_rec.ppm_information10, hr_api.g_varchar2) <>
2091: nvl(p_rec.ppm_information10, hr_api.g_varchar2) or
2092: nvl(pay_ppm_shd.g_old_rec.ppm_information11, hr_api.g_varchar2) <>
2085: nvl(p_rec.ppm_information7, hr_api.g_varchar2) or
2086: nvl(pay_ppm_shd.g_old_rec.ppm_information8, hr_api.g_varchar2) <>
2087: nvl(p_rec.ppm_information8, hr_api.g_varchar2) or
2088: nvl(pay_ppm_shd.g_old_rec.ppm_information9, hr_api.g_varchar2) <>
2089: nvl(p_rec.ppm_information9, hr_api.g_varchar2) or
2090: nvl(pay_ppm_shd.g_old_rec.ppm_information10, hr_api.g_varchar2) <>
2091: nvl(p_rec.ppm_information10, hr_api.g_varchar2) or
2092: nvl(pay_ppm_shd.g_old_rec.ppm_information11, hr_api.g_varchar2) <>
2093: nvl(p_rec.ppm_information11, hr_api.g_varchar2) or
2086: nvl(pay_ppm_shd.g_old_rec.ppm_information8, hr_api.g_varchar2) <>
2087: nvl(p_rec.ppm_information8, hr_api.g_varchar2) or
2088: nvl(pay_ppm_shd.g_old_rec.ppm_information9, hr_api.g_varchar2) <>
2089: nvl(p_rec.ppm_information9, hr_api.g_varchar2) or
2090: nvl(pay_ppm_shd.g_old_rec.ppm_information10, hr_api.g_varchar2) <>
2091: nvl(p_rec.ppm_information10, hr_api.g_varchar2) or
2092: nvl(pay_ppm_shd.g_old_rec.ppm_information11, hr_api.g_varchar2) <>
2093: nvl(p_rec.ppm_information11, hr_api.g_varchar2) or
2094: nvl(pay_ppm_shd.g_old_rec.ppm_information12, hr_api.g_varchar2) <>
2087: nvl(p_rec.ppm_information8, hr_api.g_varchar2) or
2088: nvl(pay_ppm_shd.g_old_rec.ppm_information9, hr_api.g_varchar2) <>
2089: nvl(p_rec.ppm_information9, hr_api.g_varchar2) or
2090: nvl(pay_ppm_shd.g_old_rec.ppm_information10, hr_api.g_varchar2) <>
2091: nvl(p_rec.ppm_information10, hr_api.g_varchar2) or
2092: nvl(pay_ppm_shd.g_old_rec.ppm_information11, hr_api.g_varchar2) <>
2093: nvl(p_rec.ppm_information11, hr_api.g_varchar2) or
2094: nvl(pay_ppm_shd.g_old_rec.ppm_information12, hr_api.g_varchar2) <>
2095: nvl(p_rec.ppm_information12, hr_api.g_varchar2) or
2088: nvl(pay_ppm_shd.g_old_rec.ppm_information9, hr_api.g_varchar2) <>
2089: nvl(p_rec.ppm_information9, hr_api.g_varchar2) or
2090: nvl(pay_ppm_shd.g_old_rec.ppm_information10, hr_api.g_varchar2) <>
2091: nvl(p_rec.ppm_information10, hr_api.g_varchar2) or
2092: nvl(pay_ppm_shd.g_old_rec.ppm_information11, hr_api.g_varchar2) <>
2093: nvl(p_rec.ppm_information11, hr_api.g_varchar2) or
2094: nvl(pay_ppm_shd.g_old_rec.ppm_information12, hr_api.g_varchar2) <>
2095: nvl(p_rec.ppm_information12, hr_api.g_varchar2) or
2096: nvl(pay_ppm_shd.g_old_rec.ppm_information13, hr_api.g_varchar2) <>
2089: nvl(p_rec.ppm_information9, hr_api.g_varchar2) or
2090: nvl(pay_ppm_shd.g_old_rec.ppm_information10, hr_api.g_varchar2) <>
2091: nvl(p_rec.ppm_information10, hr_api.g_varchar2) or
2092: nvl(pay_ppm_shd.g_old_rec.ppm_information11, hr_api.g_varchar2) <>
2093: nvl(p_rec.ppm_information11, hr_api.g_varchar2) or
2094: nvl(pay_ppm_shd.g_old_rec.ppm_information12, hr_api.g_varchar2) <>
2095: nvl(p_rec.ppm_information12, hr_api.g_varchar2) or
2096: nvl(pay_ppm_shd.g_old_rec.ppm_information13, hr_api.g_varchar2) <>
2097: nvl(p_rec.ppm_information13, hr_api.g_varchar2) or
2090: nvl(pay_ppm_shd.g_old_rec.ppm_information10, hr_api.g_varchar2) <>
2091: nvl(p_rec.ppm_information10, hr_api.g_varchar2) or
2092: nvl(pay_ppm_shd.g_old_rec.ppm_information11, hr_api.g_varchar2) <>
2093: nvl(p_rec.ppm_information11, hr_api.g_varchar2) or
2094: nvl(pay_ppm_shd.g_old_rec.ppm_information12, hr_api.g_varchar2) <>
2095: nvl(p_rec.ppm_information12, hr_api.g_varchar2) or
2096: nvl(pay_ppm_shd.g_old_rec.ppm_information13, hr_api.g_varchar2) <>
2097: nvl(p_rec.ppm_information13, hr_api.g_varchar2) or
2098: nvl(pay_ppm_shd.g_old_rec.ppm_information14, hr_api.g_varchar2) <>
2091: nvl(p_rec.ppm_information10, hr_api.g_varchar2) or
2092: nvl(pay_ppm_shd.g_old_rec.ppm_information11, hr_api.g_varchar2) <>
2093: nvl(p_rec.ppm_information11, hr_api.g_varchar2) or
2094: nvl(pay_ppm_shd.g_old_rec.ppm_information12, hr_api.g_varchar2) <>
2095: nvl(p_rec.ppm_information12, hr_api.g_varchar2) or
2096: nvl(pay_ppm_shd.g_old_rec.ppm_information13, hr_api.g_varchar2) <>
2097: nvl(p_rec.ppm_information13, hr_api.g_varchar2) or
2098: nvl(pay_ppm_shd.g_old_rec.ppm_information14, hr_api.g_varchar2) <>
2099: nvl(p_rec.ppm_information14, hr_api.g_varchar2) or
2092: nvl(pay_ppm_shd.g_old_rec.ppm_information11, hr_api.g_varchar2) <>
2093: nvl(p_rec.ppm_information11, hr_api.g_varchar2) or
2094: nvl(pay_ppm_shd.g_old_rec.ppm_information12, hr_api.g_varchar2) <>
2095: nvl(p_rec.ppm_information12, hr_api.g_varchar2) or
2096: nvl(pay_ppm_shd.g_old_rec.ppm_information13, hr_api.g_varchar2) <>
2097: nvl(p_rec.ppm_information13, hr_api.g_varchar2) or
2098: nvl(pay_ppm_shd.g_old_rec.ppm_information14, hr_api.g_varchar2) <>
2099: nvl(p_rec.ppm_information14, hr_api.g_varchar2) or
2100: nvl(pay_ppm_shd.g_old_rec.ppm_information15, hr_api.g_varchar2) <>
2093: nvl(p_rec.ppm_information11, hr_api.g_varchar2) or
2094: nvl(pay_ppm_shd.g_old_rec.ppm_information12, hr_api.g_varchar2) <>
2095: nvl(p_rec.ppm_information12, hr_api.g_varchar2) or
2096: nvl(pay_ppm_shd.g_old_rec.ppm_information13, hr_api.g_varchar2) <>
2097: nvl(p_rec.ppm_information13, hr_api.g_varchar2) or
2098: nvl(pay_ppm_shd.g_old_rec.ppm_information14, hr_api.g_varchar2) <>
2099: nvl(p_rec.ppm_information14, hr_api.g_varchar2) or
2100: nvl(pay_ppm_shd.g_old_rec.ppm_information15, hr_api.g_varchar2) <>
2101: nvl(p_rec.ppm_information15, hr_api.g_varchar2) or
2094: nvl(pay_ppm_shd.g_old_rec.ppm_information12, hr_api.g_varchar2) <>
2095: nvl(p_rec.ppm_information12, hr_api.g_varchar2) or
2096: nvl(pay_ppm_shd.g_old_rec.ppm_information13, hr_api.g_varchar2) <>
2097: nvl(p_rec.ppm_information13, hr_api.g_varchar2) or
2098: nvl(pay_ppm_shd.g_old_rec.ppm_information14, hr_api.g_varchar2) <>
2099: nvl(p_rec.ppm_information14, hr_api.g_varchar2) or
2100: nvl(pay_ppm_shd.g_old_rec.ppm_information15, hr_api.g_varchar2) <>
2101: nvl(p_rec.ppm_information15, hr_api.g_varchar2) or
2102: nvl(pay_ppm_shd.g_old_rec.ppm_information16, hr_api.g_varchar2) <>
2095: nvl(p_rec.ppm_information12, hr_api.g_varchar2) or
2096: nvl(pay_ppm_shd.g_old_rec.ppm_information13, hr_api.g_varchar2) <>
2097: nvl(p_rec.ppm_information13, hr_api.g_varchar2) or
2098: nvl(pay_ppm_shd.g_old_rec.ppm_information14, hr_api.g_varchar2) <>
2099: nvl(p_rec.ppm_information14, hr_api.g_varchar2) or
2100: nvl(pay_ppm_shd.g_old_rec.ppm_information15, hr_api.g_varchar2) <>
2101: nvl(p_rec.ppm_information15, hr_api.g_varchar2) or
2102: nvl(pay_ppm_shd.g_old_rec.ppm_information16, hr_api.g_varchar2) <>
2103: nvl(p_rec.ppm_information16, hr_api.g_varchar2) or
2096: nvl(pay_ppm_shd.g_old_rec.ppm_information13, hr_api.g_varchar2) <>
2097: nvl(p_rec.ppm_information13, hr_api.g_varchar2) or
2098: nvl(pay_ppm_shd.g_old_rec.ppm_information14, hr_api.g_varchar2) <>
2099: nvl(p_rec.ppm_information14, hr_api.g_varchar2) or
2100: nvl(pay_ppm_shd.g_old_rec.ppm_information15, hr_api.g_varchar2) <>
2101: nvl(p_rec.ppm_information15, hr_api.g_varchar2) or
2102: nvl(pay_ppm_shd.g_old_rec.ppm_information16, hr_api.g_varchar2) <>
2103: nvl(p_rec.ppm_information16, hr_api.g_varchar2) or
2104: nvl(pay_ppm_shd.g_old_rec.ppm_information17, hr_api.g_varchar2) <>
2097: nvl(p_rec.ppm_information13, hr_api.g_varchar2) or
2098: nvl(pay_ppm_shd.g_old_rec.ppm_information14, hr_api.g_varchar2) <>
2099: nvl(p_rec.ppm_information14, hr_api.g_varchar2) or
2100: nvl(pay_ppm_shd.g_old_rec.ppm_information15, hr_api.g_varchar2) <>
2101: nvl(p_rec.ppm_information15, hr_api.g_varchar2) or
2102: nvl(pay_ppm_shd.g_old_rec.ppm_information16, hr_api.g_varchar2) <>
2103: nvl(p_rec.ppm_information16, hr_api.g_varchar2) or
2104: nvl(pay_ppm_shd.g_old_rec.ppm_information17, hr_api.g_varchar2) <>
2105: nvl(p_rec.ppm_information17, hr_api.g_varchar2) or
2098: nvl(pay_ppm_shd.g_old_rec.ppm_information14, hr_api.g_varchar2) <>
2099: nvl(p_rec.ppm_information14, hr_api.g_varchar2) or
2100: nvl(pay_ppm_shd.g_old_rec.ppm_information15, hr_api.g_varchar2) <>
2101: nvl(p_rec.ppm_information15, hr_api.g_varchar2) or
2102: nvl(pay_ppm_shd.g_old_rec.ppm_information16, hr_api.g_varchar2) <>
2103: nvl(p_rec.ppm_information16, hr_api.g_varchar2) or
2104: nvl(pay_ppm_shd.g_old_rec.ppm_information17, hr_api.g_varchar2) <>
2105: nvl(p_rec.ppm_information17, hr_api.g_varchar2) or
2106: nvl(pay_ppm_shd.g_old_rec.ppm_information18, hr_api.g_varchar2) <>
2099: nvl(p_rec.ppm_information14, hr_api.g_varchar2) or
2100: nvl(pay_ppm_shd.g_old_rec.ppm_information15, hr_api.g_varchar2) <>
2101: nvl(p_rec.ppm_information15, hr_api.g_varchar2) or
2102: nvl(pay_ppm_shd.g_old_rec.ppm_information16, hr_api.g_varchar2) <>
2103: nvl(p_rec.ppm_information16, hr_api.g_varchar2) or
2104: nvl(pay_ppm_shd.g_old_rec.ppm_information17, hr_api.g_varchar2) <>
2105: nvl(p_rec.ppm_information17, hr_api.g_varchar2) or
2106: nvl(pay_ppm_shd.g_old_rec.ppm_information18, hr_api.g_varchar2) <>
2107: nvl(p_rec.ppm_information18, hr_api.g_varchar2) or
2100: nvl(pay_ppm_shd.g_old_rec.ppm_information15, hr_api.g_varchar2) <>
2101: nvl(p_rec.ppm_information15, hr_api.g_varchar2) or
2102: nvl(pay_ppm_shd.g_old_rec.ppm_information16, hr_api.g_varchar2) <>
2103: nvl(p_rec.ppm_information16, hr_api.g_varchar2) or
2104: nvl(pay_ppm_shd.g_old_rec.ppm_information17, hr_api.g_varchar2) <>
2105: nvl(p_rec.ppm_information17, hr_api.g_varchar2) or
2106: nvl(pay_ppm_shd.g_old_rec.ppm_information18, hr_api.g_varchar2) <>
2107: nvl(p_rec.ppm_information18, hr_api.g_varchar2) or
2108: nvl(pay_ppm_shd.g_old_rec.ppm_information19, hr_api.g_varchar2) <>
2101: nvl(p_rec.ppm_information15, hr_api.g_varchar2) or
2102: nvl(pay_ppm_shd.g_old_rec.ppm_information16, hr_api.g_varchar2) <>
2103: nvl(p_rec.ppm_information16, hr_api.g_varchar2) or
2104: nvl(pay_ppm_shd.g_old_rec.ppm_information17, hr_api.g_varchar2) <>
2105: nvl(p_rec.ppm_information17, hr_api.g_varchar2) or
2106: nvl(pay_ppm_shd.g_old_rec.ppm_information18, hr_api.g_varchar2) <>
2107: nvl(p_rec.ppm_information18, hr_api.g_varchar2) or
2108: nvl(pay_ppm_shd.g_old_rec.ppm_information19, hr_api.g_varchar2) <>
2109: nvl(p_rec.ppm_information19, hr_api.g_varchar2) or
2102: nvl(pay_ppm_shd.g_old_rec.ppm_information16, hr_api.g_varchar2) <>
2103: nvl(p_rec.ppm_information16, hr_api.g_varchar2) or
2104: nvl(pay_ppm_shd.g_old_rec.ppm_information17, hr_api.g_varchar2) <>
2105: nvl(p_rec.ppm_information17, hr_api.g_varchar2) or
2106: nvl(pay_ppm_shd.g_old_rec.ppm_information18, hr_api.g_varchar2) <>
2107: nvl(p_rec.ppm_information18, hr_api.g_varchar2) or
2108: nvl(pay_ppm_shd.g_old_rec.ppm_information19, hr_api.g_varchar2) <>
2109: nvl(p_rec.ppm_information19, hr_api.g_varchar2) or
2110: nvl(pay_ppm_shd.g_old_rec.ppm_information20, hr_api.g_varchar2) <>
2103: nvl(p_rec.ppm_information16, hr_api.g_varchar2) or
2104: nvl(pay_ppm_shd.g_old_rec.ppm_information17, hr_api.g_varchar2) <>
2105: nvl(p_rec.ppm_information17, hr_api.g_varchar2) or
2106: nvl(pay_ppm_shd.g_old_rec.ppm_information18, hr_api.g_varchar2) <>
2107: nvl(p_rec.ppm_information18, hr_api.g_varchar2) or
2108: nvl(pay_ppm_shd.g_old_rec.ppm_information19, hr_api.g_varchar2) <>
2109: nvl(p_rec.ppm_information19, hr_api.g_varchar2) or
2110: nvl(pay_ppm_shd.g_old_rec.ppm_information20, hr_api.g_varchar2) <>
2111: nvl(p_rec.ppm_information20, hr_api.g_varchar2) or
2104: nvl(pay_ppm_shd.g_old_rec.ppm_information17, hr_api.g_varchar2) <>
2105: nvl(p_rec.ppm_information17, hr_api.g_varchar2) or
2106: nvl(pay_ppm_shd.g_old_rec.ppm_information18, hr_api.g_varchar2) <>
2107: nvl(p_rec.ppm_information18, hr_api.g_varchar2) or
2108: nvl(pay_ppm_shd.g_old_rec.ppm_information19, hr_api.g_varchar2) <>
2109: nvl(p_rec.ppm_information19, hr_api.g_varchar2) or
2110: nvl(pay_ppm_shd.g_old_rec.ppm_information20, hr_api.g_varchar2) <>
2111: nvl(p_rec.ppm_information20, hr_api.g_varchar2) or
2112: nvl(pay_ppm_shd.g_old_rec.ppm_information21, hr_api.g_varchar2) <>
2105: nvl(p_rec.ppm_information17, hr_api.g_varchar2) or
2106: nvl(pay_ppm_shd.g_old_rec.ppm_information18, hr_api.g_varchar2) <>
2107: nvl(p_rec.ppm_information18, hr_api.g_varchar2) or
2108: nvl(pay_ppm_shd.g_old_rec.ppm_information19, hr_api.g_varchar2) <>
2109: nvl(p_rec.ppm_information19, hr_api.g_varchar2) or
2110: nvl(pay_ppm_shd.g_old_rec.ppm_information20, hr_api.g_varchar2) <>
2111: nvl(p_rec.ppm_information20, hr_api.g_varchar2) or
2112: nvl(pay_ppm_shd.g_old_rec.ppm_information21, hr_api.g_varchar2) <>
2113: nvl(p_rec.ppm_information21, hr_api.g_varchar2) or
2106: nvl(pay_ppm_shd.g_old_rec.ppm_information18, hr_api.g_varchar2) <>
2107: nvl(p_rec.ppm_information18, hr_api.g_varchar2) or
2108: nvl(pay_ppm_shd.g_old_rec.ppm_information19, hr_api.g_varchar2) <>
2109: nvl(p_rec.ppm_information19, hr_api.g_varchar2) or
2110: nvl(pay_ppm_shd.g_old_rec.ppm_information20, hr_api.g_varchar2) <>
2111: nvl(p_rec.ppm_information20, hr_api.g_varchar2) or
2112: nvl(pay_ppm_shd.g_old_rec.ppm_information21, hr_api.g_varchar2) <>
2113: nvl(p_rec.ppm_information21, hr_api.g_varchar2) or
2114: nvl(pay_ppm_shd.g_old_rec.ppm_information22, hr_api.g_varchar2) <>
2107: nvl(p_rec.ppm_information18, hr_api.g_varchar2) or
2108: nvl(pay_ppm_shd.g_old_rec.ppm_information19, hr_api.g_varchar2) <>
2109: nvl(p_rec.ppm_information19, hr_api.g_varchar2) or
2110: nvl(pay_ppm_shd.g_old_rec.ppm_information20, hr_api.g_varchar2) <>
2111: nvl(p_rec.ppm_information20, hr_api.g_varchar2) or
2112: nvl(pay_ppm_shd.g_old_rec.ppm_information21, hr_api.g_varchar2) <>
2113: nvl(p_rec.ppm_information21, hr_api.g_varchar2) or
2114: nvl(pay_ppm_shd.g_old_rec.ppm_information22, hr_api.g_varchar2) <>
2115: nvl(p_rec.ppm_information22, hr_api.g_varchar2) or
2108: nvl(pay_ppm_shd.g_old_rec.ppm_information19, hr_api.g_varchar2) <>
2109: nvl(p_rec.ppm_information19, hr_api.g_varchar2) or
2110: nvl(pay_ppm_shd.g_old_rec.ppm_information20, hr_api.g_varchar2) <>
2111: nvl(p_rec.ppm_information20, hr_api.g_varchar2) or
2112: nvl(pay_ppm_shd.g_old_rec.ppm_information21, hr_api.g_varchar2) <>
2113: nvl(p_rec.ppm_information21, hr_api.g_varchar2) or
2114: nvl(pay_ppm_shd.g_old_rec.ppm_information22, hr_api.g_varchar2) <>
2115: nvl(p_rec.ppm_information22, hr_api.g_varchar2) or
2116: nvl(pay_ppm_shd.g_old_rec.ppm_information23, hr_api.g_varchar2) <>
2109: nvl(p_rec.ppm_information19, hr_api.g_varchar2) or
2110: nvl(pay_ppm_shd.g_old_rec.ppm_information20, hr_api.g_varchar2) <>
2111: nvl(p_rec.ppm_information20, hr_api.g_varchar2) or
2112: nvl(pay_ppm_shd.g_old_rec.ppm_information21, hr_api.g_varchar2) <>
2113: nvl(p_rec.ppm_information21, hr_api.g_varchar2) or
2114: nvl(pay_ppm_shd.g_old_rec.ppm_information22, hr_api.g_varchar2) <>
2115: nvl(p_rec.ppm_information22, hr_api.g_varchar2) or
2116: nvl(pay_ppm_shd.g_old_rec.ppm_information23, hr_api.g_varchar2) <>
2117: nvl(p_rec.ppm_information23, hr_api.g_varchar2) or
2110: nvl(pay_ppm_shd.g_old_rec.ppm_information20, hr_api.g_varchar2) <>
2111: nvl(p_rec.ppm_information20, hr_api.g_varchar2) or
2112: nvl(pay_ppm_shd.g_old_rec.ppm_information21, hr_api.g_varchar2) <>
2113: nvl(p_rec.ppm_information21, hr_api.g_varchar2) or
2114: nvl(pay_ppm_shd.g_old_rec.ppm_information22, hr_api.g_varchar2) <>
2115: nvl(p_rec.ppm_information22, hr_api.g_varchar2) or
2116: nvl(pay_ppm_shd.g_old_rec.ppm_information23, hr_api.g_varchar2) <>
2117: nvl(p_rec.ppm_information23, hr_api.g_varchar2) or
2118: nvl(pay_ppm_shd.g_old_rec.ppm_information24, hr_api.g_varchar2) <>
2111: nvl(p_rec.ppm_information20, hr_api.g_varchar2) or
2112: nvl(pay_ppm_shd.g_old_rec.ppm_information21, hr_api.g_varchar2) <>
2113: nvl(p_rec.ppm_information21, hr_api.g_varchar2) or
2114: nvl(pay_ppm_shd.g_old_rec.ppm_information22, hr_api.g_varchar2) <>
2115: nvl(p_rec.ppm_information22, hr_api.g_varchar2) or
2116: nvl(pay_ppm_shd.g_old_rec.ppm_information23, hr_api.g_varchar2) <>
2117: nvl(p_rec.ppm_information23, hr_api.g_varchar2) or
2118: nvl(pay_ppm_shd.g_old_rec.ppm_information24, hr_api.g_varchar2) <>
2119: nvl(p_rec.ppm_information24, hr_api.g_varchar2) or
2112: nvl(pay_ppm_shd.g_old_rec.ppm_information21, hr_api.g_varchar2) <>
2113: nvl(p_rec.ppm_information21, hr_api.g_varchar2) or
2114: nvl(pay_ppm_shd.g_old_rec.ppm_information22, hr_api.g_varchar2) <>
2115: nvl(p_rec.ppm_information22, hr_api.g_varchar2) or
2116: nvl(pay_ppm_shd.g_old_rec.ppm_information23, hr_api.g_varchar2) <>
2117: nvl(p_rec.ppm_information23, hr_api.g_varchar2) or
2118: nvl(pay_ppm_shd.g_old_rec.ppm_information24, hr_api.g_varchar2) <>
2119: nvl(p_rec.ppm_information24, hr_api.g_varchar2) or
2120: nvl(pay_ppm_shd.g_old_rec.ppm_information25, hr_api.g_varchar2) <>
2113: nvl(p_rec.ppm_information21, hr_api.g_varchar2) or
2114: nvl(pay_ppm_shd.g_old_rec.ppm_information22, hr_api.g_varchar2) <>
2115: nvl(p_rec.ppm_information22, hr_api.g_varchar2) or
2116: nvl(pay_ppm_shd.g_old_rec.ppm_information23, hr_api.g_varchar2) <>
2117: nvl(p_rec.ppm_information23, hr_api.g_varchar2) or
2118: nvl(pay_ppm_shd.g_old_rec.ppm_information24, hr_api.g_varchar2) <>
2119: nvl(p_rec.ppm_information24, hr_api.g_varchar2) or
2120: nvl(pay_ppm_shd.g_old_rec.ppm_information25, hr_api.g_varchar2) <>
2121: nvl(p_rec.ppm_information25, hr_api.g_varchar2) or
2114: nvl(pay_ppm_shd.g_old_rec.ppm_information22, hr_api.g_varchar2) <>
2115: nvl(p_rec.ppm_information22, hr_api.g_varchar2) or
2116: nvl(pay_ppm_shd.g_old_rec.ppm_information23, hr_api.g_varchar2) <>
2117: nvl(p_rec.ppm_information23, hr_api.g_varchar2) or
2118: nvl(pay_ppm_shd.g_old_rec.ppm_information24, hr_api.g_varchar2) <>
2119: nvl(p_rec.ppm_information24, hr_api.g_varchar2) or
2120: nvl(pay_ppm_shd.g_old_rec.ppm_information25, hr_api.g_varchar2) <>
2121: nvl(p_rec.ppm_information25, hr_api.g_varchar2) or
2122: nvl(pay_ppm_shd.g_old_rec.ppm_information26, hr_api.g_varchar2) <>
2115: nvl(p_rec.ppm_information22, hr_api.g_varchar2) or
2116: nvl(pay_ppm_shd.g_old_rec.ppm_information23, hr_api.g_varchar2) <>
2117: nvl(p_rec.ppm_information23, hr_api.g_varchar2) or
2118: nvl(pay_ppm_shd.g_old_rec.ppm_information24, hr_api.g_varchar2) <>
2119: nvl(p_rec.ppm_information24, hr_api.g_varchar2) or
2120: nvl(pay_ppm_shd.g_old_rec.ppm_information25, hr_api.g_varchar2) <>
2121: nvl(p_rec.ppm_information25, hr_api.g_varchar2) or
2122: nvl(pay_ppm_shd.g_old_rec.ppm_information26, hr_api.g_varchar2) <>
2123: nvl(p_rec.ppm_information26, hr_api.g_varchar2) or
2116: nvl(pay_ppm_shd.g_old_rec.ppm_information23, hr_api.g_varchar2) <>
2117: nvl(p_rec.ppm_information23, hr_api.g_varchar2) or
2118: nvl(pay_ppm_shd.g_old_rec.ppm_information24, hr_api.g_varchar2) <>
2119: nvl(p_rec.ppm_information24, hr_api.g_varchar2) or
2120: nvl(pay_ppm_shd.g_old_rec.ppm_information25, hr_api.g_varchar2) <>
2121: nvl(p_rec.ppm_information25, hr_api.g_varchar2) or
2122: nvl(pay_ppm_shd.g_old_rec.ppm_information26, hr_api.g_varchar2) <>
2123: nvl(p_rec.ppm_information26, hr_api.g_varchar2) or
2124: nvl(pay_ppm_shd.g_old_rec.ppm_information27, hr_api.g_varchar2) <>
2117: nvl(p_rec.ppm_information23, hr_api.g_varchar2) or
2118: nvl(pay_ppm_shd.g_old_rec.ppm_information24, hr_api.g_varchar2) <>
2119: nvl(p_rec.ppm_information24, hr_api.g_varchar2) or
2120: nvl(pay_ppm_shd.g_old_rec.ppm_information25, hr_api.g_varchar2) <>
2121: nvl(p_rec.ppm_information25, hr_api.g_varchar2) or
2122: nvl(pay_ppm_shd.g_old_rec.ppm_information26, hr_api.g_varchar2) <>
2123: nvl(p_rec.ppm_information26, hr_api.g_varchar2) or
2124: nvl(pay_ppm_shd.g_old_rec.ppm_information27, hr_api.g_varchar2) <>
2125: nvl(p_rec.ppm_information27, hr_api.g_varchar2) or
2118: nvl(pay_ppm_shd.g_old_rec.ppm_information24, hr_api.g_varchar2) <>
2119: nvl(p_rec.ppm_information24, hr_api.g_varchar2) or
2120: nvl(pay_ppm_shd.g_old_rec.ppm_information25, hr_api.g_varchar2) <>
2121: nvl(p_rec.ppm_information25, hr_api.g_varchar2) or
2122: nvl(pay_ppm_shd.g_old_rec.ppm_information26, hr_api.g_varchar2) <>
2123: nvl(p_rec.ppm_information26, hr_api.g_varchar2) or
2124: nvl(pay_ppm_shd.g_old_rec.ppm_information27, hr_api.g_varchar2) <>
2125: nvl(p_rec.ppm_information27, hr_api.g_varchar2) or
2126: nvl(pay_ppm_shd.g_old_rec.ppm_information28, hr_api.g_varchar2) <>
2119: nvl(p_rec.ppm_information24, hr_api.g_varchar2) or
2120: nvl(pay_ppm_shd.g_old_rec.ppm_information25, hr_api.g_varchar2) <>
2121: nvl(p_rec.ppm_information25, hr_api.g_varchar2) or
2122: nvl(pay_ppm_shd.g_old_rec.ppm_information26, hr_api.g_varchar2) <>
2123: nvl(p_rec.ppm_information26, hr_api.g_varchar2) or
2124: nvl(pay_ppm_shd.g_old_rec.ppm_information27, hr_api.g_varchar2) <>
2125: nvl(p_rec.ppm_information27, hr_api.g_varchar2) or
2126: nvl(pay_ppm_shd.g_old_rec.ppm_information28, hr_api.g_varchar2) <>
2127: nvl(p_rec.ppm_information28, hr_api.g_varchar2) or
2120: nvl(pay_ppm_shd.g_old_rec.ppm_information25, hr_api.g_varchar2) <>
2121: nvl(p_rec.ppm_information25, hr_api.g_varchar2) or
2122: nvl(pay_ppm_shd.g_old_rec.ppm_information26, hr_api.g_varchar2) <>
2123: nvl(p_rec.ppm_information26, hr_api.g_varchar2) or
2124: nvl(pay_ppm_shd.g_old_rec.ppm_information27, hr_api.g_varchar2) <>
2125: nvl(p_rec.ppm_information27, hr_api.g_varchar2) or
2126: nvl(pay_ppm_shd.g_old_rec.ppm_information28, hr_api.g_varchar2) <>
2127: nvl(p_rec.ppm_information28, hr_api.g_varchar2) or
2128: nvl(pay_ppm_shd.g_old_rec.ppm_information29, hr_api.g_varchar2) <>
2121: nvl(p_rec.ppm_information25, hr_api.g_varchar2) or
2122: nvl(pay_ppm_shd.g_old_rec.ppm_information26, hr_api.g_varchar2) <>
2123: nvl(p_rec.ppm_information26, hr_api.g_varchar2) or
2124: nvl(pay_ppm_shd.g_old_rec.ppm_information27, hr_api.g_varchar2) <>
2125: nvl(p_rec.ppm_information27, hr_api.g_varchar2) or
2126: nvl(pay_ppm_shd.g_old_rec.ppm_information28, hr_api.g_varchar2) <>
2127: nvl(p_rec.ppm_information28, hr_api.g_varchar2) or
2128: nvl(pay_ppm_shd.g_old_rec.ppm_information29, hr_api.g_varchar2) <>
2129: nvl(p_rec.ppm_information29, hr_api.g_varchar2) or
2122: nvl(pay_ppm_shd.g_old_rec.ppm_information26, hr_api.g_varchar2) <>
2123: nvl(p_rec.ppm_information26, hr_api.g_varchar2) or
2124: nvl(pay_ppm_shd.g_old_rec.ppm_information27, hr_api.g_varchar2) <>
2125: nvl(p_rec.ppm_information27, hr_api.g_varchar2) or
2126: nvl(pay_ppm_shd.g_old_rec.ppm_information28, hr_api.g_varchar2) <>
2127: nvl(p_rec.ppm_information28, hr_api.g_varchar2) or
2128: nvl(pay_ppm_shd.g_old_rec.ppm_information29, hr_api.g_varchar2) <>
2129: nvl(p_rec.ppm_information29, hr_api.g_varchar2) or
2130: nvl(pay_ppm_shd.g_old_rec.ppm_information30, hr_api.g_varchar2) <>
2123: nvl(p_rec.ppm_information26, hr_api.g_varchar2) or
2124: nvl(pay_ppm_shd.g_old_rec.ppm_information27, hr_api.g_varchar2) <>
2125: nvl(p_rec.ppm_information27, hr_api.g_varchar2) or
2126: nvl(pay_ppm_shd.g_old_rec.ppm_information28, hr_api.g_varchar2) <>
2127: nvl(p_rec.ppm_information28, hr_api.g_varchar2) or
2128: nvl(pay_ppm_shd.g_old_rec.ppm_information29, hr_api.g_varchar2) <>
2129: nvl(p_rec.ppm_information29, hr_api.g_varchar2) or
2130: nvl(pay_ppm_shd.g_old_rec.ppm_information30, hr_api.g_varchar2) <>
2131: nvl(p_rec.ppm_information30, hr_api.g_varchar2) ))
2124: nvl(pay_ppm_shd.g_old_rec.ppm_information27, hr_api.g_varchar2) <>
2125: nvl(p_rec.ppm_information27, hr_api.g_varchar2) or
2126: nvl(pay_ppm_shd.g_old_rec.ppm_information28, hr_api.g_varchar2) <>
2127: nvl(p_rec.ppm_information28, hr_api.g_varchar2) or
2128: nvl(pay_ppm_shd.g_old_rec.ppm_information29, hr_api.g_varchar2) <>
2129: nvl(p_rec.ppm_information29, hr_api.g_varchar2) or
2130: nvl(pay_ppm_shd.g_old_rec.ppm_information30, hr_api.g_varchar2) <>
2131: nvl(p_rec.ppm_information30, hr_api.g_varchar2) ))
2132: or (p_rec.personal_payment_method_id is null) then
2125: nvl(p_rec.ppm_information27, hr_api.g_varchar2) or
2126: nvl(pay_ppm_shd.g_old_rec.ppm_information28, hr_api.g_varchar2) <>
2127: nvl(p_rec.ppm_information28, hr_api.g_varchar2) or
2128: nvl(pay_ppm_shd.g_old_rec.ppm_information29, hr_api.g_varchar2) <>
2129: nvl(p_rec.ppm_information29, hr_api.g_varchar2) or
2130: nvl(pay_ppm_shd.g_old_rec.ppm_information30, hr_api.g_varchar2) <>
2131: nvl(p_rec.ppm_information30, hr_api.g_varchar2) ))
2132: or (p_rec.personal_payment_method_id is null) then
2133: --
2126: nvl(pay_ppm_shd.g_old_rec.ppm_information28, hr_api.g_varchar2) <>
2127: nvl(p_rec.ppm_information28, hr_api.g_varchar2) or
2128: nvl(pay_ppm_shd.g_old_rec.ppm_information29, hr_api.g_varchar2) <>
2129: nvl(p_rec.ppm_information29, hr_api.g_varchar2) or
2130: nvl(pay_ppm_shd.g_old_rec.ppm_information30, hr_api.g_varchar2) <>
2131: nvl(p_rec.ppm_information30, hr_api.g_varchar2) ))
2132: or (p_rec.personal_payment_method_id is null) then
2133: --
2134: -- Only execute the validation if absolutely necessary:
2127: nvl(p_rec.ppm_information28, hr_api.g_varchar2) or
2128: nvl(pay_ppm_shd.g_old_rec.ppm_information29, hr_api.g_varchar2) <>
2129: nvl(p_rec.ppm_information29, hr_api.g_varchar2) or
2130: nvl(pay_ppm_shd.g_old_rec.ppm_information30, hr_api.g_varchar2) <>
2131: nvl(p_rec.ppm_information30, hr_api.g_varchar2) ))
2132: or (p_rec.personal_payment_method_id is null) then
2133: --
2134: -- Only execute the validation if absolutely necessary:
2135: -- a) During update, the structure column value or any
2221: -- Only do the validation if inserting or if values have changed on
2222: -- update.
2223: --
2224: if (p_rec.personal_payment_method_id is not null and (
2225: nvl(p_rec.attribute_category, hr_api.g_varchar2) <>
2226: nvl(l_rec.attribute_category, hr_api.g_varchar2) or
2227: nvl(p_rec.attribute1, hr_api.g_varchar2) <>
2228: nvl(l_rec.attribute1, hr_api.g_varchar2) or
2229: nvl(p_rec.attribute2, hr_api.g_varchar2) <>
2222: -- update.
2223: --
2224: if (p_rec.personal_payment_method_id is not null and (
2225: nvl(p_rec.attribute_category, hr_api.g_varchar2) <>
2226: nvl(l_rec.attribute_category, hr_api.g_varchar2) or
2227: nvl(p_rec.attribute1, hr_api.g_varchar2) <>
2228: nvl(l_rec.attribute1, hr_api.g_varchar2) or
2229: nvl(p_rec.attribute2, hr_api.g_varchar2) <>
2230: nvl(l_rec.attribute2, hr_api.g_varchar2) or
2223: --
2224: if (p_rec.personal_payment_method_id is not null and (
2225: nvl(p_rec.attribute_category, hr_api.g_varchar2) <>
2226: nvl(l_rec.attribute_category, hr_api.g_varchar2) or
2227: nvl(p_rec.attribute1, hr_api.g_varchar2) <>
2228: nvl(l_rec.attribute1, hr_api.g_varchar2) or
2229: nvl(p_rec.attribute2, hr_api.g_varchar2) <>
2230: nvl(l_rec.attribute2, hr_api.g_varchar2) or
2231: nvl(p_rec.attribute3, hr_api.g_varchar2) <>
2224: if (p_rec.personal_payment_method_id is not null and (
2225: nvl(p_rec.attribute_category, hr_api.g_varchar2) <>
2226: nvl(l_rec.attribute_category, hr_api.g_varchar2) or
2227: nvl(p_rec.attribute1, hr_api.g_varchar2) <>
2228: nvl(l_rec.attribute1, hr_api.g_varchar2) or
2229: nvl(p_rec.attribute2, hr_api.g_varchar2) <>
2230: nvl(l_rec.attribute2, hr_api.g_varchar2) or
2231: nvl(p_rec.attribute3, hr_api.g_varchar2) <>
2232: nvl(l_rec.attribute3, hr_api.g_varchar2) or
2225: nvl(p_rec.attribute_category, hr_api.g_varchar2) <>
2226: nvl(l_rec.attribute_category, hr_api.g_varchar2) or
2227: nvl(p_rec.attribute1, hr_api.g_varchar2) <>
2228: nvl(l_rec.attribute1, hr_api.g_varchar2) or
2229: nvl(p_rec.attribute2, hr_api.g_varchar2) <>
2230: nvl(l_rec.attribute2, hr_api.g_varchar2) or
2231: nvl(p_rec.attribute3, hr_api.g_varchar2) <>
2232: nvl(l_rec.attribute3, hr_api.g_varchar2) or
2233: nvl(p_rec.attribute4, hr_api.g_varchar2) <>
2226: nvl(l_rec.attribute_category, hr_api.g_varchar2) or
2227: nvl(p_rec.attribute1, hr_api.g_varchar2) <>
2228: nvl(l_rec.attribute1, hr_api.g_varchar2) or
2229: nvl(p_rec.attribute2, hr_api.g_varchar2) <>
2230: nvl(l_rec.attribute2, hr_api.g_varchar2) or
2231: nvl(p_rec.attribute3, hr_api.g_varchar2) <>
2232: nvl(l_rec.attribute3, hr_api.g_varchar2) or
2233: nvl(p_rec.attribute4, hr_api.g_varchar2) <>
2234: nvl(l_rec.attribute4, hr_api.g_varchar2) or
2227: nvl(p_rec.attribute1, hr_api.g_varchar2) <>
2228: nvl(l_rec.attribute1, hr_api.g_varchar2) or
2229: nvl(p_rec.attribute2, hr_api.g_varchar2) <>
2230: nvl(l_rec.attribute2, hr_api.g_varchar2) or
2231: nvl(p_rec.attribute3, hr_api.g_varchar2) <>
2232: nvl(l_rec.attribute3, hr_api.g_varchar2) or
2233: nvl(p_rec.attribute4, hr_api.g_varchar2) <>
2234: nvl(l_rec.attribute4, hr_api.g_varchar2) or
2235: nvl(p_rec.attribute5, hr_api.g_varchar2) <>
2228: nvl(l_rec.attribute1, hr_api.g_varchar2) or
2229: nvl(p_rec.attribute2, hr_api.g_varchar2) <>
2230: nvl(l_rec.attribute2, hr_api.g_varchar2) or
2231: nvl(p_rec.attribute3, hr_api.g_varchar2) <>
2232: nvl(l_rec.attribute3, hr_api.g_varchar2) or
2233: nvl(p_rec.attribute4, hr_api.g_varchar2) <>
2234: nvl(l_rec.attribute4, hr_api.g_varchar2) or
2235: nvl(p_rec.attribute5, hr_api.g_varchar2) <>
2236: nvl(l_rec.attribute5, hr_api.g_varchar2) or
2229: nvl(p_rec.attribute2, hr_api.g_varchar2) <>
2230: nvl(l_rec.attribute2, hr_api.g_varchar2) or
2231: nvl(p_rec.attribute3, hr_api.g_varchar2) <>
2232: nvl(l_rec.attribute3, hr_api.g_varchar2) or
2233: nvl(p_rec.attribute4, hr_api.g_varchar2) <>
2234: nvl(l_rec.attribute4, hr_api.g_varchar2) or
2235: nvl(p_rec.attribute5, hr_api.g_varchar2) <>
2236: nvl(l_rec.attribute5, hr_api.g_varchar2) or
2237: nvl(p_rec.attribute6, hr_api.g_varchar2) <>
2230: nvl(l_rec.attribute2, hr_api.g_varchar2) or
2231: nvl(p_rec.attribute3, hr_api.g_varchar2) <>
2232: nvl(l_rec.attribute3, hr_api.g_varchar2) or
2233: nvl(p_rec.attribute4, hr_api.g_varchar2) <>
2234: nvl(l_rec.attribute4, hr_api.g_varchar2) or
2235: nvl(p_rec.attribute5, hr_api.g_varchar2) <>
2236: nvl(l_rec.attribute5, hr_api.g_varchar2) or
2237: nvl(p_rec.attribute6, hr_api.g_varchar2) <>
2238: nvl(l_rec.attribute6, hr_api.g_varchar2) or
2231: nvl(p_rec.attribute3, hr_api.g_varchar2) <>
2232: nvl(l_rec.attribute3, hr_api.g_varchar2) or
2233: nvl(p_rec.attribute4, hr_api.g_varchar2) <>
2234: nvl(l_rec.attribute4, hr_api.g_varchar2) or
2235: nvl(p_rec.attribute5, hr_api.g_varchar2) <>
2236: nvl(l_rec.attribute5, hr_api.g_varchar2) or
2237: nvl(p_rec.attribute6, hr_api.g_varchar2) <>
2238: nvl(l_rec.attribute6, hr_api.g_varchar2) or
2239: nvl(p_rec.attribute7, hr_api.g_varchar2) <>
2232: nvl(l_rec.attribute3, hr_api.g_varchar2) or
2233: nvl(p_rec.attribute4, hr_api.g_varchar2) <>
2234: nvl(l_rec.attribute4, hr_api.g_varchar2) or
2235: nvl(p_rec.attribute5, hr_api.g_varchar2) <>
2236: nvl(l_rec.attribute5, hr_api.g_varchar2) or
2237: nvl(p_rec.attribute6, hr_api.g_varchar2) <>
2238: nvl(l_rec.attribute6, hr_api.g_varchar2) or
2239: nvl(p_rec.attribute7, hr_api.g_varchar2) <>
2240: nvl(l_rec.attribute7, hr_api.g_varchar2) or
2233: nvl(p_rec.attribute4, hr_api.g_varchar2) <>
2234: nvl(l_rec.attribute4, hr_api.g_varchar2) or
2235: nvl(p_rec.attribute5, hr_api.g_varchar2) <>
2236: nvl(l_rec.attribute5, hr_api.g_varchar2) or
2237: nvl(p_rec.attribute6, hr_api.g_varchar2) <>
2238: nvl(l_rec.attribute6, hr_api.g_varchar2) or
2239: nvl(p_rec.attribute7, hr_api.g_varchar2) <>
2240: nvl(l_rec.attribute7, hr_api.g_varchar2) or
2241: nvl(p_rec.attribute8, hr_api.g_varchar2) <>
2234: nvl(l_rec.attribute4, hr_api.g_varchar2) or
2235: nvl(p_rec.attribute5, hr_api.g_varchar2) <>
2236: nvl(l_rec.attribute5, hr_api.g_varchar2) or
2237: nvl(p_rec.attribute6, hr_api.g_varchar2) <>
2238: nvl(l_rec.attribute6, hr_api.g_varchar2) or
2239: nvl(p_rec.attribute7, hr_api.g_varchar2) <>
2240: nvl(l_rec.attribute7, hr_api.g_varchar2) or
2241: nvl(p_rec.attribute8, hr_api.g_varchar2) <>
2242: nvl(l_rec.attribute8, hr_api.g_varchar2) or
2235: nvl(p_rec.attribute5, hr_api.g_varchar2) <>
2236: nvl(l_rec.attribute5, hr_api.g_varchar2) or
2237: nvl(p_rec.attribute6, hr_api.g_varchar2) <>
2238: nvl(l_rec.attribute6, hr_api.g_varchar2) or
2239: nvl(p_rec.attribute7, hr_api.g_varchar2) <>
2240: nvl(l_rec.attribute7, hr_api.g_varchar2) or
2241: nvl(p_rec.attribute8, hr_api.g_varchar2) <>
2242: nvl(l_rec.attribute8, hr_api.g_varchar2) or
2243: nvl(p_rec.attribute9, hr_api.g_varchar2) <>
2236: nvl(l_rec.attribute5, hr_api.g_varchar2) or
2237: nvl(p_rec.attribute6, hr_api.g_varchar2) <>
2238: nvl(l_rec.attribute6, hr_api.g_varchar2) or
2239: nvl(p_rec.attribute7, hr_api.g_varchar2) <>
2240: nvl(l_rec.attribute7, hr_api.g_varchar2) or
2241: nvl(p_rec.attribute8, hr_api.g_varchar2) <>
2242: nvl(l_rec.attribute8, hr_api.g_varchar2) or
2243: nvl(p_rec.attribute9, hr_api.g_varchar2) <>
2244: nvl(l_rec.attribute9, hr_api.g_varchar2) or
2237: nvl(p_rec.attribute6, hr_api.g_varchar2) <>
2238: nvl(l_rec.attribute6, hr_api.g_varchar2) or
2239: nvl(p_rec.attribute7, hr_api.g_varchar2) <>
2240: nvl(l_rec.attribute7, hr_api.g_varchar2) or
2241: nvl(p_rec.attribute8, hr_api.g_varchar2) <>
2242: nvl(l_rec.attribute8, hr_api.g_varchar2) or
2243: nvl(p_rec.attribute9, hr_api.g_varchar2) <>
2244: nvl(l_rec.attribute9, hr_api.g_varchar2) or
2245: nvl(p_rec.attribute10, hr_api.g_varchar2) <>
2238: nvl(l_rec.attribute6, hr_api.g_varchar2) or
2239: nvl(p_rec.attribute7, hr_api.g_varchar2) <>
2240: nvl(l_rec.attribute7, hr_api.g_varchar2) or
2241: nvl(p_rec.attribute8, hr_api.g_varchar2) <>
2242: nvl(l_rec.attribute8, hr_api.g_varchar2) or
2243: nvl(p_rec.attribute9, hr_api.g_varchar2) <>
2244: nvl(l_rec.attribute9, hr_api.g_varchar2) or
2245: nvl(p_rec.attribute10, hr_api.g_varchar2) <>
2246: nvl(l_rec.attribute10, hr_api.g_varchar2) or
2239: nvl(p_rec.attribute7, hr_api.g_varchar2) <>
2240: nvl(l_rec.attribute7, hr_api.g_varchar2) or
2241: nvl(p_rec.attribute8, hr_api.g_varchar2) <>
2242: nvl(l_rec.attribute8, hr_api.g_varchar2) or
2243: nvl(p_rec.attribute9, hr_api.g_varchar2) <>
2244: nvl(l_rec.attribute9, hr_api.g_varchar2) or
2245: nvl(p_rec.attribute10, hr_api.g_varchar2) <>
2246: nvl(l_rec.attribute10, hr_api.g_varchar2) or
2247: nvl(p_rec.attribute11, hr_api.g_varchar2) <>
2240: nvl(l_rec.attribute7, hr_api.g_varchar2) or
2241: nvl(p_rec.attribute8, hr_api.g_varchar2) <>
2242: nvl(l_rec.attribute8, hr_api.g_varchar2) or
2243: nvl(p_rec.attribute9, hr_api.g_varchar2) <>
2244: nvl(l_rec.attribute9, hr_api.g_varchar2) or
2245: nvl(p_rec.attribute10, hr_api.g_varchar2) <>
2246: nvl(l_rec.attribute10, hr_api.g_varchar2) or
2247: nvl(p_rec.attribute11, hr_api.g_varchar2) <>
2248: nvl(l_rec.attribute11, hr_api.g_varchar2) or
2241: nvl(p_rec.attribute8, hr_api.g_varchar2) <>
2242: nvl(l_rec.attribute8, hr_api.g_varchar2) or
2243: nvl(p_rec.attribute9, hr_api.g_varchar2) <>
2244: nvl(l_rec.attribute9, hr_api.g_varchar2) or
2245: nvl(p_rec.attribute10, hr_api.g_varchar2) <>
2246: nvl(l_rec.attribute10, hr_api.g_varchar2) or
2247: nvl(p_rec.attribute11, hr_api.g_varchar2) <>
2248: nvl(l_rec.attribute11, hr_api.g_varchar2) or
2249: nvl(p_rec.attribute12, hr_api.g_varchar2) <>
2242: nvl(l_rec.attribute8, hr_api.g_varchar2) or
2243: nvl(p_rec.attribute9, hr_api.g_varchar2) <>
2244: nvl(l_rec.attribute9, hr_api.g_varchar2) or
2245: nvl(p_rec.attribute10, hr_api.g_varchar2) <>
2246: nvl(l_rec.attribute10, hr_api.g_varchar2) or
2247: nvl(p_rec.attribute11, hr_api.g_varchar2) <>
2248: nvl(l_rec.attribute11, hr_api.g_varchar2) or
2249: nvl(p_rec.attribute12, hr_api.g_varchar2) <>
2250: nvl(l_rec.attribute12, hr_api.g_varchar2) or
2243: nvl(p_rec.attribute9, hr_api.g_varchar2) <>
2244: nvl(l_rec.attribute9, hr_api.g_varchar2) or
2245: nvl(p_rec.attribute10, hr_api.g_varchar2) <>
2246: nvl(l_rec.attribute10, hr_api.g_varchar2) or
2247: nvl(p_rec.attribute11, hr_api.g_varchar2) <>
2248: nvl(l_rec.attribute11, hr_api.g_varchar2) or
2249: nvl(p_rec.attribute12, hr_api.g_varchar2) <>
2250: nvl(l_rec.attribute12, hr_api.g_varchar2) or
2251: nvl(p_rec.attribute13, hr_api.g_varchar2) <>
2244: nvl(l_rec.attribute9, hr_api.g_varchar2) or
2245: nvl(p_rec.attribute10, hr_api.g_varchar2) <>
2246: nvl(l_rec.attribute10, hr_api.g_varchar2) or
2247: nvl(p_rec.attribute11, hr_api.g_varchar2) <>
2248: nvl(l_rec.attribute11, hr_api.g_varchar2) or
2249: nvl(p_rec.attribute12, hr_api.g_varchar2) <>
2250: nvl(l_rec.attribute12, hr_api.g_varchar2) or
2251: nvl(p_rec.attribute13, hr_api.g_varchar2) <>
2252: nvl(l_rec.attribute13, hr_api.g_varchar2) or
2245: nvl(p_rec.attribute10, hr_api.g_varchar2) <>
2246: nvl(l_rec.attribute10, hr_api.g_varchar2) or
2247: nvl(p_rec.attribute11, hr_api.g_varchar2) <>
2248: nvl(l_rec.attribute11, hr_api.g_varchar2) or
2249: nvl(p_rec.attribute12, hr_api.g_varchar2) <>
2250: nvl(l_rec.attribute12, hr_api.g_varchar2) or
2251: nvl(p_rec.attribute13, hr_api.g_varchar2) <>
2252: nvl(l_rec.attribute13, hr_api.g_varchar2) or
2253: nvl(p_rec.attribute14, hr_api.g_varchar2) <>
2246: nvl(l_rec.attribute10, hr_api.g_varchar2) or
2247: nvl(p_rec.attribute11, hr_api.g_varchar2) <>
2248: nvl(l_rec.attribute11, hr_api.g_varchar2) or
2249: nvl(p_rec.attribute12, hr_api.g_varchar2) <>
2250: nvl(l_rec.attribute12, hr_api.g_varchar2) or
2251: nvl(p_rec.attribute13, hr_api.g_varchar2) <>
2252: nvl(l_rec.attribute13, hr_api.g_varchar2) or
2253: nvl(p_rec.attribute14, hr_api.g_varchar2) <>
2254: nvl(l_rec.attribute14, hr_api.g_varchar2) or
2247: nvl(p_rec.attribute11, hr_api.g_varchar2) <>
2248: nvl(l_rec.attribute11, hr_api.g_varchar2) or
2249: nvl(p_rec.attribute12, hr_api.g_varchar2) <>
2250: nvl(l_rec.attribute12, hr_api.g_varchar2) or
2251: nvl(p_rec.attribute13, hr_api.g_varchar2) <>
2252: nvl(l_rec.attribute13, hr_api.g_varchar2) or
2253: nvl(p_rec.attribute14, hr_api.g_varchar2) <>
2254: nvl(l_rec.attribute14, hr_api.g_varchar2) or
2255: nvl(p_rec.attribute15, hr_api.g_varchar2) <>
2248: nvl(l_rec.attribute11, hr_api.g_varchar2) or
2249: nvl(p_rec.attribute12, hr_api.g_varchar2) <>
2250: nvl(l_rec.attribute12, hr_api.g_varchar2) or
2251: nvl(p_rec.attribute13, hr_api.g_varchar2) <>
2252: nvl(l_rec.attribute13, hr_api.g_varchar2) or
2253: nvl(p_rec.attribute14, hr_api.g_varchar2) <>
2254: nvl(l_rec.attribute14, hr_api.g_varchar2) or
2255: nvl(p_rec.attribute15, hr_api.g_varchar2) <>
2256: nvl(l_rec.attribute15, hr_api.g_varchar2) or
2249: nvl(p_rec.attribute12, hr_api.g_varchar2) <>
2250: nvl(l_rec.attribute12, hr_api.g_varchar2) or
2251: nvl(p_rec.attribute13, hr_api.g_varchar2) <>
2252: nvl(l_rec.attribute13, hr_api.g_varchar2) or
2253: nvl(p_rec.attribute14, hr_api.g_varchar2) <>
2254: nvl(l_rec.attribute14, hr_api.g_varchar2) or
2255: nvl(p_rec.attribute15, hr_api.g_varchar2) <>
2256: nvl(l_rec.attribute15, hr_api.g_varchar2) or
2257: nvl(p_rec.attribute16, hr_api.g_varchar2) <>
2250: nvl(l_rec.attribute12, hr_api.g_varchar2) or
2251: nvl(p_rec.attribute13, hr_api.g_varchar2) <>
2252: nvl(l_rec.attribute13, hr_api.g_varchar2) or
2253: nvl(p_rec.attribute14, hr_api.g_varchar2) <>
2254: nvl(l_rec.attribute14, hr_api.g_varchar2) or
2255: nvl(p_rec.attribute15, hr_api.g_varchar2) <>
2256: nvl(l_rec.attribute15, hr_api.g_varchar2) or
2257: nvl(p_rec.attribute16, hr_api.g_varchar2) <>
2258: nvl(l_rec.attribute16, hr_api.g_varchar2) or
2251: nvl(p_rec.attribute13, hr_api.g_varchar2) <>
2252: nvl(l_rec.attribute13, hr_api.g_varchar2) or
2253: nvl(p_rec.attribute14, hr_api.g_varchar2) <>
2254: nvl(l_rec.attribute14, hr_api.g_varchar2) or
2255: nvl(p_rec.attribute15, hr_api.g_varchar2) <>
2256: nvl(l_rec.attribute15, hr_api.g_varchar2) or
2257: nvl(p_rec.attribute16, hr_api.g_varchar2) <>
2258: nvl(l_rec.attribute16, hr_api.g_varchar2) or
2259: nvl(p_rec.attribute17, hr_api.g_varchar2) <>
2252: nvl(l_rec.attribute13, hr_api.g_varchar2) or
2253: nvl(p_rec.attribute14, hr_api.g_varchar2) <>
2254: nvl(l_rec.attribute14, hr_api.g_varchar2) or
2255: nvl(p_rec.attribute15, hr_api.g_varchar2) <>
2256: nvl(l_rec.attribute15, hr_api.g_varchar2) or
2257: nvl(p_rec.attribute16, hr_api.g_varchar2) <>
2258: nvl(l_rec.attribute16, hr_api.g_varchar2) or
2259: nvl(p_rec.attribute17, hr_api.g_varchar2) <>
2260: nvl(l_rec.attribute17, hr_api.g_varchar2) or
2253: nvl(p_rec.attribute14, hr_api.g_varchar2) <>
2254: nvl(l_rec.attribute14, hr_api.g_varchar2) or
2255: nvl(p_rec.attribute15, hr_api.g_varchar2) <>
2256: nvl(l_rec.attribute15, hr_api.g_varchar2) or
2257: nvl(p_rec.attribute16, hr_api.g_varchar2) <>
2258: nvl(l_rec.attribute16, hr_api.g_varchar2) or
2259: nvl(p_rec.attribute17, hr_api.g_varchar2) <>
2260: nvl(l_rec.attribute17, hr_api.g_varchar2) or
2261: nvl(p_rec.attribute18, hr_api.g_varchar2) <>
2254: nvl(l_rec.attribute14, hr_api.g_varchar2) or
2255: nvl(p_rec.attribute15, hr_api.g_varchar2) <>
2256: nvl(l_rec.attribute15, hr_api.g_varchar2) or
2257: nvl(p_rec.attribute16, hr_api.g_varchar2) <>
2258: nvl(l_rec.attribute16, hr_api.g_varchar2) or
2259: nvl(p_rec.attribute17, hr_api.g_varchar2) <>
2260: nvl(l_rec.attribute17, hr_api.g_varchar2) or
2261: nvl(p_rec.attribute18, hr_api.g_varchar2) <>
2262: nvl(l_rec.attribute18, hr_api.g_varchar2) or
2255: nvl(p_rec.attribute15, hr_api.g_varchar2) <>
2256: nvl(l_rec.attribute15, hr_api.g_varchar2) or
2257: nvl(p_rec.attribute16, hr_api.g_varchar2) <>
2258: nvl(l_rec.attribute16, hr_api.g_varchar2) or
2259: nvl(p_rec.attribute17, hr_api.g_varchar2) <>
2260: nvl(l_rec.attribute17, hr_api.g_varchar2) or
2261: nvl(p_rec.attribute18, hr_api.g_varchar2) <>
2262: nvl(l_rec.attribute18, hr_api.g_varchar2) or
2263: nvl(p_rec.attribute19, hr_api.g_varchar2) <>
2256: nvl(l_rec.attribute15, hr_api.g_varchar2) or
2257: nvl(p_rec.attribute16, hr_api.g_varchar2) <>
2258: nvl(l_rec.attribute16, hr_api.g_varchar2) or
2259: nvl(p_rec.attribute17, hr_api.g_varchar2) <>
2260: nvl(l_rec.attribute17, hr_api.g_varchar2) or
2261: nvl(p_rec.attribute18, hr_api.g_varchar2) <>
2262: nvl(l_rec.attribute18, hr_api.g_varchar2) or
2263: nvl(p_rec.attribute19, hr_api.g_varchar2) <>
2264: nvl(l_rec.attribute19, hr_api.g_varchar2) or
2257: nvl(p_rec.attribute16, hr_api.g_varchar2) <>
2258: nvl(l_rec.attribute16, hr_api.g_varchar2) or
2259: nvl(p_rec.attribute17, hr_api.g_varchar2) <>
2260: nvl(l_rec.attribute17, hr_api.g_varchar2) or
2261: nvl(p_rec.attribute18, hr_api.g_varchar2) <>
2262: nvl(l_rec.attribute18, hr_api.g_varchar2) or
2263: nvl(p_rec.attribute19, hr_api.g_varchar2) <>
2264: nvl(l_rec.attribute19, hr_api.g_varchar2) or
2265: nvl(p_rec.attribute20, hr_api.g_varchar2) <>
2258: nvl(l_rec.attribute16, hr_api.g_varchar2) or
2259: nvl(p_rec.attribute17, hr_api.g_varchar2) <>
2260: nvl(l_rec.attribute17, hr_api.g_varchar2) or
2261: nvl(p_rec.attribute18, hr_api.g_varchar2) <>
2262: nvl(l_rec.attribute18, hr_api.g_varchar2) or
2263: nvl(p_rec.attribute19, hr_api.g_varchar2) <>
2264: nvl(l_rec.attribute19, hr_api.g_varchar2) or
2265: nvl(p_rec.attribute20, hr_api.g_varchar2) <>
2266: nvl(l_rec.attribute20, hr_api.g_varchar2))) or
2259: nvl(p_rec.attribute17, hr_api.g_varchar2) <>
2260: nvl(l_rec.attribute17, hr_api.g_varchar2) or
2261: nvl(p_rec.attribute18, hr_api.g_varchar2) <>
2262: nvl(l_rec.attribute18, hr_api.g_varchar2) or
2263: nvl(p_rec.attribute19, hr_api.g_varchar2) <>
2264: nvl(l_rec.attribute19, hr_api.g_varchar2) or
2265: nvl(p_rec.attribute20, hr_api.g_varchar2) <>
2266: nvl(l_rec.attribute20, hr_api.g_varchar2))) or
2267: p_rec.personal_payment_method_id is null
2260: nvl(l_rec.attribute17, hr_api.g_varchar2) or
2261: nvl(p_rec.attribute18, hr_api.g_varchar2) <>
2262: nvl(l_rec.attribute18, hr_api.g_varchar2) or
2263: nvl(p_rec.attribute19, hr_api.g_varchar2) <>
2264: nvl(l_rec.attribute19, hr_api.g_varchar2) or
2265: nvl(p_rec.attribute20, hr_api.g_varchar2) <>
2266: nvl(l_rec.attribute20, hr_api.g_varchar2))) or
2267: p_rec.personal_payment_method_id is null
2268: then
2261: nvl(p_rec.attribute18, hr_api.g_varchar2) <>
2262: nvl(l_rec.attribute18, hr_api.g_varchar2) or
2263: nvl(p_rec.attribute19, hr_api.g_varchar2) <>
2264: nvl(l_rec.attribute19, hr_api.g_varchar2) or
2265: nvl(p_rec.attribute20, hr_api.g_varchar2) <>
2266: nvl(l_rec.attribute20, hr_api.g_varchar2))) or
2267: p_rec.personal_payment_method_id is null
2268: then
2269: hr_utility.set_location(l_proc, 20);
2262: nvl(l_rec.attribute18, hr_api.g_varchar2) or
2263: nvl(p_rec.attribute19, hr_api.g_varchar2) <>
2264: nvl(l_rec.attribute19, hr_api.g_varchar2) or
2265: nvl(p_rec.attribute20, hr_api.g_varchar2) <>
2266: nvl(l_rec.attribute20, hr_api.g_varchar2))) or
2267: p_rec.personal_payment_method_id is null
2268: then
2269: hr_utility.set_location(l_proc, 20);
2270: hr_dflex_utility.ins_or_upd_descflex_attribs