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.HR_GBNIDIR dependencies on FND_NUMBER

Line 860: 'AN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)

856: TARGET PAY_RUN_RESULT_VALUES_PK,
857: FEED PAY_BALANCE_FEEDS_F_UK2 )
858: USE_NL(BAL_ASSACT,BACT,BPTP,START_ASS,ASS,ASSACT,PACT,PPTP,RR,TARGET,FEED) +*/
859: nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
860: 'AN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
861: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
862: 'AA',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
863: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
864: 'BN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)

Line 862: 'AA',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)

858: USE_NL(BAL_ASSACT,BACT,BPTP,START_ASS,ASS,ASSACT,PACT,PPTP,RR,TARGET,FEED) +*/
859: nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
860: 'AN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
861: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
862: 'AA',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
863: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
864: 'BN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
865: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
866: 'BA',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)

Line 864: 'BN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)

860: 'AN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
861: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
862: 'AA',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
863: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
864: 'BN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
865: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
866: 'BA',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
867: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
868: 'CN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)

Line 866: 'BA',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)

862: 'AA',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
863: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
864: 'BN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
865: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
866: 'BA',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
867: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
868: 'CN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
869: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
870: 'CC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)

Line 868: 'CN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)

864: 'BN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
865: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
866: 'BA',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
867: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
868: 'CN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
869: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
870: 'CC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
871: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
872: 'DC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)

Line 870: 'CC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)

866: 'BA',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
867: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
868: 'CN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
869: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
870: 'CC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
871: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
872: 'DC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
873: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
874: 'EC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)

Line 872: 'DC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)

868: 'CN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
869: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
870: 'CC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
871: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
872: 'DC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
873: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
874: 'EC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
875: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
876: 'FM',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)

Line 874: 'EC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)

870: 'CC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
871: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
872: 'DC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
873: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
874: 'EC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
875: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
876: 'FM',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
877: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
878: 'GM',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)

Line 876: 'FM',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)

872: 'DC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
873: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
874: 'EC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
875: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
876: 'FM',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
877: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
878: 'GM',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
879: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
880: 'JN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)

Line 878: 'GM',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)

874: 'EC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
875: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
876: 'FM',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
877: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
878: 'GM',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
879: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
880: 'JN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
881: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
882: 'JA',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)

Line 880: 'JN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)

876: 'FM',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
877: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
878: 'GM',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
879: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
880: 'JN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
881: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
882: 'JA',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
883: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
884: 'LC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)

Line 882: 'JA',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)

878: 'GM',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
879: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
880: 'JN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
881: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
882: 'JA',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
883: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
884: 'LC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
885: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
886: 'SM',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)

Line 884: 'LC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)

880: 'JN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
881: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
882: 'JA',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
883: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
884: 'LC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
885: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
886: 'SM',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
887: into g_st_ni_a_able , g_st_ni_ap_able , g_st_ni_b_able ,
888: g_st_ni_bp_able, g_st_ni_c_able , g_st_ni_co_able ,

Line 886: 'SM',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)

882: 'JA',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
883: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
884: 'LC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
885: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
886: 'SM',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
887: into g_st_ni_a_able , g_st_ni_ap_able , g_st_ni_b_able ,
888: g_st_ni_bp_able, g_st_ni_c_able , g_st_ni_co_able ,
889: g_st_ni_d_able , g_st_ni_e_able , g_st_ni_f_able ,
890: g_st_ni_g_able , g_st_ni_j_able, g_st_ni_jp_able,

Line 1108: and fnd_number.canonical_to_number(CINST.value)

1104: , pay_user_rows R
1105: , pay_user_tables TAB
1106: where TAB.user_table_name = p_user_table
1107: and C.user_column_name = p_user_column
1108: and fnd_number.canonical_to_number(CINST.value)
1109: = fnd_number.canonical_to_number(p_user_value)
1110: and C.user_table_id = TAB.user_table_id
1111: and CINST.user_column_id = C.user_column_id
1112: and R.user_table_id = TAB.user_table_id

Line 1109: = fnd_number.canonical_to_number(p_user_value)

