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.

VIEW: APPS.HRDPV_CREATE_APPLICANT

Source

View Text - Preformatted


select batch_id            batch_id
,      batch_line_id       batch_line_id
,      api_module_id       api_module_id
,      line_status         line_status
,      user_sequence       user_sequence
,      link_value          link_value
,      business_group_name business_group_name,
       pval001 P_DATE_RECEIVED,
       pval002 P_LAST_NAME,
       pval003 P_APPLICANT_NUMBER,
       pval004 P_PER_COMMENTS,
       pval005 P_DATE_EMPLOYEE_DATA_VERIFIED,
       pval006 P_DATE_OF_BIRTH,
       pval007 P_EMAIL_ADDRESS,
       pval008 P_EXPENSE_CHECK_SEND_TO_ADDRES,
       pval009 P_FIRST_NAME,
       pval010 P_KNOWN_AS,
       pval011 P_MARITAL_STATUS,
       pval012 P_MIDDLE_NAMES,
       pval013 P_NATIONALITY,
       pval014 P_NATIONAL_IDENTIFIER,
       pval015 P_PREVIOUS_LAST_NAME,
       pval016 P_REGISTERED_DISABLED_FLAG,
       pval017 P_SEX,
       pval018 P_TITLE,
       pval019 P_WORK_TELEPHONE,
       pval020 P_ATTRIBUTE_CATEGORY,
       pval021 P_ATTRIBUTE1,
       pval022 P_ATTRIBUTE2,
       pval023 P_ATTRIBUTE3,
       pval024 P_ATTRIBUTE4,
       pval025 P_ATTRIBUTE5,
       pval026 P_ATTRIBUTE6,
       pval027 P_ATTRIBUTE7,
       pval028 P_ATTRIBUTE8,
       pval029 P_ATTRIBUTE9,
       pval030 P_ATTRIBUTE10,
       pval031 P_ATTRIBUTE11,
       pval032 P_ATTRIBUTE12,
       pval033 P_ATTRIBUTE13,
       pval034 P_ATTRIBUTE14,
       pval035 P_ATTRIBUTE15,
       pval036 P_ATTRIBUTE16,
       pval037 P_ATTRIBUTE17,
       pval038 P_ATTRIBUTE18,
       pval039 P_ATTRIBUTE19,
       pval040 P_ATTRIBUTE20,
       pval041 P_ATTRIBUTE21,
       pval042 P_ATTRIBUTE22,
       pval043 P_ATTRIBUTE23,
       pval044 P_ATTRIBUTE24,
       pval045 P_ATTRIBUTE25,
       pval046 P_ATTRIBUTE26,
       pval047 P_ATTRIBUTE27,
       pval048 P_ATTRIBUTE28,
       pval049 P_ATTRIBUTE29,
       pval050 P_ATTRIBUTE30,
       pval051 P_PER_INFORMATION_CATEGORY,
       pval052 P_PER_INFORMATION1,
       pval053 P_PER_INFORMATION2,
       pval054 P_PER_INFORMATION3,
       pval055 P_PER_INFORMATION4,
       pval056 P_PER_INFORMATION5,
       pval057 P_PER_INFORMATION6,
       pval058 P_PER_INFORMATION7,
       pval059 P_PER_INFORMATION8,
       pval060 P_PER_INFORMATION9,
       pval061 P_PER_INFORMATION10,
       pval062 P_PER_INFORMATION11,
       pval063 P_PER_INFORMATION12,
       pval064 P_PER_INFORMATION13,
       pval065 P_PER_INFORMATION14,
       pval066 P_PER_INFORMATION15,
       pval067 P_PER_INFORMATION16,
       pval068 P_PER_INFORMATION17,
       pval069 P_PER_INFORMATION18,
       pval070 P_PER_INFORMATION19,
       pval071 P_PER_INFORMATION20,
       pval072 P_PER_INFORMATION21,
       pval073 P_PER_INFORMATION22,
       pval074 P_PER_INFORMATION23,
       pval075 P_PER_INFORMATION24,
       pval076 P_PER_INFORMATION25,
       pval077 P_PER_INFORMATION26,
       pval078 P_PER_INFORMATION27,
       pval079 P_PER_INFORMATION28,
       pval080 P_PER_INFORMATION29,
       pval081 P_PER_INFORMATION30,
       pval082 P_BACKGROUND_CHECK_STATUS,
       pval083 P_BACKGROUND_DATE_CHECK,
       pval084 P_FTE_CAPACITY,
       pval085 P_HOLD_APPLICANT_DATE_UNTIL,
       pval086 P_HONORS,
       pval087 P_MAILSTOP,
       pval088 P_OFFICE_NUMBER,
       pval089 P_ON_MILITARY_SERVICE,
       pval090 P_PRE_NAME_ADJUNCT,
       pval091 P_PROJECTED_START_DATE,
       pval092 P_RESUME_EXISTS,
       pval093 P_RESUME_LAST_UPDATED,
       pval094 P_STUDENT_STATUS,
       pval095 P_WORK_SCHEDULE,
       pval096 P_SUFFIX,
       pval097 P_DATE_OF_DEATH,
       pval098 P_RECEIPT_OF_DEATH_CERT_DATE,
       pval099 P_COORD_BEN_MED_PLN_NO,
       pval100 P_COORD_BEN_NO_CVG_FLAG,
       pval101 P_USES_TOBACCO_FLAG,
       pval102 P_DPDNT_ADOPTION_DATE,
       pval103 P_DPDNT_VLNTRY_SVCE_FLAG,
       pval104 P_ORIGINAL_DATE_OF_HIRE,
       pval105 P_TOWN_OF_BIRTH,
       pval106 P_REGION_OF_BIRTH,
       pval107 P_COUNTRY_OF_BIRTH,
       pval108 P_GLOBAL_PERSON_ID,
       pval109 P_PARTY_ID,
       pval110 P_PERSON_USER_KEY,
       pval111 P_ASSIGNMENT_USER_KEY,
       pval112 P_APPLICATION_USER_KEY,
       pval113 P_PER_OBJECT_VERSION_NUMBER,
       pval114 P_ASG_OBJECT_VERSION_NUMBER,
       pval115 P_APL_OBJECT_VERSION_NUMBER,
       pval116 P_PER_EFFECTIVE_START_DATE,
       pval117 P_PER_EFFECTIVE_END_DATE,
       pval118 P_FULL_NAME,
       pval119 P_PER_COMMENT_ID,
       pval120 P_ASSIGNMENT_SEQUENCE,
       pval121 P_NAME_COMBINATION_WARNING,
       pval122 P_ORIG_HIRE_WARNING,
       pval123 P_USER_PERSON_TYPE,
       pval124 P_LANGUAGE_CODE,
       pval125 P_CORRESPONDENCE_LANGUAGE,
       pval126 P_BENEFIT_GROUP,
       pval127 P_VACANCY_USER_KEY
