eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_PA_WHATIF_PROCESS dependencies on PER_ALL_PEOPLE_F

Line 421: from per_all_people_f

417: ler.effective_start_date and ler.effective_end_date;
418:
419: Cursor c_person_data is
420: select date_of_birth,original_date_of_hire hire_date
421: from per_all_people_f
422: where person_id = p_person_id
423: and business_group_id = p_business_group_id
424: and p_effective_date between
425: effective_start_date and effective_end_date;

Line 527: -- Columns for table PER_ALL_PEOPLE_F

523: l_ASS_ATTRIBUTE8 VARCHAR2(150);
524: l_ASS_ATTRIBUTE9 VARCHAR2(150);
525:
526: --
527: -- Columns for table PER_ALL_PEOPLE_F
528: --
529: l_STUDENT_STATUS varchar2(60);
530: l_MARITAL_STATUS varchar2(60);
531: l_DATE_OF_DEATH date;

Line 1004: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and

1000: ELSIF C1.api_name = 'PER_ALL_ASSIGNMENTS_F' and
1001: C2.name = 'ASS_ATTRIBUTE9' then
1002: l_ASS_ATTRIBUTE9 := l_field_val;
1003:
1004: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and
1005: C2.name = 'BENEFIT_GROUP_ID' then
1006: l_BENEFIT_GROUP_ID := l_field_val;
1007: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and
1008: C2.name = 'COORD_BEN_MED_PLN_NO' then

Line 1007: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and

1003:
1004: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and
1005: C2.name = 'BENEFIT_GROUP_ID' then
1006: l_BENEFIT_GROUP_ID := l_field_val;
1007: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and
1008: C2.name = 'COORD_BEN_MED_PLN_NO' then
1009: l_COORD_BEN_MED_PLN_NO := l_field_val;
1010: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and
1011: C2.name = 'COORD_BEN_NO_CVG_FLAG' then

Line 1010: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and

1006: l_BENEFIT_GROUP_ID := l_field_val;
1007: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and
1008: C2.name = 'COORD_BEN_MED_PLN_NO' then
1009: l_COORD_BEN_MED_PLN_NO := l_field_val;
1010: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and
1011: C2.name = 'COORD_BEN_NO_CVG_FLAG' then
1012: l_COORD_BEN_NO_CVG_FLAG := l_field_val;
1013: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and
1014: C2.name = 'DATE_OF_BIRTH' then

Line 1013: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and

1009: l_COORD_BEN_MED_PLN_NO := l_field_val;
1010: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and
1011: C2.name = 'COORD_BEN_NO_CVG_FLAG' then
1012: l_COORD_BEN_NO_CVG_FLAG := l_field_val;
1013: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and
1014: C2.name = 'DATE_OF_BIRTH' then
1015: l_DATE_OF_BIRTH := l_field_val;
1016: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and
1017: C2.name = 'DATE_OF_DEATH' then

Line 1016: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and

1012: l_COORD_BEN_NO_CVG_FLAG := l_field_val;
1013: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and
1014: C2.name = 'DATE_OF_BIRTH' then
1015: l_DATE_OF_BIRTH := l_field_val;
1016: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and
1017: C2.name = 'DATE_OF_DEATH' then
1018: l_DATE_OF_DEATH := l_field_val;
1019: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and
1020: C2.name = 'MARITAL_STATUS' then

Line 1019: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and

1015: l_DATE_OF_BIRTH := l_field_val;
1016: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and
1017: C2.name = 'DATE_OF_DEATH' then
1018: l_DATE_OF_DEATH := l_field_val;
1019: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and
1020: C2.name = 'MARITAL_STATUS' then
1021: l_MARITAL_STATUS := l_field_val;
1022: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and
1023: C2.name = 'ON_MILITARY_SERVICE' then

Line 1022: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and

1018: l_DATE_OF_DEATH := l_field_val;
1019: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and
1020: C2.name = 'MARITAL_STATUS' then
1021: l_MARITAL_STATUS := l_field_val;
1022: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and
1023: C2.name = 'ON_MILITARY_SERVICE' then
1024: l_ON_MILITARY_SERVICE := l_field_val;
1025: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and
1026: C2.name = 'REGISTERED_DISABLED_FLAG' then

Line 1025: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and

