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 936: 'AN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)

932: TARGET PAY_RUN_RESULT_VALUES_PK,
933: FEED PAY_BALANCE_FEEDS_F_UK2 )
934: USE_NL(BAL_ASSACT,BACT,BPTP,START_ASS,ASS,ASSACT,PACT,PPTP,RR,TARGET,FEED) +*/
935: nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
936: 'AN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
937: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
938: 'AA',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
939: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
940: 'BN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)

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

934: USE_NL(BAL_ASSACT,BACT,BPTP,START_ASS,ASS,ASSACT,PACT,PPTP,RR,TARGET,FEED) +*/
935: nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
936: 'AN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
937: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
938: 'AA',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
939: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
940: 'BN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
941: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
942: 'BA',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)

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

936: 'AN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
937: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
938: 'AA',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
939: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
940: 'BN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
941: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
942: 'BA',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
943: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
944: 'CN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)

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

938: 'AA',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
939: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
940: 'BN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
941: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
942: 'BA',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
943: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
944: 'CN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
945: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
946: 'CC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)

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

940: 'BN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
941: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
942: 'BA',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
943: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
944: 'CN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
945: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
946: 'CC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
947: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
948: 'DC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)

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

942: 'BA',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
943: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
944: 'CN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
945: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
946: 'CC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
947: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
948: 'DC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
949: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
950: 'EC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)

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

944: 'CN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
945: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
946: 'CC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
947: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
948: 'DC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
949: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
950: 'EC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
951: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
952: 'FM',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)

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

946: 'CC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
947: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
948: 'DC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
949: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
950: 'EC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
951: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
952: 'FM',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
953: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
954: 'GM',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)

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

948: 'DC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
949: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
950: 'EC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
951: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
952: 'FM',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
953: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
954: 'GM',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
955: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
956: 'JN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)

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

950: 'EC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
951: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
952: 'FM',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
953: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
954: 'GM',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
955: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
956: 'JN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
957: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
958: 'JA',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)

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

952: 'FM',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
953: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
954: 'GM',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
955: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
956: 'JN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
957: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
958: 'JA',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
959: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
960: 'LC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)

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

954: 'GM',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
955: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
956: 'JN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
957: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
958: 'JA',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
959: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
960: 'LC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
961: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
962: 'SM',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)

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

956: 'JN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
957: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
958: 'JA',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
959: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
960: 'LC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
961: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
962: 'SM',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
963: into g_st_ni_a_able , g_st_ni_ap_able , g_st_ni_b_able ,
964: g_st_ni_bp_able, g_st_ni_c_able , g_st_ni_co_able ,

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

958: 'JA',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
959: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
960: 'LC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
961: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
962: 'SM',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
963: into g_st_ni_a_able , g_st_ni_ap_able , g_st_ni_b_able ,
964: g_st_ni_bp_able, g_st_ni_c_able , g_st_ni_co_able ,
965: g_st_ni_d_able , g_st_ni_e_able , g_st_ni_f_able ,
966: g_st_ni_g_able , g_st_ni_j_able, g_st_ni_jp_able,

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

1180: , pay_user_rows R
1181: , pay_user_tables TAB
1182: where TAB.user_table_name = p_user_table
1183: and C.user_column_name = p_user_column
1184: and fnd_number.canonical_to_number(CINST.value)
1185: = fnd_number.canonical_to_number(p_user_value)
1186: and C.user_table_id = TAB.user_table_id
1187: and CINST.user_column_id = C.user_column_id
1188: and R.user_table_id = TAB.user_table_id

Line 1185: = fnd_number.canonical_to_number(p_user_value)

1181: , pay_user_tables TAB
1182: where TAB.user_table_name = p_user_table
1183: and C.user_column_name = p_user_column
1184: and fnd_number.canonical_to_number(CINST.value)
1185: = fnd_number.canonical_to_number(p_user_value)
1186: and C.user_table_id = TAB.user_table_id
1187: and CINST.user_column_id = C.user_column_id
1188: and R.user_table_id = TAB.user_table_id
1189: and TAB.user_key_units = 'N'

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

1207: l_value number;
1208: Begin
1209: l_value := 0;
1210: begin
1211: select fnd_number.canonical_to_number(CINST.value) into l_value from
1212: pay_user_column_instances CINST
1213: , pay_user_column_instances LABEL
1214: , pay_user_columns CLABEL
1215: , pay_user_columns C

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

1250: l_value := 0;
1251: --
1252: begin
1253: select decode(substr(p_high_or_low,1,1),
1254: 'H',fnd_number.canonical_to_number(R.ROW_HIGH_RANGE),
1255: fnd_number.canonical_to_number(R.row_low_range_or_name))
1256: into l_value from
1257: pay_user_column_instances LABEL
1258: , pay_user_columns CLABEL

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

1251: --
1252: begin
1253: select decode(substr(p_high_or_low,1,1),
1254: 'H',fnd_number.canonical_to_number(R.ROW_HIGH_RANGE),
1255: fnd_number.canonical_to_number(R.row_low_range_or_name))
1256: into l_value from
1257: pay_user_column_instances LABEL
1258: , pay_user_columns CLABEL
1259: , pay_user_rows R

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

1286: l_value number;
1287: Begin
1288: l_value := 0;
1289: --
1290: select min(fnd_number.canonical_to_number(CINST.value))
1291: into l_value from
1292: pay_user_column_instances CINST
1293: , pay_user_column_instances LABEL
1294: , pay_user_columns CLABEL

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

