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_DE_GENERAL

Line 1128: hr_de_general.get_uci(p_report_date,t.user_table_id,r.user_row_id,'MAPPING_ID')) description

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
1132: ,hr_de_general.get_uci(p_report_date,t.user_table_id,r.user_row_id,'REP_EARNINGS') reportable_earnings

Line 1129: ,hr_de_general.get_uci(p_report_date,t.user_table_id,r.user_row_id,'FIXED_CODE') fixed_code

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
1132: ,hr_de_general.get_uci(p_report_date,t.user_table_id,r.user_row_id,'REP_EARNINGS') reportable_earnings
1133: ,nvl(hoi.org_information4, hr_de_general.get_uci(p_report_date,t.user_table_id,r.user_row_id,'ASG_INFO_METH')) asg_info_meth

Line 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

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
1132: ,hr_de_general.get_uci(p_report_date,t.user_table_id,r.user_row_id,'REP_EARNINGS') reportable_earnings
1133: ,nvl(hoi.org_information4, hr_de_general.get_uci(p_report_date,t.user_table_id,r.user_row_id,'ASG_INFO_METH')) asg_info_meth
1134: ,nvl(DECODE(hoi.org_information4,'BAL', hoi.org_information5,'BAL_CODE_CTX', hoi.org_information5,'RRV_ELEMENT', hoi.org_information6,'PROCEDURE', hoi.org_information7),

Line 1131: ,hr_de_general.get_uci(p_report_date,t.user_table_id,r.user_row_id,'MULT_REC') mult_rec

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
1132: ,hr_de_general.get_uci(p_report_date,t.user_table_id,r.user_row_id,'REP_EARNINGS') reportable_earnings
1133: ,nvl(hoi.org_information4, hr_de_general.get_uci(p_report_date,t.user_table_id,r.user_row_id,'ASG_INFO_METH')) asg_info_meth
1134: ,nvl(DECODE(hoi.org_information4,'BAL', hoi.org_information5,'BAL_CODE_CTX', hoi.org_information5,'RRV_ELEMENT', hoi.org_information6,'PROCEDURE', hoi.org_information7),
1135: decode(hoi.org_information4,'RRV',NULL,hr_de_general.get_uci(p_report_date,t.user_table_id,r.user_row_id,'ASG_INFO_DFN'))) asg_info_dfn

Line 1132: ,hr_de_general.get_uci(p_report_date,t.user_table_id,r.user_row_id,'REP_EARNINGS') reportable_earnings

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
1132: ,hr_de_general.get_uci(p_report_date,t.user_table_id,r.user_row_id,'REP_EARNINGS') reportable_earnings
1133: ,nvl(hoi.org_information4, hr_de_general.get_uci(p_report_date,t.user_table_id,r.user_row_id,'ASG_INFO_METH')) asg_info_meth
1134: ,nvl(DECODE(hoi.org_information4,'BAL', hoi.org_information5,'BAL_CODE_CTX', hoi.org_information5,'RRV_ELEMENT', hoi.org_information6,'PROCEDURE', hoi.org_information7),
1135: decode(hoi.org_information4,'RRV',NULL,hr_de_general.get_uci(p_report_date,t.user_table_id,r.user_row_id,'ASG_INFO_DFN'))) asg_info_dfn
1136: ,nvl(hoi.org_information14, hr_de_general.get_uci(p_report_date,t.user_table_id,r.user_row_id,'REP_SUMM_METH')) rep_summ_meth

Line 1133: ,nvl(hoi.org_information4, hr_de_general.get_uci(p_report_date,t.user_table_id,r.user_row_id,'ASG_INFO_METH')) asg_info_meth

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
1132: ,hr_de_general.get_uci(p_report_date,t.user_table_id,r.user_row_id,'REP_EARNINGS') reportable_earnings
1133: ,nvl(hoi.org_information4, hr_de_general.get_uci(p_report_date,t.user_table_id,r.user_row_id,'ASG_INFO_METH')) asg_info_meth
1134: ,nvl(DECODE(hoi.org_information4,'BAL', hoi.org_information5,'BAL_CODE_CTX', hoi.org_information5,'RRV_ELEMENT', hoi.org_information6,'PROCEDURE', hoi.org_information7),
1135: decode(hoi.org_information4,'RRV',NULL,hr_de_general.get_uci(p_report_date,t.user_table_id,r.user_row_id,'ASG_INFO_DFN'))) asg_info_dfn
1136: ,nvl(hoi.org_information14, hr_de_general.get_uci(p_report_date,t.user_table_id,r.user_row_id,'REP_SUMM_METH')) rep_summ_meth
1137: ,nvl(DECODE(hoi.org_information14,'PROCEDURE' , hoi.org_information15),

Line 1135: decode(hoi.org_information4,'RRV',NULL,hr_de_general.get_uci(p_report_date,t.user_table_id,r.user_row_id,'ASG_INFO_DFN'))) asg_info_dfn

1131: ,hr_de_general.get_uci(p_report_date,t.user_table_id,r.user_row_id,'MULT_REC') mult_rec
1132: ,hr_de_general.get_uci(p_report_date,t.user_table_id,r.user_row_id,'REP_EARNINGS') reportable_earnings
1133: ,nvl(hoi.org_information4, hr_de_general.get_uci(p_report_date,t.user_table_id,r.user_row_id,'ASG_INFO_METH')) asg_info_meth
1134: ,nvl(DECODE(hoi.org_information4,'BAL', hoi.org_information5,'BAL_CODE_CTX', hoi.org_information5,'RRV_ELEMENT', hoi.org_information6,'PROCEDURE', hoi.org_information7),
1135: decode(hoi.org_information4,'RRV',NULL,hr_de_general.get_uci(p_report_date,t.user_table_id,r.user_row_id,'ASG_INFO_DFN'))) asg_info_dfn
1136: ,nvl(hoi.org_information14, hr_de_general.get_uci(p_report_date,t.user_table_id,r.user_row_id,'REP_SUMM_METH')) rep_summ_meth
1137: ,nvl(DECODE(hoi.org_information14,'PROCEDURE' , hoi.org_information15),
1138: decode(hoi.org_information14, 'PROCEDURE', hr_de_general.get_uci(p_report_date,t.user_table_id,r.user_row_id,'REP_SUMM_DFN'))) rep_summ_dfn
1139: FROM pay_user_tables t

Line 1136: ,nvl(hoi.org_information14, hr_de_general.get_uci(p_report_date,t.user_table_id,r.user_row_id,'REP_SUMM_METH')) rep_summ_meth

1132: ,hr_de_general.get_uci(p_report_date,t.user_table_id,r.user_row_id,'REP_EARNINGS') reportable_earnings
1133: ,nvl(hoi.org_information4, hr_de_general.get_uci(p_report_date,t.user_table_id,r.user_row_id,'ASG_INFO_METH')) asg_info_meth
1134: ,nvl(DECODE(hoi.org_information4,'BAL', hoi.org_information5,'BAL_CODE_CTX', hoi.org_information5,'RRV_ELEMENT', hoi.org_information6,'PROCEDURE', hoi.org_information7),
1135: decode(hoi.org_information4,'RRV',NULL,hr_de_general.get_uci(p_report_date,t.user_table_id,r.user_row_id,'ASG_INFO_DFN'))) asg_info_dfn
1136: ,nvl(hoi.org_information14, hr_de_general.get_uci(p_report_date,t.user_table_id,r.user_row_id,'REP_SUMM_METH')) rep_summ_meth
1137: ,nvl(DECODE(hoi.org_information14,'PROCEDURE' , hoi.org_information15),
1138: decode(hoi.org_information14, 'PROCEDURE', hr_de_general.get_uci(p_report_date,t.user_table_id,r.user_row_id,'REP_SUMM_DFN'))) rep_summ_dfn
1139: FROM pay_user_tables t
1140: ,pay_user_rows_f r

Line 1138: decode(hoi.org_information14, 'PROCEDURE', hr_de_general.get_uci(p_report_date,t.user_table_id,r.user_row_id,'REP_SUMM_DFN'))) rep_summ_dfn