1021: l_MARITAL_STATUS := l_field_val;
1022: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and
1023: C2.name = 'ON_MILITARY_SERVICE' then
1024: l_ON_MILITARY_SERVICE := l_field_val;
1025: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and
1026: C2.name = 'REGISTERED_DISABLED_FLAG' then
1027: l_REGISTERED_DISABLED_FLAG := l_field_val;
1028: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and
1029: C2.name = 'STUDENT_STATUS' then

Line 1028: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and

1024: l_ON_MILITARY_SERVICE := l_field_val;
1025: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and
1026: C2.name = 'REGISTERED_DISABLED_FLAG' then
1027: l_REGISTERED_DISABLED_FLAG := l_field_val;
1028: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and
1029: C2.name = 'STUDENT_STATUS' then
1030: l_STUDENT_STATUS := l_field_val;
1031: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and
1032: C2.name = 'USES_TOBACCO_FLAG' then

Line 1031: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and

1027: l_REGISTERED_DISABLED_FLAG := l_field_val;
1028: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and
1029: C2.name = 'STUDENT_STATUS' then
1030: l_STUDENT_STATUS := l_field_val;
1031: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and
1032: C2.name = 'USES_TOBACCO_FLAG' then
1033: l_USES_TOBACCO_FLAG := l_field_val;
1034: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and
1035: C2.name = 'PER_INFORMATION10' then

Line 1034: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and

1030: l_STUDENT_STATUS := l_field_val;
1031: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and
1032: C2.name = 'USES_TOBACCO_FLAG' then
1033: l_USES_TOBACCO_FLAG := l_field_val;
1034: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and
1035: C2.name = 'PER_INFORMATION10' then
1036: l_PER_INFORMATION10 := l_field_val;
1037:
1038: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and

Line 1038: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and

1034: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and
1035: C2.name = 'PER_INFORMATION10' then
1036: l_PER_INFORMATION10 := l_field_val;
1037:
1038: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and
1039: C2.name = 'DPDNT_VLNTRY_SVCE_FLAG' then
1040: l_DPDNT_VLNTRY_SVCE_FLAG := l_field_val;
1041:
1042: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and

Line 1042: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and

1038: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and
1039: C2.name = 'DPDNT_VLNTRY_SVCE_FLAG' then
1040: l_DPDNT_VLNTRY_SVCE_FLAG := l_field_val;
1041:
1042: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and
1043: C2.name = 'RECEIPT_OF_DEATH_CERT_DATE' then
1044: l_RECEIPT_OF_DEATH_CERT_DATE := l_field_val;
1045:
1046: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and

Line 1046: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and

1042: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and
1043: C2.name = 'RECEIPT_OF_DEATH_CERT_DATE' then
1044: l_RECEIPT_OF_DEATH_CERT_DATE := l_field_val;
1045:
1046: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and
1047: C2.name = 'SEX' then
1048: l_SEX := l_field_val;
1049:
1050: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and

Line 1050: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and

1046: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and
1047: C2.name = 'SEX' then
1048: l_SEX := l_field_val;
1049:
1050: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and
1051: C2.name = 'ATTRIBUTE1' then
1052: l_ATTRIBUTE1 := l_field_val;
1053:
1054: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and

Line 1054: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and

1050: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and
1051: C2.name = 'ATTRIBUTE1' then
1052: l_ATTRIBUTE1 := l_field_val;
1053:
1054: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and
1055: C2.name = 'ATTRIBUTE10' then
1056: l_ATTRIBUTE10 := l_field_val;
1057:
1058: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and

Line 1058: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and

1054: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and
1055: C2.name = 'ATTRIBUTE10' then
1056: l_ATTRIBUTE10 := l_field_val;
1057:
1058: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and
1059: C2.name = 'ATTRIBUTE11' then
1060: l_ATTRIBUTE11 := l_field_val;
1061:
1062: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and

Line 1062: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and

1058: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and
1059: C2.name = 'ATTRIBUTE11' then
1060: l_ATTRIBUTE11 := l_field_val;
1061:
1062: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and
1063: C2.name = 'ATTRIBUTE12' then
1064: l_ATTRIBUTE12 := l_field_val;
1065:
1066: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and

Line 1066: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and

1062: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and
1063: C2.name = 'ATTRIBUTE12' then
1064: l_ATTRIBUTE12 := l_field_val;
1065:
1066: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and
1067: C2.name = 'ATTRIBUTE13' then
1068: l_ATTRIBUTE13 := l_field_val;
1069:
1070: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and

Line 1070: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and