1105: , pay_user_tables TAB
1106: where TAB.user_table_name = p_user_table
1107: and C.user_column_name = p_user_column
1108: and fnd_number.canonical_to_number(CINST.value)
1109: = fnd_number.canonical_to_number(p_user_value)
1110: and C.user_table_id = TAB.user_table_id
1111: and CINST.user_column_id = C.user_column_id
1112: and R.user_table_id = TAB.user_table_id
1113: and TAB.user_key_units = 'N'

Line 1135: select fnd_number.canonical_to_number(CINST.value) into l_value from

1131: l_value number;
1132: Begin
1133: l_value := 0;
1134: begin
1135: select fnd_number.canonical_to_number(CINST.value) into l_value from
1136: pay_user_column_instances CINST
1137: , pay_user_column_instances LABEL
1138: , pay_user_columns CLABEL
1139: , pay_user_columns C

Line 1178: 'H',fnd_number.canonical_to_number(R.ROW_HIGH_RANGE),

1174: l_value := 0;
1175: --
1176: begin
1177: select decode(substr(p_high_or_low,1,1),
1178: 'H',fnd_number.canonical_to_number(R.ROW_HIGH_RANGE),
1179: fnd_number.canonical_to_number(R.row_low_range_or_name))
1180: into l_value from
1181: pay_user_column_instances LABEL
1182: , pay_user_columns CLABEL

Line 1179: fnd_number.canonical_to_number(R.row_low_range_or_name))

1175: --
1176: begin
1177: select decode(substr(p_high_or_low,1,1),
1178: 'H',fnd_number.canonical_to_number(R.ROW_HIGH_RANGE),
1179: fnd_number.canonical_to_number(R.row_low_range_or_name))
1180: into l_value from
1181: pay_user_column_instances LABEL
1182: , pay_user_columns CLABEL
1183: , pay_user_rows R

Line 1214: select min(fnd_number.canonical_to_number(CINST.value))

1210: l_value number;
1211: Begin
1212: l_value := 0;
1213: --
1214: select min(fnd_number.canonical_to_number(CINST.value))
1215: into l_value from
1216: pay_user_column_instances CINST
1217: , pay_user_column_instances LABEL
1218: , pay_user_columns CLABEL

Line 1229: and fnd_number.canonical_to_number(LABEL.value)

1225: and CINST.user_column_id = C.user_column_id
1226: and R.user_table_id = TAB.user_table_id
1227: and TAB.user_key_units = 'N'
1228: and CINST.user_row_id = R.user_row_id
1229: and fnd_number.canonical_to_number(LABEL.value)
1230: = fnd_number.canonical_to_number(p_ci_rate)
1231: and CLABEL.user_column_name = 'C_ERS_RATE_CI'
1232: and CLABEL.user_column_id = LABEL.user_column_id
1233: and CLABEL.user_table_id = TAB.user_table_id

Line 1230: = fnd_number.canonical_to_number(p_ci_rate)

1226: and R.user_table_id = TAB.user_table_id
1227: and TAB.user_key_units = 'N'
1228: and CINST.user_row_id = R.user_row_id
1229: and fnd_number.canonical_to_number(LABEL.value)
1230: = fnd_number.canonical_to_number(p_ci_rate)
1231: and CLABEL.user_column_name = 'C_ERS_RATE_CI'
1232: and CLABEL.user_column_id = LABEL.user_column_id
1233: and CLABEL.user_table_id = TAB.user_table_id
1234: and LABEL.user_row_id = R.user_row_id;

Line 1250: select min(fnd_number.canonical_to_number(CINST.value))

1246: l_value number;
1247: Begin
1248: l_value := 0;
1249: --
1250: select min(fnd_number.canonical_to_number(CINST.value))
1251: into l_value from
1252: pay_user_column_instances CINST
1253: , pay_user_column_instances LABEL
1254: , pay_user_columns CLABEL

Line 1265: and fnd_number.canonical_to_number(LABEL.value) = fnd_number.canonical_to_number(p_ci_rate)

