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.PAY_NO_EOY_ARCHIVE dependencies on HR_GENERAL

Line 843: ,UPPER(SUBSTR(hr_general.decode_lookup('NO_POSTAL_CODE', loc.postal_code)

839: ,loc.address_line_1
840: ,loc.address_line_2
841: ,loc.address_line_3
842: ,loc.postal_code postcode
843: ,UPPER(SUBSTR(hr_general.decode_lookup('NO_POSTAL_CODE', loc.postal_code)
844: ,INSTR(hr_general.decode_lookup('NO_POSTAL_CODE', loc.postal_code), ' ') + 1)) postoffice
845: FROM hr_all_organization_units org
846: ,hr_locations_all loc
847: WHERE org.organization_id = p_organization_id

Line 844: ,INSTR(hr_general.decode_lookup('NO_POSTAL_CODE', loc.postal_code), ' ') + 1)) postoffice

840: ,loc.address_line_2
841: ,loc.address_line_3
842: ,loc.postal_code postcode
843: ,UPPER(SUBSTR(hr_general.decode_lookup('NO_POSTAL_CODE', loc.postal_code)
844: ,INSTR(hr_general.decode_lookup('NO_POSTAL_CODE', loc.postal_code), ' ') + 1)) postoffice
845: FROM hr_all_organization_units org
846: ,hr_locations_all loc
847: WHERE org.organization_id = p_organization_id
848: AND loc.location_id (+) = org.location_id;

Line 886: ,decode(pa.style,'NO',substr(hr_general.decode_lookup('NO_POSTAL_CODE',pa.postal_code),

882: SELECT pa.address_line1 address_line_1
883: ,pa.address_line2 address_line_2
884: ,pa.address_line3 address_line_3
885: ,pa.postal_code postcode
886: ,decode(pa.style,'NO',substr(hr_general.decode_lookup('NO_POSTAL_CODE',pa.postal_code),
887: instr(hr_general.decode_lookup('NO_POSTAL_CODE',pa.postal_code),' ')+1),'NO_GLB',pa.town_or_city) postoffice
888: FROM per_addresses pa
889: WHERE pa.person_id = p_person_id
890: AND pa.primary_flag = 'Y'

Line 887: instr(hr_general.decode_lookup('NO_POSTAL_CODE',pa.postal_code),' ')+1),'NO_GLB',pa.town_or_city) postoffice

883: ,pa.address_line2 address_line_2
884: ,pa.address_line3 address_line_3
885: ,pa.postal_code postcode
886: ,decode(pa.style,'NO',substr(hr_general.decode_lookup('NO_POSTAL_CODE',pa.postal_code),
887: instr(hr_general.decode_lookup('NO_POSTAL_CODE',pa.postal_code),' ')+1),'NO_GLB',pa.town_or_city) postoffice
888: FROM per_addresses pa
889: WHERE pa.person_id = p_person_id
890: AND pa.primary_flag = 'Y'
891: AND pa.style IN ('NO', 'NO_GLB')