1066: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and
1067: C2.name = 'ATTRIBUTE13' then
1068: l_ATTRIBUTE13 := l_field_val;
1069:
1070: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and
1071: C2.name = 'ATTRIBUTE14' then
1072: l_ATTRIBUTE14 := l_field_val;
1073:
1074: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and

Line 1074: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and

1070: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and
1071: C2.name = 'ATTRIBUTE14' then
1072: l_ATTRIBUTE14 := l_field_val;
1073:
1074: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and
1075: C2.name = 'ATTRIBUTE15' then
1076: l_ATTRIBUTE15 := l_field_val;
1077:
1078: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and

Line 1078: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and

1074: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and
1075: C2.name = 'ATTRIBUTE15' then
1076: l_ATTRIBUTE15 := l_field_val;
1077:
1078: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and
1079: C2.name = 'ATTRIBUTE16' then
1080: l_ATTRIBUTE16 := l_field_val;
1081:
1082: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and

Line 1082: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and

1078: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and
1079: C2.name = 'ATTRIBUTE16' then
1080: l_ATTRIBUTE16 := l_field_val;
1081:
1082: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and
1083: C2.name = 'ATTRIBUTE17' then
1084: l_ATTRIBUTE17 := l_field_val;
1085:
1086: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and

Line 1086: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and

1082: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and
1083: C2.name = 'ATTRIBUTE17' then
1084: l_ATTRIBUTE17 := l_field_val;
1085:
1086: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and
1087: C2.name = 'ATTRIBUTE18' then
1088: l_ATTRIBUTE18 := l_field_val;
1089:
1090: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and

Line 1090: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and

1086: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and
1087: C2.name = 'ATTRIBUTE18' then
1088: l_ATTRIBUTE18 := l_field_val;
1089:
1090: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and
1091: C2.name = 'ATTRIBUTE19' then
1092: l_ATTRIBUTE19 := l_field_val;
1093:
1094: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and

Line 1094: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and

1090: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and
1091: C2.name = 'ATTRIBUTE19' then
1092: l_ATTRIBUTE19 := l_field_val;
1093:
1094: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and
1095: C2.name = 'ATTRIBUTE2' then
1096: l_ATTRIBUTE2 := l_field_val;
1097:
1098: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and

Line 1098: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and

1094: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and
1095: C2.name = 'ATTRIBUTE2' then
1096: l_ATTRIBUTE2 := l_field_val;
1097:
1098: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and
1099: C2.name = 'ATTRIBUTE20' then
1100: l_ATTRIBUTE20 := l_field_val;
1101:
1102: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and

Line 1102: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and

1098: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and
1099: C2.name = 'ATTRIBUTE20' then
1100: l_ATTRIBUTE20 := l_field_val;
1101:
1102: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and
1103: C2.name = 'ATTRIBUTE21' then
1104: l_ATTRIBUTE21 := l_field_val;
1105:
1106: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and

Line 1106: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and

1102: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and
1103: C2.name = 'ATTRIBUTE21' then
1104: l_ATTRIBUTE21 := l_field_val;
1105:
1106: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and
1107: C2.name = 'ATTRIBUTE22' then
1108: l_ATTRIBUTE22 := l_field_val;
1109:
1110: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and

Line 1110: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and

1106: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and
1107: C2.name = 'ATTRIBUTE22' then
1108: l_ATTRIBUTE22 := l_field_val;
1109:
1110: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and
1111: C2.name = 'ATTRIBUTE23' then
1112: l_ATTRIBUTE23 := l_field_val;
1113:
1114: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and

Line 1114: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and

1110: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and
1111: C2.name = 'ATTRIBUTE23' then
1112: l_ATTRIBUTE23 := l_field_val;
1113:
1114: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and
1115: C2.name = 'ATTRIBUTE24' then
1116: l_ATTRIBUTE24 := l_field_val;
1117:
1118: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and

Line 1118: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and

1114: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and
1115: C2.name = 'ATTRIBUTE24' then
1116: l_ATTRIBUTE24 := l_field_val;
1117:
1118: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and
1119: C2.name = 'ATTRIBUTE25' then
1120: l_ATTRIBUTE25 := l_field_val;
1121:
1122: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and

Line 1122: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and

1118: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and
1119: C2.name = 'ATTRIBUTE25' then
1120: l_ATTRIBUTE25 := l_field_val;
1121:
1122: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and
1123: C2.name = 'ATTRIBUTE26' then
1124: l_ATTRIBUTE26 := l_field_val;
1125:
1126: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and

