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_KR_PAYKRYRS_PKG dependencies on HR_GENERAL

Line 141: hr_general.decode_territory(aei_information2) p_ovs_country,

137: ------------------------- Overseas Tax Cursor --------------------------
138: cursor per_asg_extra_info_ovs_csr(p_assignment_id number, p_year number) is
139: select aei_information7 p_ovs_tax_paid_fc,
140: aei_information8 p_ovs_tax_paid_lc,
141: hr_general.decode_territory(aei_information2) p_ovs_country,
142: to_char(fnd_date.canonical_to_date(aei_information1) , 'YYYY.MM.DD') p_ovs_paid_date,
143: to_char(fnd_date.canonical_to_date(aei_information10), 'YYYY.MM.DD') p_ovs_submit_date,
144: aei_information11 p_ovs_location,
145: aei_information12 p_ovs_period,

Line 1162: p_sep_pen_type1 := hr_general.decode_lookup('KR_YEA_SEP_PEN_TYPES',i.type);

1158: ---------------------- Pension Saving Details --------------------------------
1159: for i in csr_sep_pen_details(p_assignment_id, p_year) loop
1160: if i.rownum=1 then
1161: p_sep_pen_priority1 := i.priority;
1162: p_sep_pen_type1 := hr_general.decode_lookup('KR_YEA_SEP_PEN_TYPES',i.type);
1163: p_sep_pen_fin_inst1 := hr_general.decode_lookup('KR_YEA_FIN_INST_CODES',i.fin_institute);
1164: p_sep_pen_acc_number1 := i.acc_number;
1165: p_sep_pen_cont_amt1 := i.cont_amount;
1166: elsif i.rownum=2 then

Line 1163: p_sep_pen_fin_inst1 := hr_general.decode_lookup('KR_YEA_FIN_INST_CODES',i.fin_institute);

1159: for i in csr_sep_pen_details(p_assignment_id, p_year) loop
1160: if i.rownum=1 then
1161: p_sep_pen_priority1 := i.priority;
1162: p_sep_pen_type1 := hr_general.decode_lookup('KR_YEA_SEP_PEN_TYPES',i.type);
1163: p_sep_pen_fin_inst1 := hr_general.decode_lookup('KR_YEA_FIN_INST_CODES',i.fin_institute);
1164: p_sep_pen_acc_number1 := i.acc_number;
1165: p_sep_pen_cont_amt1 := i.cont_amount;
1166: elsif i.rownum=2 then
1167: p_sep_pen_priority2 := i.priority;

Line 1168: p_sep_pen_type2 := hr_general.decode_lookup('KR_YEA_SEP_PEN_TYPES',i.type);

1164: p_sep_pen_acc_number1 := i.acc_number;
1165: p_sep_pen_cont_amt1 := i.cont_amount;
1166: elsif i.rownum=2 then
1167: p_sep_pen_priority2 := i.priority;
1168: p_sep_pen_type2 := hr_general.decode_lookup('KR_YEA_SEP_PEN_TYPES',i.type);
1169: p_sep_pen_fin_inst2 := hr_general.decode_lookup('KR_YEA_FIN_INST_CODES',i.fin_institute);
1170: p_sep_pen_acc_number2 := i.acc_number;
1171: p_sep_pen_cont_amt2 := i.cont_amount;
1172: elsif i.rownum > 2 then

Line 1169: p_sep_pen_fin_inst2 := hr_general.decode_lookup('KR_YEA_FIN_INST_CODES',i.fin_institute);

1165: p_sep_pen_cont_amt1 := i.cont_amount;
1166: elsif i.rownum=2 then
1167: p_sep_pen_priority2 := i.priority;
1168: p_sep_pen_type2 := hr_general.decode_lookup('KR_YEA_SEP_PEN_TYPES',i.type);
1169: p_sep_pen_fin_inst2 := hr_general.decode_lookup('KR_YEA_FIN_INST_CODES',i.fin_institute);
1170: p_sep_pen_acc_number2 := i.acc_number;
1171: p_sep_pen_cont_amt2 := i.cont_amount;
1172: elsif i.rownum > 2 then
1173: p_sep_pen_Details_count := nvl(p_sep_pen_Details_count,0) + 1;