from hr_pump_batch_lines
where api_module_id = 1339
with check option

View Text - HTML Formatted

SELECT BATCH_ID BATCH_ID
, BATCH_LINE_ID BATCH_LINE_ID
, API_MODULE_ID API_MODULE_ID
, LINE_STATUS LINE_STATUS
, USER_SEQUENCE USER_SEQUENCE
, LINK_VALUE LINK_VALUE
, BUSINESS_GROUP_NAME BUSINESS_GROUP_NAME
, PVAL001 P_DATE_RECEIVED
, PVAL002 P_LAST_NAME
, PVAL003 P_APPLICANT_NUMBER
, PVAL004 P_PER_COMMENTS
, PVAL005 P_DATE_EMPLOYEE_DATA_VERIFIED
, PVAL006 P_DATE_OF_BIRTH
, PVAL007 P_EMAIL_ADDRESS
, PVAL008 P_EXPENSE_CHECK_SEND_TO_ADDRES
, PVAL009 P_FIRST_NAME
, PVAL010 P_KNOWN_AS
, PVAL011 P_MARITAL_STATUS
, PVAL012 P_MIDDLE_NAMES
, PVAL013 P_NATIONALITY
, PVAL014 P_NATIONAL_IDENTIFIER
, PVAL015 P_PREVIOUS_LAST_NAME
, PVAL016 P_REGISTERED_DISABLED_FLAG
, PVAL017 P_SEX
, PVAL018 P_TITLE
, PVAL019 P_WORK_TELEPHONE
, PVAL020 P_ATTRIBUTE_CATEGORY
, PVAL021 P_ATTRIBUTE1
, PVAL022 P_ATTRIBUTE2
, PVAL023 P_ATTRIBUTE3
, PVAL024 P_ATTRIBUTE4
, PVAL025 P_ATTRIBUTE5
, PVAL026 P_ATTRIBUTE6
, PVAL027 P_ATTRIBUTE7
, PVAL028 P_ATTRIBUTE8
, PVAL029 P_ATTRIBUTE9
, PVAL030 P_ATTRIBUTE10
, PVAL031 P_ATTRIBUTE11
, PVAL032 P_ATTRIBUTE12
, PVAL033 P_ATTRIBUTE13
, PVAL034 P_ATTRIBUTE14
, PVAL035 P_ATTRIBUTE15
, PVAL036 P_ATTRIBUTE16
, PVAL037 P_ATTRIBUTE17
, PVAL038 P_ATTRIBUTE18
, PVAL039 P_ATTRIBUTE19
, PVAL040 P_ATTRIBUTE20
, PVAL041 P_ATTRIBUTE21
, PVAL042 P_ATTRIBUTE22
, PVAL043 P_ATTRIBUTE23
, PVAL044 P_ATTRIBUTE24
, PVAL045 P_ATTRIBUTE25
, PVAL046 P_ATTRIBUTE26
, PVAL047 P_ATTRIBUTE27
, PVAL048 P_ATTRIBUTE28
, PVAL049 P_ATTRIBUTE29
, PVAL050 P_ATTRIBUTE30
, PVAL051 P_PER_INFORMATION_CATEGORY
, PVAL052 P_PER_INFORMATION1
, PVAL053 P_PER_INFORMATION2
, PVAL054 P_PER_INFORMATION3
, PVAL055 P_PER_INFORMATION4
, PVAL056 P_PER_INFORMATION5
, PVAL057 P_PER_INFORMATION6
, PVAL058 P_PER_INFORMATION7
, PVAL059 P_PER_INFORMATION8
, PVAL060 P_PER_INFORMATION9
, PVAL061 P_PER_INFORMATION10
, PVAL062 P_PER_INFORMATION11
, PVAL063 P_PER_INFORMATION12
, PVAL064 P_PER_INFORMATION13
, PVAL065 P_PER_INFORMATION14
, PVAL066 P_PER_INFORMATION15
, PVAL067 P_PER_INFORMATION16
, PVAL068 P_PER_INFORMATION17
, PVAL069 P_PER_INFORMATION18
, PVAL070 P_PER_INFORMATION19
, PVAL071 P_PER_INFORMATION20
, PVAL072 P_PER_INFORMATION21
, PVAL073 P_PER_INFORMATION22
, PVAL074 P_PER_INFORMATION23
, PVAL075 P_PER_INFORMATION24
, PVAL076 P_PER_INFORMATION25
, PVAL077 P_PER_INFORMATION26
, PVAL078 P_PER_INFORMATION27
, PVAL079 P_PER_INFORMATION28
, PVAL080 P_PER_INFORMATION29
, PVAL081 P_PER_INFORMATION30
, PVAL082 P_BACKGROUND_CHECK_STATUS
, PVAL083 P_BACKGROUND_DATE_CHECK
, PVAL084 P_FTE_CAPACITY
, PVAL085 P_HOLD_APPLICANT_DATE_UNTIL
, PVAL086 P_HONORS
, PVAL087 P_MAILSTOP
, PVAL088 P_OFFICE_NUMBER
, PVAL089 P_ON_MILITARY_SERVICE
, PVAL090 P_PRE_NAME_ADJUNCT
, PVAL091 P_PROJECTED_START_DATE
, PVAL092 P_RESUME_EXISTS
, PVAL093 P_RESUME_LAST_UPDATED
, PVAL094 P_STUDENT_STATUS
, PVAL095 P_WORK_SCHEDULE
, PVAL096 P_SUFFIX
, PVAL097 P_DATE_OF_DEATH
, PVAL098 P_RECEIPT_OF_DEATH_CERT_DATE
, PVAL099 P_COORD_BEN_MED_PLN_NO
, PVAL100 P_COORD_BEN_NO_CVG_FLAG
, PVAL101 P_USES_TOBACCO_FLAG
, PVAL102 P_DPDNT_ADOPTION_DATE
, PVAL103 P_DPDNT_VLNTRY_SVCE_FLAG
, PVAL104 P_ORIGINAL_DATE_OF_HIRE
, PVAL105 P_TOWN_OF_BIRTH
, PVAL106 P_REGION_OF_BIRTH
, PVAL107 P_COUNTRY_OF_BIRTH
, PVAL108 P_GLOBAL_PERSON_ID
, PVAL109 P_PARTY_ID
, PVAL110 P_PERSON_USER_KEY
, PVAL111 P_ASSIGNMENT_USER_KEY
, PVAL112 P_APPLICATION_USER_KEY
, PVAL113 P_PER_OBJECT_VERSION_NUMBER
, PVAL114 P_ASG_OBJECT_VERSION_NUMBER
, PVAL115 P_APL_OBJECT_VERSION_NUMBER
, PVAL116 P_PER_EFFECTIVE_START_DATE
, PVAL117 P_PER_EFFECTIVE_END_DATE
, PVAL118 P_FULL_NAME
, PVAL119 P_PER_COMMENT_ID
, PVAL120 P_ASSIGNMENT_SEQUENCE
, PVAL121 P_NAME_COMBINATION_WARNING
, PVAL122 P_ORIG_HIRE_WARNING
, PVAL123 P_USER_PERSON_TYPE
, PVAL124 P_LANGUAGE_CODE
, PVAL125 P_CORRESPONDENCE_LANGUAGE
, PVAL126 P_BENEFIT_GROUP
, PVAL127 P_VACANCY_USER_KEY FROM HR_PUMP_BATCH_LINES WHERE API_MODULE_ID = 1339 WITH CHECK OPTION