Line 1126: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and

1122: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and
1123: C2.name = 'ATTRIBUTE26' then
1124: l_ATTRIBUTE26 := l_field_val;
1125:
1126: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and
1127: C2.name = 'ATTRIBUTE27' then
1128: l_ATTRIBUTE27 := l_field_val;
1129:
1130: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and

Line 1130: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and

1126: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and
1127: C2.name = 'ATTRIBUTE27' then
1128: l_ATTRIBUTE27 := l_field_val;
1129:
1130: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and
1131: C2.name = 'ATTRIBUTE28' then
1132: l_ATTRIBUTE28 := l_field_val;
1133:
1134: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and

Line 1134: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and

1130: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and
1131: C2.name = 'ATTRIBUTE28' then
1132: l_ATTRIBUTE28 := l_field_val;
1133:
1134: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and
1135: C2.name = 'ATTRIBUTE29' then
1136: l_ATTRIBUTE29 := l_field_val;
1137:
1138: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and

Line 1138: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and

1134: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and
1135: C2.name = 'ATTRIBUTE29' then
1136: l_ATTRIBUTE29 := l_field_val;
1137:
1138: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and
1139: C2.name = 'ATTRIBUTE3' then
1140: l_ATTRIBUTE3 := l_field_val;
1141:
1142: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and

Line 1142: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and

1138: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and
1139: C2.name = 'ATTRIBUTE3' then
1140: l_ATTRIBUTE3 := l_field_val;
1141:
1142: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and
1143: C2.name = 'ATTRIBUTE30' then
1144: l_ATTRIBUTE30 := l_field_val;
1145:
1146: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and

Line 1146: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and

1142: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and
1143: C2.name = 'ATTRIBUTE30' then
1144: l_ATTRIBUTE30 := l_field_val;
1145:
1146: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and
1147: C2.name = 'ATTRIBUTE4' then
1148: l_ATTRIBUTE4 := l_field_val;
1149:
1150: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and

Line 1150: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and

1146: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and
1147: C2.name = 'ATTRIBUTE4' then
1148: l_ATTRIBUTE4 := l_field_val;
1149:
1150: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and
1151: C2.name = 'ATTRIBUTE5' then
1152: l_ATTRIBUTE5 := l_field_val;
1153:
1154: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and

Line 1154: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and

1150: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and
1151: C2.name = 'ATTRIBUTE5' then
1152: l_ATTRIBUTE5 := l_field_val;
1153:
1154: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and
1155: C2.name = 'ATTRIBUTE6' then
1156: l_ATTRIBUTE6 := l_field_val;
1157:
1158: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and

Line 1158: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and

1154: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and
1155: C2.name = 'ATTRIBUTE6' then
1156: l_ATTRIBUTE6 := l_field_val;
1157:
1158: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and
1159: C2.name = 'ATTRIBUTE7' then
1160: l_ATTRIBUTE7 := l_field_val;
1161:
1162: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and

Line 1162: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and

1158: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and
1159: C2.name = 'ATTRIBUTE7' then
1160: l_ATTRIBUTE7 := l_field_val;
1161:
1162: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and
1163: C2.name = 'ATTRIBUTE8' then
1164: l_ATTRIBUTE8 := l_field_val;
1165:
1166: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and

Line 1166: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and

1162: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and
1163: C2.name = 'ATTRIBUTE8' then
1164: l_ATTRIBUTE8 := l_field_val;
1165:
1166: ELSIF C1.api_name = 'PER_ALL_PEOPLE_F' and
1167: C2.name = 'ATTRIBUTE9' then
1168: l_ATTRIBUTE9 := l_field_val;
1169:
1170: ELSIF C1.api_name = 'PER_CONTACT_RELATIONSHIPS' and

Line 1850: ELSIF C1.api_name= 'PER_ALL_PEOPLE_F' THEN

1846: ,p_business_group_id => p_business_group_id
1847: ,p_effective_date => p_effective_date
1848: );
1849: --
1850: ELSIF C1.api_name= 'PER_ALL_PEOPLE_F' THEN
1851: --
1852: ben_whatif_elig.WATIF_ALL_PEOPLE_F_API(
1853: p_person_id => p_person_id
1854: ,p_STUDENT_STATUS => l_STUDENT_STATUS