Line 1183: p_pen_sav_type1 := hr_general.decode_lookup('KR_YEA_PEN_SAVING_TYPES',j.type);

1179:
1180: if j.rownum=1 then
1181:
1182: p_pen_sav_priority1 := j.priority;
1183: p_pen_sav_type1 := hr_general.decode_lookup('KR_YEA_PEN_SAVING_TYPES',j.type);
1184: p_pen_sav_fin_inst1 := hr_general.decode_lookup('KR_YEA_FIN_INST_CODES',j.fin_institute);
1185: p_pen_sav_acc_number1 := j.acc_number;
1186: p_pen_sav_cont_amt1 := j.cont_amount;
1187:

Line 1184: p_pen_sav_fin_inst1 := hr_general.decode_lookup('KR_YEA_FIN_INST_CODES',j.fin_institute);

1180: if j.rownum=1 then
1181:
1182: p_pen_sav_priority1 := j.priority;
1183: p_pen_sav_type1 := hr_general.decode_lookup('KR_YEA_PEN_SAVING_TYPES',j.type);
1184: p_pen_sav_fin_inst1 := hr_general.decode_lookup('KR_YEA_FIN_INST_CODES',j.fin_institute);
1185: p_pen_sav_acc_number1 := j.acc_number;
1186: p_pen_sav_cont_amt1 := j.cont_amount;
1187:
1188: elsif j.rownum=2 then

Line 1191: p_pen_sav_type2 := hr_general.decode_lookup('KR_YEA_PEN_SAVING_TYPES',j.type);

1187:
1188: elsif j.rownum=2 then
1189:
1190: p_pen_sav_priority2 := j.priority;
1191: p_pen_sav_type2 := hr_general.decode_lookup('KR_YEA_PEN_SAVING_TYPES',j.type);
1192: p_pen_sav_fin_inst2 := hr_general.decode_lookup('KR_YEA_FIN_INST_CODES',j.fin_institute);
1193: p_pen_sav_acc_number2 := j.acc_number;
1194: p_pen_sav_cont_amt2 := j.cont_amount;
1195:

Line 1192: p_pen_sav_fin_inst2 := hr_general.decode_lookup('KR_YEA_FIN_INST_CODES',j.fin_institute);

1188: elsif j.rownum=2 then
1189:
1190: p_pen_sav_priority2 := j.priority;
1191: p_pen_sav_type2 := hr_general.decode_lookup('KR_YEA_PEN_SAVING_TYPES',j.type);
1192: p_pen_sav_fin_inst2 := hr_general.decode_lookup('KR_YEA_FIN_INST_CODES',j.fin_institute);
1193: p_pen_sav_acc_number2 := j.acc_number;
1194: p_pen_sav_cont_amt2 := j.cont_amount;
1195:
1196: elsif j.rownum > 2 then

Line 1204: p_hou_sav_type1 := hr_general.decode_lookup('KR_HOUSING_SAVING_TYPE',k.type);

1200:
1201: for k in csr_hou_sav_details(p_assignment_id, p_year) loop
1202: if k.rownum=1 then
1203: p_hou_sav_priority1 := k.priority;
1204: p_hou_sav_type1 := hr_general.decode_lookup('KR_HOUSING_SAVING_TYPE',k.type);
1205: p_hou_sav_fin_inst1 := hr_general.decode_lookup('KR_YEA_FIN_INST_CODES',k.fin_institute);
1206: p_hou_sav_acc_number1 := k.acc_number;
1207: p_hou_sav_cont_amt1 := k.cont_amount;
1208: elsif k.rownum=2 then

Line 1205: p_hou_sav_fin_inst1 := hr_general.decode_lookup('KR_YEA_FIN_INST_CODES',k.fin_institute);

1201: for k in csr_hou_sav_details(p_assignment_id, p_year) loop
1202: if k.rownum=1 then
1203: p_hou_sav_priority1 := k.priority;
1204: p_hou_sav_type1 := hr_general.decode_lookup('KR_HOUSING_SAVING_TYPE',k.type);
1205: p_hou_sav_fin_inst1 := hr_general.decode_lookup('KR_YEA_FIN_INST_CODES',k.fin_institute);
1206: p_hou_sav_acc_number1 := k.acc_number;
1207: p_hou_sav_cont_amt1 := k.cont_amount;
1208: elsif k.rownum=2 then
1209: p_hou_sav_priority2 := k.priority;

