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.PER_JP_EMPDET_REPORT_PKG dependencies on HR_LOOKUPS

Line 1315: ,DECODE(PJEDV.gender,NULL,NULL,(SELECT meaning FROM hr_lookups WHERE lookup_type = 'SEX' AND lookup_code=PJEDV.gender)) gender

1311: IS
1312: SELECT PJEDV.full_name_kana
1313: ,PJEDV.full_name_kanji
1314: ,PJEDV.date_of_birth
1315: ,DECODE(PJEDV.gender,NULL,NULL,(SELECT meaning FROM hr_lookups WHERE lookup_type = 'SEX' AND lookup_code=PJEDV.gender)) gender
1316: ,SUBSTR(PJEDV.postal_code,1,3)||NVL2(PJEDV.postal_code,'-',' ')|| SUBSTR(PJEDV.postal_code,4) postal_code -- Changed by rdarasi for Bug# 8814075
1317: ,PJEDV.address_line1||' '||PJEDV.address_line2||' '||PJEDV.address_line3 address
1318: ,PJEDV.region1||' '||PJEDV.region2||' '||PJEDV.region3 address_kana
1319: ,PJEDV.address_line1

Line 1326: ,DECODE(PJEDV.termination_reason,NULL,NULL,(SELECT meaning FROM hr_lookups WHERE lookup_type = 'LEAV_REAS' AND lookup_code= PJEDV.termination_reason)) termination_reason -- 8740607

1322: ,PJEDV.country
1323: ,PJEDV.hire_date
1324: ,PJEDV.kind_of_business
1325: ,PJEDV.termination_date
1326: ,DECODE(PJEDV.termination_reason,NULL,NULL,(SELECT meaning FROM hr_lookups WHERE lookup_type = 'LEAV_REAS' AND lookup_code= PJEDV.termination_reason)) termination_reason -- 8740607
1327: ,PJEDV.hi_num
1328: ,SUBSTR(PJEDV.wp_num,1,4)||NVL2(PJEDV.wp_num,'-',' ')|| SUBSTR(PJEDV.wp_num,5) wp_num -- changed by rdarasi for Bug# 8765317
1329: ,PJEDV.wpf_num
1330: ,SUBSTR(PJEDV.ui_num,1,4)||NVL2(PJEDV.ui_num,'-',' ')|| SUBSTR(PJEDV.ui_num,5,6)||NVL2(PJEDV.ui_num,'-',' ')|| SUBSTR(PJEDV.ui_num,11) ui_num -- changed by rdarasi for bug# 8765317

Line 1407: ,DECODE(PJECIV.relationship,NULL,NULL,(SELECT meaning FROM hr_lookups WHERE lookup_type = 'CONTACT' AND lookup_code=PJECIV.relationship)) relationship

1403: CURSOR lcu_contact_info(p_mag_asg_action_id NUMBER)
1404: IS
1405: SELECT PJECIV.full_name_kana
1406: ,PJECIV.full_name_kanji
1407: ,DECODE(PJECIV.relationship,NULL,NULL,(SELECT meaning FROM hr_lookups WHERE lookup_type = 'CONTACT' AND lookup_code=PJECIV.relationship)) relationship
1408: ,DECODE(PJECIV.gender,NULL,NULL,(SELECT meaning FROM hr_lookups WHERE lookup_type = 'SEX' AND lookup_code=PJECIV.gender)) gender
1409: ,TO_CHAR(PJECIV.birth_date, 'EYY.MM.DD', 'NLS_CALENDAR=''Japanese Imperial''') birth_date
1410: ,PJECIV.age
1411: ,DECODE(PJECIV.primary_contact,NULL,NULL,(SELECT meaning FROM hr_lookups WHERE lookup_type = 'YES_NO' AND lookup_code=PJECIV.primary_contact)) primary_contact

Line 1408: ,DECODE(PJECIV.gender,NULL,NULL,(SELECT meaning FROM hr_lookups WHERE lookup_type = 'SEX' AND lookup_code=PJECIV.gender)) gender