1134: ,nvl(DECODE(hoi.org_information4,'BAL', hoi.org_information5,'BAL_CODE_CTX', hoi.org_information5,'RRV_ELEMENT', hoi.org_information6,'PROCEDURE', hoi.org_information7),
1135: decode(hoi.org_information4,'RRV',NULL,hr_de_general.get_uci(p_report_date,t.user_table_id,r.user_row_id,'ASG_INFO_DFN'))) asg_info_dfn
1136: ,nvl(hoi.org_information14, hr_de_general.get_uci(p_report_date,t.user_table_id,r.user_row_id,'REP_SUMM_METH')) rep_summ_meth
1137: ,nvl(DECODE(hoi.org_information14,'PROCEDURE' , hoi.org_information15),
1138: decode(hoi.org_information14, 'PROCEDURE', hr_de_general.get_uci(p_report_date,t.user_table_id,r.user_row_id,'REP_SUMM_DFN'))) rep_summ_dfn
1139: FROM pay_user_tables t
1140: ,pay_user_rows_f r
1141: ,hr_organization_information hoi
1142: WHERE t.user_table_name = 'NO_EOY_CODE_REPORTING_RULES'

Line 1171: ,hr_de_general.get_uci

1167: ,'INFO8',hoi.org_information15 -- 2009 changes
1168: ,'INFO9',hoi.org_information16 -- 2009 changes
1169: ,'INFO10',hoi.org_information17 -- 2009 changes
1170: )
1171: ,hr_de_general.get_uci
1172: (p_report_date
1173: ,t.user_table_id
1174: ,r.user_row_id
1175: ,SUBSTR(c.user_column_name, 1, INSTR(c.user_column_name, '_') - 1) || '_ASG_INFO_DFN')) asg_info_dfn

Line 1176: ,hr_de_general.get_uci

