APPS.BEN_TCS_STMT_PROCESS dependencies on BEN_TCS_PER_ITEM_S

Line 1143: ( ben_tcs_per_item_s.NEXTVAL ,

1139: assignment_id,
1140: uom ,
1141: nnmntry_uom )
1142: VALUES
1143: ( ben_tcs_per_item_s.NEXTVAL ,
1144: ben_tcs_asg_stmt_s.CURRVAL ,
1145: p_stmt_id,
1146: item_id_process.item_id,
1147: p_person_id,

Line 1186: ben_tcs_per_item_s.CURRVAL ,

1182: source_cd,
1183: display_date)
1184: VALUES
1185: ( ben_tcs_per_item_value_s.NEXTVAL ,
1186: ben_tcs_per_item_s.CURRVAL ,
1187: l_result(i).start_date,
1188: l_result(i).end_date ,
1189: i,
1190: to_date(l_result(i).value,'yyyy/mm/dd'),

Line 1225: ben_tcs_per_item_s.CURRVAL ,

1221: source_cd,
1222: display_date)
1223: VALUES
1224: ( ben_tcs_per_item_value_s.NEXTVAL ,
1225: ben_tcs_per_item_s.CURRVAL ,
1226: l_result(i).start_date,
1227: l_result(i).end_date ,
1228: i,
1229: l_result(i).value,

Line 1249: ben_tcs_per_item_s.CURRVAL ,

1245: source_cd,
1246: display_date)
1247: VALUES
1248: ( ben_tcs_per_item_value_s.NEXTVAL ,
1249: ben_tcs_per_item_s.CURRVAL ,
1250: l_result(i).start_date,
1251: l_result(i).end_date ,
1252: i,
1253: fnd_number.canonical_to_number(l_result(i).value),

Line 1313: ben_tcs_per_item_s.CURRVAL ,

1309: source_cd,
1310: display_date)
1311: VALUES
1312: ( ben_tcs_per_item_value_s.NEXTVAL ,
1313: ben_tcs_per_item_s.CURRVAL ,
1314: l_result(i).start_date,
1315: l_result(i).end_date ,
1316: i,
1317: fnd_date.canonical_to_date(l_result(i).value),

Line 1337: ben_tcs_per_item_s.CURRVAL ,

1333: source_cd,
1334: display_date)
1335: VALUES
1336: ( ben_tcs_per_item_value_s.NEXTVAL ,
1337: ben_tcs_per_item_s.CURRVAL ,
1338: l_result(i).start_date,
1339: l_result(i).end_date ,
1340: i,
1341: l_result(i).value,

Line 1376: ben_tcs_per_item_s.CURRVAL ,

1372: source_cd,
1373: display_date)
1374: VALUES
1375: ( ben_tcs_per_item_value_s.NEXTVAL ,
1376: ben_tcs_per_item_s.CURRVAL ,
1377: l_result(i).start_date,
1378: l_result(i).end_date ,
1379: i,
1380: fnd_number.canonical_to_number(l_result(i).value),