1261: and CINST.user_column_id = C.user_column_id
1262: and R.user_table_id = TAB.user_table_id
1263: and TAB.user_key_units = 'N'
1264: and CINST.user_row_id = R.user_row_id
1265: and fnd_number.canonical_to_number(LABEL.value) = fnd_number.canonical_to_number(p_ci_rate)
1266: and CLABEL.user_column_name = 'C_ERS_RATE_CI'
1267: and CLABEL.user_column_id = LABEL.user_column_id
1268: and CLABEL.user_table_id = TAB.user_table_id
1269: and LABEL.user_row_id = R.user_row_id;

Line 1929: 'AN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)

1925: TARGET PAY_RUN_RESULT_VALUES_PK,
1926: FEED PAY_BALANCE_FEEDS_F_UK2)
1927: USE_NL(BAL_ASSACT,BACT,BPTP,START_ASS,ASS,ASSACT,PACT,PPTP,RR,TARGET,FEED) +*/
1928: nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
1929: 'AN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
1930: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
1931: 'AA',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
1932: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
1933: 'BN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)

Line 1931: 'AA',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)

1927: USE_NL(BAL_ASSACT,BACT,BPTP,START_ASS,ASS,ASSACT,PACT,PPTP,RR,TARGET,FEED) +*/
1928: nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
1929: 'AN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
1930: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
1931: 'AA',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
1932: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
1933: 'BN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
1934: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
1935: 'BA',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)

Line 1933: 'BN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)

1929: 'AN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
1930: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
1931: 'AA',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
1932: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
1933: 'BN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
1934: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
1935: 'BA',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
1936: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
1937: 'CN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)

Line 1935: 'BA',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)

1931: 'AA',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
1932: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
1933: 'BN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
1934: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
1935: 'BA',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
1936: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
1937: 'CN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
1938: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
1939: 'CC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)

Line 1937: 'CN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)

1933: 'BN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
1934: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
1935: 'BA',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
1936: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
1937: 'CN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
1938: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
1939: 'CC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
1940: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
1941: 'DC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)

Line 1939: 'CC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)

1935: 'BA',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
1936: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
1937: 'CN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
1938: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
1939: 'CC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
1940: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
1941: 'DC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
1942: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
1943: 'EC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)

Line 1941: 'DC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)

1937: 'CN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
1938: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
1939: 'CC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
1940: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
1941: 'DC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
1942: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
1943: 'EC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
1944: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
1945: 'FM',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)

Line 1943: 'EC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)

1939: 'CC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
1940: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
1941: 'DC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
1942: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
1943: 'EC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
1944: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
1945: 'FM',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
1946: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
1947: 'GM',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)

Line 1945: 'FM',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)

1941: 'DC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
1942: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
1943: 'EC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
1944: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
1945: 'FM',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
1946: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
1947: 'GM',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
1948: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
1949: 'JN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)

Line 1947: 'GM',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)

1943: 'EC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
1944: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
1945: 'FM',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
1946: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
1947: 'GM',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
1948: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
1949: 'JN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
1950: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
1951: 'JA',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)

Line 1949: 'JN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)

1945: 'FM',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
1946: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
1947: 'GM',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
1948: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
1949: 'JN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
1950: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
1951: 'JA',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
1952: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
1953: 'LC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)

Line 1951: 'JA',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)

1947: 'GM',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
1948: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
1949: 'JN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
1950: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
1951: 'JA',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
1952: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
1953: 'LC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
1954: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
1955: 'SM',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)

Line 1953: 'LC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)

1949: 'JN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
1950: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
1951: 'JA',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
1952: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
1953: 'LC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
1954: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
1955: 'SM',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
1956: into g_st_ni_a_able , g_st_ni_ap_able, g_st_ni_b_able ,
1957: g_st_ni_bp_able, g_st_ni_c_able , g_st_ni_co_able ,

Line 1955: 'SM',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)

1951: 'JA',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
1952: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
1953: 'LC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
1954: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
1955: 'SM',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
1956: into g_st_ni_a_able , g_st_ni_ap_able, g_st_ni_b_able ,
1957: g_st_ni_bp_able, g_st_ni_c_able , g_st_ni_co_able ,
1958: g_st_ni_d_able , g_st_ni_e_able , g_st_ni_f_able ,
1959: g_st_ni_g_able , g_st_ni_j_able, g_st_ni_jp_able,