1404: IS
1405: SELECT PJECIV.full_name_kana
1406: ,PJECIV.full_name_kanji
1407: ,DECODE(PJECIV.relationship,NULL,NULL,(SELECT meaning FROM hr_lookups WHERE lookup_type = 'CONTACT' AND lookup_code=PJECIV.relationship)) relationship
1408: ,DECODE(PJECIV.gender,NULL,NULL,(SELECT meaning FROM hr_lookups WHERE lookup_type = 'SEX' AND lookup_code=PJECIV.gender)) gender
1409: ,TO_CHAR(PJECIV.birth_date, 'EYY.MM.DD', 'NLS_CALENDAR=''Japanese Imperial''') birth_date
1410: ,PJECIV.age
1411: ,DECODE(PJECIV.primary_contact,NULL,NULL,(SELECT meaning FROM hr_lookups WHERE lookup_type = 'YES_NO' AND lookup_code=PJECIV.primary_contact)) primary_contact
1412: ,DECODE(PJECIV.dependent,NULL,NULL,(SELECT meaning FROM hr_lookups WHERE lookup_type = 'YES_NO' AND lookup_code=PJECIV.dependent)) dependent

Line 1411: ,DECODE(PJECIV.primary_contact,NULL,NULL,(SELECT meaning FROM hr_lookups WHERE lookup_type = 'YES_NO' AND lookup_code=PJECIV.primary_contact)) primary_contact

1407: ,DECODE(PJECIV.relationship,NULL,NULL,(SELECT meaning FROM hr_lookups WHERE lookup_type = 'CONTACT' AND lookup_code=PJECIV.relationship)) relationship
1408: ,DECODE(PJECIV.gender,NULL,NULL,(SELECT meaning FROM hr_lookups WHERE lookup_type = 'SEX' AND lookup_code=PJECIV.gender)) gender
1409: ,TO_CHAR(PJECIV.birth_date, 'EYY.MM.DD', 'NLS_CALENDAR=''Japanese Imperial''') birth_date
1410: ,PJECIV.age
1411: ,DECODE(PJECIV.primary_contact,NULL,NULL,(SELECT meaning FROM hr_lookups WHERE lookup_type = 'YES_NO' AND lookup_code=PJECIV.primary_contact)) primary_contact
1412: ,DECODE(PJECIV.dependent,NULL,NULL,(SELECT meaning FROM hr_lookups WHERE lookup_type = 'YES_NO' AND lookup_code=PJECIV.dependent)) dependent
1413: ,DECODE(PJECIV.shared_residence,NULL,NULL,(SELECT meaning FROM hr_lookups WHERE lookup_type = 'YES_NO' AND lookup_code=PJECIV.shared_residence)) shared_residence
1414: ,PJECIV.sequence
1415: ,DECODE(PJECIV.household_head,NULL,NULL,(SELECT meaning FROM hr_lookups WHERE lookup_type = 'YES_NO' AND lookup_code=PJECIV.household_head)) household_head

Line 1412: ,DECODE(PJECIV.dependent,NULL,NULL,(SELECT meaning FROM hr_lookups WHERE lookup_type = 'YES_NO' AND lookup_code=PJECIV.dependent)) dependent

1408: ,DECODE(PJECIV.gender,NULL,NULL,(SELECT meaning FROM hr_lookups WHERE lookup_type = 'SEX' AND lookup_code=PJECIV.gender)) gender
1409: ,TO_CHAR(PJECIV.birth_date, 'EYY.MM.DD', 'NLS_CALENDAR=''Japanese Imperial''') birth_date
1410: ,PJECIV.age
1411: ,DECODE(PJECIV.primary_contact,NULL,NULL,(SELECT meaning FROM hr_lookups WHERE lookup_type = 'YES_NO' AND lookup_code=PJECIV.primary_contact)) primary_contact
1412: ,DECODE(PJECIV.dependent,NULL,NULL,(SELECT meaning FROM hr_lookups WHERE lookup_type = 'YES_NO' AND lookup_code=PJECIV.dependent)) dependent
1413: ,DECODE(PJECIV.shared_residence,NULL,NULL,(SELECT meaning FROM hr_lookups WHERE lookup_type = 'YES_NO' AND lookup_code=PJECIV.shared_residence)) shared_residence
1414: ,PJECIV.sequence
1415: ,DECODE(PJECIV.household_head,NULL,NULL,(SELECT meaning FROM hr_lookups WHERE lookup_type = 'YES_NO' AND lookup_code=PJECIV.household_head)) household_head
1416: ,DECODE(PJECIV.si_itax,NULL,NULL,(SELECT meaning FROM hr_lookups WHERE lookup_type = 'YES_NO' AND lookup_code=PJECIV.si_itax)) si_itax

Line 1413: ,DECODE(PJECIV.shared_residence,NULL,NULL,(SELECT meaning FROM hr_lookups WHERE lookup_type = 'YES_NO' AND lookup_code=PJECIV.shared_residence)) shared_residence