1301: and CINST.user_column_id = C.user_column_id
1302: and R.user_table_id = TAB.user_table_id
1303: and TAB.user_key_units = 'N'
1304: and CINST.user_row_id = R.user_row_id
1305: and fnd_number.canonical_to_number(LABEL.value)
1306: = fnd_number.canonical_to_number(p_ci_rate)
1307: and CLABEL.user_column_name = 'C_ERS_RATE_CI'
1308: and CLABEL.user_column_id = LABEL.user_column_id
1309: and CLABEL.user_table_id = TAB.user_table_id

Line 1306: = fnd_number.canonical_to_number(p_ci_rate)

1302: and R.user_table_id = TAB.user_table_id
1303: and TAB.user_key_units = 'N'
1304: and CINST.user_row_id = R.user_row_id
1305: and fnd_number.canonical_to_number(LABEL.value)
1306: = fnd_number.canonical_to_number(p_ci_rate)
1307: and CLABEL.user_column_name = 'C_ERS_RATE_CI'
1308: and CLABEL.user_column_id = LABEL.user_column_id
1309: and CLABEL.user_table_id = TAB.user_table_id
1310: and LABEL.user_row_id = R.user_row_id;

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

1322: l_value number;
1323: Begin
1324: l_value := 0;
1325: --
1326: select min(fnd_number.canonical_to_number(CINST.value))
1327: into l_value from
1328: pay_user_column_instances CINST
1329: , pay_user_column_instances LABEL
1330: , pay_user_columns CLABEL

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

1337: and CINST.user_column_id = C.user_column_id
1338: and R.user_table_id = TAB.user_table_id
1339: and TAB.user_key_units = 'N'
1340: and CINST.user_row_id = R.user_row_id
1341: and fnd_number.canonical_to_number(LABEL.value) = fnd_number.canonical_to_number(p_ci_rate)
1342: and CLABEL.user_column_name = 'C_ERS_RATE_CI'
1343: and CLABEL.user_column_id = LABEL.user_column_id
1344: and CLABEL.user_table_id = TAB.user_table_id
1345: and LABEL.user_row_id = R.user_row_id;

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

2041: TARGET PAY_RUN_RESULT_VALUES_PK,
2042: FEED PAY_BALANCE_FEEDS_F_UK2)
2043: USE_NL(BAL_ASSACT,BACT,BPTP,START_ASS,ASS,ASSACT,PACT,PPTP,RR,TARGET,FEED) +*/
2044: nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2045: 'AN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2046: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2047: 'AA',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2048: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2049: 'BN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)

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

2043: USE_NL(BAL_ASSACT,BACT,BPTP,START_ASS,ASS,ASSACT,PACT,PPTP,RR,TARGET,FEED) +*/
2044: nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2045: 'AN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2046: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2047: 'AA',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2048: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2049: 'BN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2050: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2051: 'BA',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)

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

2045: 'AN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2046: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2047: 'AA',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2048: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2049: 'BN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2050: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2051: 'BA',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2052: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2053: 'CN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)

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

2047: 'AA',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2048: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2049: 'BN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2050: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2051: 'BA',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2052: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2053: 'CN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2054: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2055: 'CC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)

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

2049: 'BN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2050: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2051: 'BA',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2052: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2053: 'CN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2054: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2055: 'CC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2056: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2057: 'DC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)

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

2051: 'BA',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2052: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2053: 'CN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2054: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2055: 'CC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2056: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2057: 'DC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2058: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2059: 'EC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)

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

2053: 'CN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2054: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2055: 'CC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2056: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2057: 'DC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2058: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2059: 'EC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2060: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2061: 'FM',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)

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

2055: 'CC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2056: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2057: 'DC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2058: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2059: 'EC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2060: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2061: 'FM',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2062: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2063: 'GM',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)

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

2057: 'DC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2058: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2059: 'EC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2060: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2061: 'FM',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2062: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2063: 'GM',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2064: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2065: 'JN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)

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

2059: 'EC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2060: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2061: 'FM',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2062: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2063: 'GM',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2064: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2065: 'JN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2066: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2067: 'JA',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)

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

2061: 'FM',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2062: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2063: 'GM',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2064: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2065: 'JN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2066: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2067: 'JA',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2068: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2069: 'LC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)

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

2063: 'GM',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2064: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2065: 'JN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2066: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2067: 'JA',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2068: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2069: 'LC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2070: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2071: 'SM',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)

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

2065: 'JN',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2066: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2067: 'JA',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2068: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2069: 'LC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2070: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2071: 'SM',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2072: into g_st_ni_a_able , g_st_ni_ap_able, g_st_ni_b_able ,
2073: g_st_ni_bp_able, g_st_ni_c_able , g_st_ni_co_able ,

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

2067: 'JA',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2068: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2069: 'LC',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2070: ,nvl(sum(decode(hr_gbnidir.NI_ELEMENT_ENTRY_VALUE(ASSACT.assignment_id, PACT.effective_date),
2071: 'SM',fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale,0)),0)
2072: into g_st_ni_a_able , g_st_ni_ap_able, g_st_ni_b_able ,
2073: g_st_ni_bp_able, g_st_ni_c_able , g_st_ni_co_able ,
2074: g_st_ni_d_able , g_st_ni_e_able , g_st_ni_f_able ,
2075: g_st_ni_g_able , g_st_ni_j_able, g_st_ni_jp_able,