APPS.BEN_TCS_STMT_PROCESS dependencies on BEN_TCS_PER_ITEM_S

Line 1151: ( ben_tcs_per_item_s.NEXTVAL ,

1147: assignment_id,
1148: uom ,
1149: nnmntry_uom )
1150: VALUES
1151: ( ben_tcs_per_item_s.NEXTVAL ,
1152: ben_tcs_asg_stmt_s.CURRVAL ,
1153: p_stmt_id,
1154: item_id_process.item_id,
1155: p_person_id,

Line 1194: ben_tcs_per_item_s.CURRVAL ,

1190: source_cd,
1191: display_date)
1192: VALUES
1193: ( ben_tcs_per_item_value_s.NEXTVAL ,
1194: ben_tcs_per_item_s.CURRVAL ,
1195: l_result(i).start_date,
1196: l_result(i).end_date ,
1197: i,
1198: to_date(l_result(i).value,'yyyy/mm/dd'),

Line 1233: ben_tcs_per_item_s.CURRVAL ,

1229: source_cd,
1230: display_date)
1231: VALUES
1232: ( ben_tcs_per_item_value_s.NEXTVAL ,
1233: ben_tcs_per_item_s.CURRVAL ,
1234: l_result(i).start_date,
1235: l_result(i).end_date ,
1236: i,
1237: l_result(i).value,

Line 1257: ben_tcs_per_item_s.CURRVAL ,

1253: source_cd,
1254: display_date)
1255: VALUES
1256: ( ben_tcs_per_item_value_s.NEXTVAL ,
1257: ben_tcs_per_item_s.CURRVAL ,
1258: l_result(i).start_date,
1259: l_result(i).end_date ,
1260: i,
1261: fnd_number.canonical_to_number(l_result(i).value),

Line 1321: ben_tcs_per_item_s.CURRVAL ,

1317: source_cd,
1318: display_date)
1319: VALUES
1320: ( ben_tcs_per_item_value_s.NEXTVAL ,
1321: ben_tcs_per_item_s.CURRVAL ,
1322: l_result(i).start_date,
1323: l_result(i).end_date ,
1324: i,
1325: fnd_date.canonical_to_date(l_result(i).value),

Line 1345: ben_tcs_per_item_s.CURRVAL ,

1341: source_cd,
1342: display_date)
1343: VALUES
1344: ( ben_tcs_per_item_value_s.NEXTVAL ,
1345: ben_tcs_per_item_s.CURRVAL ,
1346: l_result(i).start_date,
1347: l_result(i).end_date ,
1348: i,
1349: l_result(i).value,

Line 1384: ben_tcs_per_item_s.CURRVAL ,

1380: source_cd,
1381: display_date)
1382: VALUES
1383: ( ben_tcs_per_item_value_s.NEXTVAL ,
1384: ben_tcs_per_item_s.CURRVAL ,
1385: l_result(i).start_date,
1386: l_result(i).end_date ,
1387: i,
1388: fnd_number.canonical_to_number(l_result(i).value),