1409: ,TO_CHAR(PJECIV.birth_date, 'EYY.MM.DD', 'NLS_CALENDAR=''Japanese Imperial''') birth_date
1410: ,PJECIV.age
1411: ,DECODE(PJECIV.primary_contact,NULL,NULL,(SELECT meaning FROM hr_lookups WHERE lookup_type = 'YES_NO' AND lookup_code=PJECIV.primary_contact)) primary_contact
1412: ,DECODE(PJECIV.dependent,NULL,NULL,(SELECT meaning FROM hr_lookups WHERE lookup_type = 'YES_NO' AND lookup_code=PJECIV.dependent)) dependent
1413: ,DECODE(PJECIV.shared_residence,NULL,NULL,(SELECT meaning FROM hr_lookups WHERE lookup_type = 'YES_NO' AND lookup_code=PJECIV.shared_residence)) shared_residence
1414: ,PJECIV.sequence
1415: ,DECODE(PJECIV.household_head,NULL,NULL,(SELECT meaning FROM hr_lookups WHERE lookup_type = 'YES_NO' AND lookup_code=PJECIV.household_head)) household_head
1416: ,DECODE(PJECIV.si_itax,NULL,NULL,(SELECT meaning FROM hr_lookups WHERE lookup_type = 'YES_NO' AND lookup_code=PJECIV.si_itax)) si_itax
1417: FROM per_jp_empdet_contact_info_v PJECIV

Line 1415: ,DECODE(PJECIV.household_head,NULL,NULL,(SELECT meaning FROM hr_lookups WHERE lookup_type = 'YES_NO' AND lookup_code=PJECIV.household_head)) household_head

1411: ,DECODE(PJECIV.primary_contact,NULL,NULL,(SELECT meaning FROM hr_lookups WHERE lookup_type = 'YES_NO' AND lookup_code=PJECIV.primary_contact)) primary_contact
1412: ,DECODE(PJECIV.dependent,NULL,NULL,(SELECT meaning FROM hr_lookups WHERE lookup_type = 'YES_NO' AND lookup_code=PJECIV.dependent)) dependent
1413: ,DECODE(PJECIV.shared_residence,NULL,NULL,(SELECT meaning FROM hr_lookups WHERE lookup_type = 'YES_NO' AND lookup_code=PJECIV.shared_residence)) shared_residence
1414: ,PJECIV.sequence
1415: ,DECODE(PJECIV.household_head,NULL,NULL,(SELECT meaning FROM hr_lookups WHERE lookup_type = 'YES_NO' AND lookup_code=PJECIV.household_head)) household_head
1416: ,DECODE(PJECIV.si_itax,NULL,NULL,(SELECT meaning FROM hr_lookups WHERE lookup_type = 'YES_NO' AND lookup_code=PJECIV.si_itax)) si_itax
1417: FROM per_jp_empdet_contact_info_v PJECIV
1418: WHERE PJECIV.assignment_action_id = p_mag_asg_action_id
1419: ORDER BY PJECIV.full_name_kana

Line 1416: ,DECODE(PJECIV.si_itax,NULL,NULL,(SELECT meaning FROM hr_lookups WHERE lookup_type = 'YES_NO' AND lookup_code=PJECIV.si_itax)) si_itax

1412: ,DECODE(PJECIV.dependent,NULL,NULL,(SELECT meaning FROM hr_lookups WHERE lookup_type = 'YES_NO' AND lookup_code=PJECIV.dependent)) dependent
1413: ,DECODE(PJECIV.shared_residence,NULL,NULL,(SELECT meaning FROM hr_lookups WHERE lookup_type = 'YES_NO' AND lookup_code=PJECIV.shared_residence)) shared_residence
1414: ,PJECIV.sequence
1415: ,DECODE(PJECIV.household_head,NULL,NULL,(SELECT meaning FROM hr_lookups WHERE lookup_type = 'YES_NO' AND lookup_code=PJECIV.household_head)) household_head
1416: ,DECODE(PJECIV.si_itax,NULL,NULL,(SELECT meaning FROM hr_lookups WHERE lookup_type = 'YES_NO' AND lookup_code=PJECIV.si_itax)) si_itax
1417: FROM per_jp_empdet_contact_info_v PJECIV
1418: WHERE PJECIV.assignment_action_id = p_mag_asg_action_id
1419: ORDER BY PJECIV.full_name_kana
1420: ,PJECIV.full_name_kanji;