Line 1009: ,hr_general.decode_lookup('NO_EOY_REPORTING_CODE',

1005: CURSOR csr_REPCODE
1006: (p_report_date IN DATE
1007: ,p_legal_employer_id IN NUMBER) IS
1008: SELECT r.row_low_range_or_name reporting_code
1009: ,hr_general.decode_lookup('NO_EOY_REPORTING_CODE',
1010: hr_de_general.get_uci(p_report_date,t.user_table_id,r.user_row_id,'MAPPING_ID')) description
1011: ,hr_de_general.get_uci(p_report_date,t.user_table_id,r.user_row_id,'FIXED_CODE') fixed_code
1012: ,hr_de_general.get_uci(p_report_date,t.user_table_id,r.user_row_id,'XML_CODE_MAP') XML_CODE -- Added w.r.t phase2 Legislative changes for NORWAY for 2008
1013: ,hr_de_general.get_uci(p_report_date,t.user_table_id,r.user_row_id,'MULT_REC') mult_rec

Line 1040: ,hr_general.decode_lookup('NO_EOY_INFO_PROMPTS', ci.value) prompt

1036: (p_report_date IN DATE
1037: ,p_reporting_code IN VARCHAR2
1038: ,p_legal_employer_id IN NUMBER) IS
1039: SELECT SUBSTR(c.user_column_name, 1, INSTR(c.user_column_name, '_') - 1) info_id
1040: ,hr_general.decode_lookup('NO_EOY_INFO_PROMPTS', ci.value) prompt
1041: ,nvl(DECODE(SUBSTR(c.user_column_name, 1, INSTR(c.user_column_name, '_') - 1)
1042: ,'INFO1',hoi.org_information8
1043: ,'INFO2',hoi.org_information9
1044: ,'INFO3',hoi.org_information10

Line 1795: ,p_action_information6 => hr_general.decode_lookup('YES_NO',l_employed_throughout_year)

1791: ,p_action_information2 => TO_CHAR(l_asg_rec.person_id)
1792: ,p_action_information3 => l_person_rec.full_name
1793: ,p_action_information4 => l_person_rec.employee_number
1794: ,p_action_information5 => l_person_rec.national_identifier
1795: ,p_action_information6 => hr_general.decode_lookup('YES_NO',l_employed_throughout_year)
1796: ,p_action_information7 => hr_general.decode_lookup('YES_NO',l_seaman_status)
1797: ,p_action_information8 => l_non_cont_dates_days
1798: ,p_action_information9 => l_per_addr1
1799: ,p_action_information10 => l_per_addr2

Line 1796: ,p_action_information7 => hr_general.decode_lookup('YES_NO',l_seaman_status)

1792: ,p_action_information3 => l_person_rec.full_name
1793: ,p_action_information4 => l_person_rec.employee_number
1794: ,p_action_information5 => l_person_rec.national_identifier
1795: ,p_action_information6 => hr_general.decode_lookup('YES_NO',l_employed_throughout_year)
1796: ,p_action_information7 => hr_general.decode_lookup('YES_NO',l_seaman_status)
1797: ,p_action_information8 => l_non_cont_dates_days
1798: ,p_action_information9 => l_per_addr1
1799: ,p_action_information10 => l_per_addr2
1800: ,p_action_information11 => l_per_addr3

Line 3112: AND per.action_information7 = DECODE(l_seaman_emp,'N',per.action_information7,hr_general.decode_lookup('YES_NO','Y'))

3108: AND per.action_context_id = summ_cde.action_context_id
3109: AND per.action_information_category = summ_cde.action_information_category
3110: AND per.action_information1 = 'PER_INFO'
3111: AND per.action_information2 = summ_cde.action_information3
3112: AND per.action_information7 = DECODE(l_seaman_emp,'N',per.action_information7,hr_general.decode_lookup('YES_NO','Y'))
3113: ORDER BY per.action_information3;
3114: --
3115: CURSOR csr_SUMMARY_CODES
3116: (l_payroll_action_id IN NUMBER

Line 3441: --g_xml_element_table(l_xml_element_count).tagvalue := hr_general.decode_lookup('YES_NO',l_seaman_status);

3437: l_xml_element_count := l_xml_element_count + 1;
3438: --
3439: g_xml_element_table(l_xml_element_count).tagname := 'SEAMEN';
3440: g_xml_element_table(l_xml_element_count).tagvalue := l_person_rec.seamen; -- Fix For Seamen Display 2007/2008
3441: --g_xml_element_table(l_xml_element_count).tagvalue := hr_general.decode_lookup('YES_NO',l_seaman_status);
3442: l_xml_element_count := l_xml_element_count + 1;
3443: --
3444: g_xml_element_table(l_xml_element_count).tagname := 'TAX_MUNICIPALITY';
3445: g_xml_element_table(l_xml_element_count).tagvalue := l_person_rec.tax_municipality;