Line 1210: p_hou_sav_type2 := hr_general.decode_lookup('KR_HOUSING_SAVING_TYPE',k.type);

1206: p_hou_sav_acc_number1 := k.acc_number;
1207: p_hou_sav_cont_amt1 := k.cont_amount;
1208: elsif k.rownum=2 then
1209: p_hou_sav_priority2 := k.priority;
1210: p_hou_sav_type2 := hr_general.decode_lookup('KR_HOUSING_SAVING_TYPE',k.type);
1211: p_hou_sav_fin_inst2 := hr_general.decode_lookup('KR_YEA_FIN_INST_CODES',k.fin_institute);
1212: p_hou_sav_acc_number2 := k.acc_number;
1213: p_hou_sav_cont_amt2 := k.cont_amount;
1214:

Line 1211: p_hou_sav_fin_inst2 := hr_general.decode_lookup('KR_YEA_FIN_INST_CODES',k.fin_institute);

1207: p_hou_sav_cont_amt1 := k.cont_amount;
1208: elsif k.rownum=2 then
1209: p_hou_sav_priority2 := k.priority;
1210: p_hou_sav_type2 := hr_general.decode_lookup('KR_HOUSING_SAVING_TYPE',k.type);
1211: p_hou_sav_fin_inst2 := hr_general.decode_lookup('KR_YEA_FIN_INST_CODES',k.fin_institute);
1212: p_hou_sav_acc_number2 := k.acc_number;
1213: p_hou_sav_cont_amt2 := k.cont_amount;
1214:
1215: elsif k.rownum=3 then

Line 1217: p_hou_sav_type3 := hr_general.decode_lookup('KR_HOUSING_SAVING_TYPE',k.type);

1213: p_hou_sav_cont_amt2 := k.cont_amount;
1214:
1215: elsif k.rownum=3 then
1216: p_hou_sav_priority3 := k.priority;
1217: p_hou_sav_type3 := hr_general.decode_lookup('KR_HOUSING_SAVING_TYPE',k.type);
1218: p_hou_sav_fin_inst3 := hr_general.decode_lookup('KR_YEA_FIN_INST_CODES',k.fin_institute);
1219: p_hou_sav_acc_number3 := k.acc_number;
1220: p_hou_sav_cont_amt3 := k.cont_amount;
1221:

Line 1218: p_hou_sav_fin_inst3 := hr_general.decode_lookup('KR_YEA_FIN_INST_CODES',k.fin_institute);

1214:
1215: elsif k.rownum=3 then
1216: p_hou_sav_priority3 := k.priority;
1217: p_hou_sav_type3 := hr_general.decode_lookup('KR_HOUSING_SAVING_TYPE',k.type);
1218: p_hou_sav_fin_inst3 := hr_general.decode_lookup('KR_YEA_FIN_INST_CODES',k.fin_institute);
1219: p_hou_sav_acc_number3 := k.acc_number;
1220: p_hou_sav_cont_amt3 := k.cont_amount;
1221:
1222: elsif k.rownum >3 then

Line 1230: p_lt_stck_sav_type1 := hr_general.decode_lookup('KR_YEA_LT_STOCK_SAVING_YEAR',m.type);

1226:
1227: for m in csr_lt_stck_sav_details(p_assignment_id, p_year) loop
1228: if m.rownum=1 then
1229: p_lt_stck_sav_priority1 := m.priority;
1230: p_lt_stck_sav_type1 := hr_general.decode_lookup('KR_YEA_LT_STOCK_SAVING_YEAR',m.type);
1231: p_lt_stck_sav_fin_inst1 := hr_general.decode_lookup('KR_YEA_FIN_INST_CODES',m.fin_institute);
1232: p_lt_stck_sav_acc_number1 := m.acc_number;
1233: p_lt_stck_sav_cont_amt1 := m.cont_amount;
1234: elsif m.rownum=2 then

