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 936: ,UPPER(SUBSTR(hr_general.decode_lookup('NO_POSTAL_CODE', loc.postal_code)

932: ,loc.address_line_1
933: ,loc.address_line_2
934: ,loc.address_line_3
935: ,loc.postal_code postcode
936: ,UPPER(SUBSTR(hr_general.decode_lookup('NO_POSTAL_CODE', loc.postal_code)
937: ,INSTR(hr_general.decode_lookup('NO_POSTAL_CODE', loc.postal_code), ' ') + 1)) postoffice
938: FROM hr_all_organization_units org
939: ,hr_locations_all loc
940: WHERE org.organization_id = p_organization_id

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

933: ,loc.address_line_2
934: ,loc.address_line_3
935: ,loc.postal_code postcode
936: ,UPPER(SUBSTR(hr_general.decode_lookup('NO_POSTAL_CODE', loc.postal_code)
937: ,INSTR(hr_general.decode_lookup('NO_POSTAL_CODE', loc.postal_code), ' ') + 1)) postoffice
938: FROM hr_all_organization_units org
939: ,hr_locations_all loc
940: WHERE org.organization_id = p_organization_id
941: AND loc.location_id (+) = org.location_id;

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

975: SELECT pa.address_line1 address_line_1
976: ,pa.address_line2 address_line_2
977: ,pa.address_line3 address_line_3
978: ,pa.postal_code postcode
979: ,decode(pa.style,'NO',substr(hr_general.decode_lookup('NO_POSTAL_CODE',pa.postal_code),
980: instr(hr_general.decode_lookup('NO_POSTAL_CODE',pa.postal_code),' ')+1),'NO_GLB',pa.town_or_city) postoffice
981: FROM per_addresses pa
982: WHERE pa.person_id = p_person_id
983: AND pa.primary_flag = 'Y'

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

976: ,pa.address_line2 address_line_2
977: ,pa.address_line3 address_line_3
978: ,pa.postal_code postcode
979: ,decode(pa.style,'NO',substr(hr_general.decode_lookup('NO_POSTAL_CODE',pa.postal_code),
980: instr(hr_general.decode_lookup('NO_POSTAL_CODE',pa.postal_code),' ')+1),'NO_GLB',pa.town_or_city) postoffice
981: FROM per_addresses pa
982: WHERE pa.person_id = p_person_id
983: AND pa.primary_flag = 'Y'
984: AND pa.style IN ('NO', 'NO_GLB')

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

1123: CURSOR csr_REPCODE
1124: (p_report_date IN DATE
1125: ,p_legal_employer_id IN NUMBER) IS
1126: SELECT r.row_low_range_or_name reporting_code
1127: ,hr_general.decode_lookup('NO_EOY_REPORTING_CODE',
1128: hr_de_general.get_uci(p_report_date,t.user_table_id,r.user_row_id,'MAPPING_ID')) description
1129: ,hr_de_general.get_uci(p_report_date,t.user_table_id,r.user_row_id,'FIXED_CODE') fixed_code
1130: ,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
1131: ,hr_de_general.get_uci(p_report_date,t.user_table_id,r.user_row_id,'MULT_REC') mult_rec

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

1154: (p_report_date IN DATE
1155: ,p_reporting_code IN VARCHAR2
1156: ,p_legal_employer_id IN NUMBER) IS
1157: SELECT SUBSTR(c.user_column_name, 1, INSTR(c.user_column_name, '_') - 1) info_id
1158: ,hr_general.decode_lookup('NO_EOY_INFO_PROMPTS', ci.value) prompt
1159: ,nvl(DECODE(SUBSTR(c.user_column_name, 1, INSTR(c.user_column_name, '_') - 1)
1160: ,'INFO1',hoi.org_information8
1161: ,'INFO2',hoi.org_information9
1162: ,'INFO3',hoi.org_information10

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

1973: ,p_action_information2 => TO_CHAR(l_asg_rec.person_id)
1974: ,p_action_information3 => l_person_rec.full_name
1975: ,p_action_information4 => l_person_rec.employee_number
1976: ,p_action_information5 => l_person_rec.national_identifier
1977: ,p_action_information6 => hr_general.decode_lookup('YES_NO',l_employed_throughout_year)
1978: ,p_action_information7 => hr_general.decode_lookup('YES_NO',l_seaman_status)
1979: ,p_action_information8 => l_non_cont_dates_days
1980: ,p_action_information9 => l_per_addr1
1981: ,p_action_information10 => l_per_addr2

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

1974: ,p_action_information3 => l_person_rec.full_name
1975: ,p_action_information4 => l_person_rec.employee_number
1976: ,p_action_information5 => l_person_rec.national_identifier
1977: ,p_action_information6 => hr_general.decode_lookup('YES_NO',l_employed_throughout_year)
1978: ,p_action_information7 => hr_general.decode_lookup('YES_NO',l_seaman_status)
1979: ,p_action_information8 => l_non_cont_dates_days
1980: ,p_action_information9 => l_per_addr1
1981: ,p_action_information10 => l_per_addr2
1982: ,p_action_information11 => l_per_addr3

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

3712: AND per.action_context_id = summ_cde.action_context_id
3713: AND per.action_information_category = summ_cde.action_information_category
3714: AND per.action_information1 = 'PER_INFO'
3715: AND per.action_information2 = summ_cde.action_information3
3716: AND per.action_information7 = DECODE(l_seaman_emp,'N',per.action_information7,hr_general.decode_lookup('YES_NO','Y'))
3717: ORDER BY per.action_information3;
3718: --
3719: CURSOR csr_SUMMARY_CODES
3720: (l_payroll_action_id IN NUMBER

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

4160: l_xml_element_count := l_xml_element_count + 1;
4161: --
4162: g_xml_element_table(l_xml_element_count).tagname := 'SEAMEN';
4163: g_xml_element_table(l_xml_element_count).tagvalue := l_person_rec.seamen; -- Fix For Seamen Display 2007/2008
4164: --g_xml_element_table(l_xml_element_count).tagvalue := hr_general.decode_lookup('YES_NO',l_seaman_status);
4165: l_xml_element_count := l_xml_element_count + 1;
4166: --
4167: g_xml_element_table(l_xml_element_count).tagname := 'TAX_MUNICIPALITY';
4168: g_xml_element_table(l_xml_element_count).tagvalue := l_person_rec.tax_municipality;