1172: (p_report_date
1173: ,t.user_table_id
1174: ,r.user_row_id
1175: ,SUBSTR(c.user_column_name, 1, INSTR(c.user_column_name, '_') - 1) || '_ASG_INFO_DFN')) asg_info_dfn
1176: ,hr_de_general.get_uci
1177: (p_report_date
1178: ,t.user_table_id
1179: ,r.user_row_id
1180: ,SUBSTR(c.user_column_name, 1, INSTR(c.user_column_name, '_') - 1) || '_DATATYPE') datatype

Line 1181: ,hr_de_general.get_uci

1177: (p_report_date
1178: ,t.user_table_id
1179: ,r.user_row_id
1180: ,SUBSTR(c.user_column_name, 1, INSTR(c.user_column_name, '_') - 1) || '_DATATYPE') datatype
1181: ,hr_de_general.get_uci
1182: (p_report_date
1183: ,t.user_table_id
1184: ,r.user_row_id
1185: ,SUBSTR(c.user_column_name, 1, INSTR(c.user_column_name, '_') - 1) || '_XML_CODE_MAP') XML_VALUE_MAP --2007/08 changes

Line 1218: ,TO_NUMBER(decode(hr_de_general.get_uci(p_report_date,t.user_table_id,r.user_row_id,'ZONE'),'1a','6','4a','7',

1214: ,org2.organization_id local_unit_id
1215: ,org2.name local_unit
1216: ,pac2.context_value tax_municipality_id
1217: ,lu.meaning tax_municipality
1218: ,TO_NUMBER(decode(hr_de_general.get_uci(p_report_date,t.user_table_id,r.user_row_id,'ZONE'),'1a','6','4a','7',
1219: hr_de_general.get_uci(p_report_date,t.user_table_id,r.user_row_id,'ZONE'))) ni_zone
1220: -- ,TO_NUMBER(SUBSTR(lu.meaning, 1,1)) ni_zone
1221: ,DECODE(orginf2.org_information5,'Y', orginf2.org_information2,orginf1.org_information4) nace_code -- 2007/08 changes
1222: ,paa.assignment_id assg_id -- 2007/2008 Changes

Line 1219: hr_de_general.get_uci(p_report_date,t.user_table_id,r.user_row_id,'ZONE'))) ni_zone

1215: ,org2.name local_unit
1216: ,pac2.context_value tax_municipality_id
1217: ,lu.meaning tax_municipality
1218: ,TO_NUMBER(decode(hr_de_general.get_uci(p_report_date,t.user_table_id,r.user_row_id,'ZONE'),'1a','6','4a','7',
1219: hr_de_general.get_uci(p_report_date,t.user_table_id,r.user_row_id,'ZONE'))) ni_zone
1220: -- ,TO_NUMBER(SUBSTR(lu.meaning, 1,1)) ni_zone
1221: ,DECODE(orginf2.org_information5,'Y', orginf2.org_information2,orginf1.org_information4) nace_code -- 2007/08 changes
1222: ,paa.assignment_id assg_id -- 2007/2008 Changes
1223: --Bug 14671801

Line 1253: AND lu.lookup_code = hr_de_general.get_uci(p_report_date,t.user_table_id,r.user_row_id,'MAPPING_ID')

1249: AND t.user_table_name = 'NO_TAX_MUNICIPALITY'
1250: AND t.legislation_code = 'NO'
1251: AND r.user_table_id = t.user_table_id
1252: AND lu.lookup_type = 'NO_TAX_MUNICIPALITY'
1253: AND lu.lookup_code = hr_de_general.get_uci(p_report_date,t.user_table_id,r.user_row_id,'MAPPING_ID')
1254: AND paa.tax_unit_id = p_legal_employer_id
1255: AND org2.organization_id = pac1.context_value
1256: AND orginf1.organization_id = paa.tax_unit_id
1257: AND orginf1.org_information_context = 'NO_LEGAL_EMPLOYER_DETAILS'

Line 1809: ,hr_de_general.get_uci(p_report_date,t.user_table_id,r.user_row_id,'ZONE') ni_zone

1805: ,paa.tax_unit_id legal_employer_id
1806: ,TO_NUMBER(ac1.context_value) local_unit_id
1807: ,ac2.context_value tax_municipality
1808: ,ac3.context_value municipality_code
1809: ,hr_de_general.get_uci(p_report_date,t.user_table_id,r.user_row_id,'ZONE') ni_zone
1810: ,MAX(ppa.effective_date) effective_date
1811: ,MAX(asg.effective_end_date) effective_end_date
1812: ,MAX(asg.effective_start_date) effective_start_date --Changes 2007/2008
1813: FROM per_all_assignments_f asg

Line 1854: ,hr_de_general.get_uci(p_report_date,t.user_table_id,r.user_row_id,'ZONE')

1850: ,paa.tax_unit_id
1851: ,TO_NUMBER(ac1.context_value)
1852: ,ac2.context_value
1853: ,ac3.context_value
1854: ,hr_de_general.get_uci(p_report_date,t.user_table_id,r.user_row_id,'ZONE')
1855: ORDER BY asg.person_id
1856: ,MAX(ppa.effective_date) DESC;
1857: --
1858: CURSOR csr_PER