Line 1231: p_lt_stck_sav_fin_inst1 := hr_general.decode_lookup('KR_YEA_FIN_INST_CODES',m.fin_institute);

1227: for m in csr_lt_stck_sav_details(p_assignment_id, p_year) loop
1228: if m.rownum=1 then
1229: p_lt_stck_sav_priority1 := m.priority;
1230: p_lt_stck_sav_type1 := hr_general.decode_lookup('KR_YEA_LT_STOCK_SAVING_YEAR',m.type);
1231: p_lt_stck_sav_fin_inst1 := hr_general.decode_lookup('KR_YEA_FIN_INST_CODES',m.fin_institute);
1232: p_lt_stck_sav_acc_number1 := m.acc_number;
1233: p_lt_stck_sav_cont_amt1 := m.cont_amount;
1234: elsif m.rownum=2 then
1235: p_lt_stck_sav_priority2 := m.priority;

Line 1236: p_lt_stck_sav_type2 := hr_general.decode_lookup('KR_YEA_LT_STOCK_SAVING_YEAR',m.type);

1232: p_lt_stck_sav_acc_number1 := m.acc_number;
1233: p_lt_stck_sav_cont_amt1 := m.cont_amount;
1234: elsif m.rownum=2 then
1235: p_lt_stck_sav_priority2 := m.priority;
1236: p_lt_stck_sav_type2 := hr_general.decode_lookup('KR_YEA_LT_STOCK_SAVING_YEAR',m.type);
1237: p_lt_stck_sav_fin_inst2 := hr_general.decode_lookup('KR_YEA_FIN_INST_CODES',m.fin_institute);
1238: p_lt_stck_sav_acc_number2 := m.acc_number;
1239: p_lt_stck_sav_cont_amt2 := m.cont_amount;
1240:

Line 1237: p_lt_stck_sav_fin_inst2 := hr_general.decode_lookup('KR_YEA_FIN_INST_CODES',m.fin_institute);

1233: p_lt_stck_sav_cont_amt1 := m.cont_amount;
1234: elsif m.rownum=2 then
1235: p_lt_stck_sav_priority2 := m.priority;
1236: p_lt_stck_sav_type2 := hr_general.decode_lookup('KR_YEA_LT_STOCK_SAVING_YEAR',m.type);
1237: p_lt_stck_sav_fin_inst2 := hr_general.decode_lookup('KR_YEA_FIN_INST_CODES',m.fin_institute);
1238: p_lt_stck_sav_acc_number2 := m.acc_number;
1239: p_lt_stck_sav_cont_amt2 := m.cont_amount;
1240:
1241: elsif m.rownum=3 then

Line 1243: p_lt_stck_sav_type3 := hr_general.decode_lookup('KR_YEA_LT_STOCK_SAVING_YEAR',m.type);

1239: p_lt_stck_sav_cont_amt2 := m.cont_amount;
1240:
1241: elsif m.rownum=3 then
1242: p_lt_stck_sav_priority3 := m.priority;
1243: p_lt_stck_sav_type3 := hr_general.decode_lookup('KR_YEA_LT_STOCK_SAVING_YEAR',m.type);
1244: p_lt_stck_sav_fin_inst3 := hr_general.decode_lookup('KR_YEA_FIN_INST_CODES',m.fin_institute);
1245: p_lt_stck_sav_acc_number3 := m.acc_number;
1246: p_lt_stck_sav_cont_amt3 := m.cont_amount;
1247:

Line 1244: p_lt_stck_sav_fin_inst3 := hr_general.decode_lookup('KR_YEA_FIN_INST_CODES',m.fin_institute);

1240:
1241: elsif m.rownum=3 then
1242: p_lt_stck_sav_priority3 := m.priority;
1243: p_lt_stck_sav_type3 := hr_general.decode_lookup('KR_YEA_LT_STOCK_SAVING_YEAR',m.type);
1244: p_lt_stck_sav_fin_inst3 := hr_general.decode_lookup('KR_YEA_FIN_INST_CODES',m.fin_institute);
1245: p_lt_stck_sav_acc_number3 := m.acc_number;
1246: p_lt_stck_sav_cont_amt3 := m.cont_amount;
1247:
1248: elsif m.rownum >3 then