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.HRSPINE dependencies on PAY_PEOPLE_GROUPS

Line 1352: l_seg1 pay_people_groups.segment1%type;

1348: order by segment_num;
1349: --
1350: -- the list of local segments:
1351: --
1352: l_seg1 pay_people_groups.segment1%type;
1353: l_seg2 pay_people_groups.segment2%type;
1354: l_seg3 pay_people_groups.segment3%type;
1355: l_seg4 pay_people_groups.segment4%type;
1356: l_seg5 pay_people_groups.segment5%type;

Line 1353: l_seg2 pay_people_groups.segment2%type;

1349: --
1350: -- the list of local segments:
1351: --
1352: l_seg1 pay_people_groups.segment1%type;
1353: l_seg2 pay_people_groups.segment2%type;
1354: l_seg3 pay_people_groups.segment3%type;
1355: l_seg4 pay_people_groups.segment4%type;
1356: l_seg5 pay_people_groups.segment5%type;
1357: l_seg6 pay_people_groups.segment6%type;

Line 1354: l_seg3 pay_people_groups.segment3%type;

1350: -- the list of local segments:
1351: --
1352: l_seg1 pay_people_groups.segment1%type;
1353: l_seg2 pay_people_groups.segment2%type;
1354: l_seg3 pay_people_groups.segment3%type;
1355: l_seg4 pay_people_groups.segment4%type;
1356: l_seg5 pay_people_groups.segment5%type;
1357: l_seg6 pay_people_groups.segment6%type;
1358: l_seg7 pay_people_groups.segment7%type;

Line 1355: l_seg4 pay_people_groups.segment4%type;

1351: --
1352: l_seg1 pay_people_groups.segment1%type;
1353: l_seg2 pay_people_groups.segment2%type;
1354: l_seg3 pay_people_groups.segment3%type;
1355: l_seg4 pay_people_groups.segment4%type;
1356: l_seg5 pay_people_groups.segment5%type;
1357: l_seg6 pay_people_groups.segment6%type;
1358: l_seg7 pay_people_groups.segment7%type;
1359: l_seg8 pay_people_groups.segment8%type;

Line 1356: l_seg5 pay_people_groups.segment5%type;

1352: l_seg1 pay_people_groups.segment1%type;
1353: l_seg2 pay_people_groups.segment2%type;
1354: l_seg3 pay_people_groups.segment3%type;
1355: l_seg4 pay_people_groups.segment4%type;
1356: l_seg5 pay_people_groups.segment5%type;
1357: l_seg6 pay_people_groups.segment6%type;
1358: l_seg7 pay_people_groups.segment7%type;
1359: l_seg8 pay_people_groups.segment8%type;
1360: l_seg9 pay_people_groups.segment9%type;

Line 1357: l_seg6 pay_people_groups.segment6%type;

1353: l_seg2 pay_people_groups.segment2%type;
1354: l_seg3 pay_people_groups.segment3%type;
1355: l_seg4 pay_people_groups.segment4%type;
1356: l_seg5 pay_people_groups.segment5%type;
1357: l_seg6 pay_people_groups.segment6%type;
1358: l_seg7 pay_people_groups.segment7%type;
1359: l_seg8 pay_people_groups.segment8%type;
1360: l_seg9 pay_people_groups.segment9%type;
1361: l_seg10 pay_people_groups.segment10%type;

Line 1358: l_seg7 pay_people_groups.segment7%type;

1354: l_seg3 pay_people_groups.segment3%type;
1355: l_seg4 pay_people_groups.segment4%type;
1356: l_seg5 pay_people_groups.segment5%type;
1357: l_seg6 pay_people_groups.segment6%type;
1358: l_seg7 pay_people_groups.segment7%type;
1359: l_seg8 pay_people_groups.segment8%type;
1360: l_seg9 pay_people_groups.segment9%type;
1361: l_seg10 pay_people_groups.segment10%type;
1362: l_seg11 pay_people_groups.segment11%type;

Line 1359: l_seg8 pay_people_groups.segment8%type;

1355: l_seg4 pay_people_groups.segment4%type;
1356: l_seg5 pay_people_groups.segment5%type;
1357: l_seg6 pay_people_groups.segment6%type;
1358: l_seg7 pay_people_groups.segment7%type;
1359: l_seg8 pay_people_groups.segment8%type;
1360: l_seg9 pay_people_groups.segment9%type;
1361: l_seg10 pay_people_groups.segment10%type;
1362: l_seg11 pay_people_groups.segment11%type;
1363: l_seg12 pay_people_groups.segment12%type;

Line 1360: l_seg9 pay_people_groups.segment9%type;

1356: l_seg5 pay_people_groups.segment5%type;
1357: l_seg6 pay_people_groups.segment6%type;
1358: l_seg7 pay_people_groups.segment7%type;
1359: l_seg8 pay_people_groups.segment8%type;
1360: l_seg9 pay_people_groups.segment9%type;
1361: l_seg10 pay_people_groups.segment10%type;
1362: l_seg11 pay_people_groups.segment11%type;
1363: l_seg12 pay_people_groups.segment12%type;
1364: l_seg13 pay_people_groups.segment13%type;

Line 1361: l_seg10 pay_people_groups.segment10%type;

1357: l_seg6 pay_people_groups.segment6%type;
1358: l_seg7 pay_people_groups.segment7%type;
1359: l_seg8 pay_people_groups.segment8%type;
1360: l_seg9 pay_people_groups.segment9%type;
1361: l_seg10 pay_people_groups.segment10%type;
1362: l_seg11 pay_people_groups.segment11%type;
1363: l_seg12 pay_people_groups.segment12%type;
1364: l_seg13 pay_people_groups.segment13%type;
1365: l_seg14 pay_people_groups.segment14%type;

Line 1362: l_seg11 pay_people_groups.segment11%type;

1358: l_seg7 pay_people_groups.segment7%type;
1359: l_seg8 pay_people_groups.segment8%type;
1360: l_seg9 pay_people_groups.segment9%type;
1361: l_seg10 pay_people_groups.segment10%type;
1362: l_seg11 pay_people_groups.segment11%type;
1363: l_seg12 pay_people_groups.segment12%type;
1364: l_seg13 pay_people_groups.segment13%type;
1365: l_seg14 pay_people_groups.segment14%type;
1366: l_seg15 pay_people_groups.segment15%type;

Line 1363: l_seg12 pay_people_groups.segment12%type;

1359: l_seg8 pay_people_groups.segment8%type;
1360: l_seg9 pay_people_groups.segment9%type;
1361: l_seg10 pay_people_groups.segment10%type;
1362: l_seg11 pay_people_groups.segment11%type;
1363: l_seg12 pay_people_groups.segment12%type;
1364: l_seg13 pay_people_groups.segment13%type;
1365: l_seg14 pay_people_groups.segment14%type;
1366: l_seg15 pay_people_groups.segment15%type;
1367: l_seg16 pay_people_groups.segment16%type;

Line 1364: l_seg13 pay_people_groups.segment13%type;

1360: l_seg9 pay_people_groups.segment9%type;
1361: l_seg10 pay_people_groups.segment10%type;
1362: l_seg11 pay_people_groups.segment11%type;
1363: l_seg12 pay_people_groups.segment12%type;
1364: l_seg13 pay_people_groups.segment13%type;
1365: l_seg14 pay_people_groups.segment14%type;
1366: l_seg15 pay_people_groups.segment15%type;
1367: l_seg16 pay_people_groups.segment16%type;
1368: l_seg17 pay_people_groups.segment17%type;

Line 1365: l_seg14 pay_people_groups.segment14%type;

1361: l_seg10 pay_people_groups.segment10%type;
1362: l_seg11 pay_people_groups.segment11%type;
1363: l_seg12 pay_people_groups.segment12%type;
1364: l_seg13 pay_people_groups.segment13%type;
1365: l_seg14 pay_people_groups.segment14%type;
1366: l_seg15 pay_people_groups.segment15%type;
1367: l_seg16 pay_people_groups.segment16%type;
1368: l_seg17 pay_people_groups.segment17%type;
1369: l_seg18 pay_people_groups.segment18%type;

Line 1366: l_seg15 pay_people_groups.segment15%type;

1362: l_seg11 pay_people_groups.segment11%type;
1363: l_seg12 pay_people_groups.segment12%type;
1364: l_seg13 pay_people_groups.segment13%type;
1365: l_seg14 pay_people_groups.segment14%type;
1366: l_seg15 pay_people_groups.segment15%type;
1367: l_seg16 pay_people_groups.segment16%type;
1368: l_seg17 pay_people_groups.segment17%type;
1369: l_seg18 pay_people_groups.segment18%type;
1370: l_seg19 pay_people_groups.segment19%type;

Line 1367: l_seg16 pay_people_groups.segment16%type;

1363: l_seg12 pay_people_groups.segment12%type;
1364: l_seg13 pay_people_groups.segment13%type;
1365: l_seg14 pay_people_groups.segment14%type;
1366: l_seg15 pay_people_groups.segment15%type;
1367: l_seg16 pay_people_groups.segment16%type;
1368: l_seg17 pay_people_groups.segment17%type;
1369: l_seg18 pay_people_groups.segment18%type;
1370: l_seg19 pay_people_groups.segment19%type;
1371: l_seg20 pay_people_groups.segment20%type;

Line 1368: l_seg17 pay_people_groups.segment17%type;

1364: l_seg13 pay_people_groups.segment13%type;
1365: l_seg14 pay_people_groups.segment14%type;
1366: l_seg15 pay_people_groups.segment15%type;
1367: l_seg16 pay_people_groups.segment16%type;
1368: l_seg17 pay_people_groups.segment17%type;
1369: l_seg18 pay_people_groups.segment18%type;
1370: l_seg19 pay_people_groups.segment19%type;
1371: l_seg20 pay_people_groups.segment20%type;
1372: l_seg21 pay_people_groups.segment21%type;

Line 1369: l_seg18 pay_people_groups.segment18%type;

1365: l_seg14 pay_people_groups.segment14%type;
1366: l_seg15 pay_people_groups.segment15%type;
1367: l_seg16 pay_people_groups.segment16%type;
1368: l_seg17 pay_people_groups.segment17%type;
1369: l_seg18 pay_people_groups.segment18%type;
1370: l_seg19 pay_people_groups.segment19%type;
1371: l_seg20 pay_people_groups.segment20%type;
1372: l_seg21 pay_people_groups.segment21%type;
1373: l_seg22 pay_people_groups.segment22%type;

Line 1370: l_seg19 pay_people_groups.segment19%type;

1366: l_seg15 pay_people_groups.segment15%type;
1367: l_seg16 pay_people_groups.segment16%type;
1368: l_seg17 pay_people_groups.segment17%type;
1369: l_seg18 pay_people_groups.segment18%type;
1370: l_seg19 pay_people_groups.segment19%type;
1371: l_seg20 pay_people_groups.segment20%type;
1372: l_seg21 pay_people_groups.segment21%type;
1373: l_seg22 pay_people_groups.segment22%type;
1374: l_seg23 pay_people_groups.segment23%type;

Line 1371: l_seg20 pay_people_groups.segment20%type;

1367: l_seg16 pay_people_groups.segment16%type;
1368: l_seg17 pay_people_groups.segment17%type;
1369: l_seg18 pay_people_groups.segment18%type;
1370: l_seg19 pay_people_groups.segment19%type;
1371: l_seg20 pay_people_groups.segment20%type;
1372: l_seg21 pay_people_groups.segment21%type;
1373: l_seg22 pay_people_groups.segment22%type;
1374: l_seg23 pay_people_groups.segment23%type;
1375: l_seg24 pay_people_groups.segment24%type;

Line 1372: l_seg21 pay_people_groups.segment21%type;

1368: l_seg17 pay_people_groups.segment17%type;
1369: l_seg18 pay_people_groups.segment18%type;
1370: l_seg19 pay_people_groups.segment19%type;
1371: l_seg20 pay_people_groups.segment20%type;
1372: l_seg21 pay_people_groups.segment21%type;
1373: l_seg22 pay_people_groups.segment22%type;
1374: l_seg23 pay_people_groups.segment23%type;
1375: l_seg24 pay_people_groups.segment24%type;
1376: l_seg25 pay_people_groups.segment25%type;

Line 1373: l_seg22 pay_people_groups.segment22%type;

1369: l_seg18 pay_people_groups.segment18%type;
1370: l_seg19 pay_people_groups.segment19%type;
1371: l_seg20 pay_people_groups.segment20%type;
1372: l_seg21 pay_people_groups.segment21%type;
1373: l_seg22 pay_people_groups.segment22%type;
1374: l_seg23 pay_people_groups.segment23%type;
1375: l_seg24 pay_people_groups.segment24%type;
1376: l_seg25 pay_people_groups.segment25%type;
1377: l_seg26 pay_people_groups.segment26%type;

Line 1374: l_seg23 pay_people_groups.segment23%type;

1370: l_seg19 pay_people_groups.segment19%type;
1371: l_seg20 pay_people_groups.segment20%type;
1372: l_seg21 pay_people_groups.segment21%type;
1373: l_seg22 pay_people_groups.segment22%type;
1374: l_seg23 pay_people_groups.segment23%type;
1375: l_seg24 pay_people_groups.segment24%type;
1376: l_seg25 pay_people_groups.segment25%type;
1377: l_seg26 pay_people_groups.segment26%type;
1378: l_seg27 pay_people_groups.segment27%type;

Line 1375: l_seg24 pay_people_groups.segment24%type;

1371: l_seg20 pay_people_groups.segment20%type;
1372: l_seg21 pay_people_groups.segment21%type;
1373: l_seg22 pay_people_groups.segment22%type;
1374: l_seg23 pay_people_groups.segment23%type;
1375: l_seg24 pay_people_groups.segment24%type;
1376: l_seg25 pay_people_groups.segment25%type;
1377: l_seg26 pay_people_groups.segment26%type;
1378: l_seg27 pay_people_groups.segment27%type;
1379: l_seg28 pay_people_groups.segment28%type;

Line 1376: l_seg25 pay_people_groups.segment25%type;

1372: l_seg21 pay_people_groups.segment21%type;
1373: l_seg22 pay_people_groups.segment22%type;
1374: l_seg23 pay_people_groups.segment23%type;
1375: l_seg24 pay_people_groups.segment24%type;
1376: l_seg25 pay_people_groups.segment25%type;
1377: l_seg26 pay_people_groups.segment26%type;
1378: l_seg27 pay_people_groups.segment27%type;
1379: l_seg28 pay_people_groups.segment28%type;
1380: l_seg29 pay_people_groups.segment29%type;

Line 1377: l_seg26 pay_people_groups.segment26%type;

1373: l_seg22 pay_people_groups.segment22%type;
1374: l_seg23 pay_people_groups.segment23%type;
1375: l_seg24 pay_people_groups.segment24%type;
1376: l_seg25 pay_people_groups.segment25%type;
1377: l_seg26 pay_people_groups.segment26%type;
1378: l_seg27 pay_people_groups.segment27%type;
1379: l_seg28 pay_people_groups.segment28%type;
1380: l_seg29 pay_people_groups.segment29%type;
1381: l_seg30 pay_people_groups.segment30%type;

Line 1378: l_seg27 pay_people_groups.segment27%type;

1374: l_seg23 pay_people_groups.segment23%type;
1375: l_seg24 pay_people_groups.segment24%type;
1376: l_seg25 pay_people_groups.segment25%type;
1377: l_seg26 pay_people_groups.segment26%type;
1378: l_seg27 pay_people_groups.segment27%type;
1379: l_seg28 pay_people_groups.segment28%type;
1380: l_seg29 pay_people_groups.segment29%type;
1381: l_seg30 pay_people_groups.segment30%type;
1382: --

Line 1379: l_seg28 pay_people_groups.segment28%type;

1375: l_seg24 pay_people_groups.segment24%type;
1376: l_seg25 pay_people_groups.segment25%type;
1377: l_seg26 pay_people_groups.segment26%type;
1378: l_seg27 pay_people_groups.segment27%type;
1379: l_seg28 pay_people_groups.segment28%type;
1380: l_seg29 pay_people_groups.segment29%type;
1381: l_seg30 pay_people_groups.segment30%type;
1382: --
1383: l_seg_value pay_people_groups.segment1%type;

Line 1380: l_seg29 pay_people_groups.segment29%type;

1376: l_seg25 pay_people_groups.segment25%type;
1377: l_seg26 pay_people_groups.segment26%type;
1378: l_seg27 pay_people_groups.segment27%type;
1379: l_seg28 pay_people_groups.segment28%type;
1380: l_seg29 pay_people_groups.segment29%type;
1381: l_seg30 pay_people_groups.segment30%type;
1382: --
1383: l_seg_value pay_people_groups.segment1%type;
1384: l_concat_sep varchar2(1); -- the concatenated delimiter

Line 1381: l_seg30 pay_people_groups.segment30%type;

1377: l_seg26 pay_people_groups.segment26%type;
1378: l_seg27 pay_people_groups.segment27%type;
1379: l_seg28 pay_people_groups.segment28%type;
1380: l_seg29 pay_people_groups.segment29%type;
1381: l_seg30 pay_people_groups.segment30%type;
1382: --
1383: l_seg_value pay_people_groups.segment1%type;
1384: l_concat_sep varchar2(1); -- the concatenated delimiter
1385: l_count number := 0; -- the count of the individual segments

Line 1383: l_seg_value pay_people_groups.segment1%type;

1379: l_seg28 pay_people_groups.segment28%type;
1380: l_seg29 pay_people_groups.segment29%type;
1381: l_seg30 pay_people_groups.segment30%type;
1382: --
1383: l_seg_value pay_people_groups.segment1%type;
1384: l_concat_sep varchar2(1); -- the concatenated delimiter
1385: l_count number := 0; -- the count of the individual segments
1386: l_pos number := 1; -- the position of the individual segment
1387: l_pos_sep number; -- the position of the separator

Line 1578: pay_people_groups ppg,

1574: spp.effective_start_date,
1575: spp.effective_end_date,
1576: pgs.grade_spine_id
1577: FROM per_all_assignments_f asg,
1578: pay_people_groups ppg,
1579: per_grade_spines_f pgs,
1580: per_spinal_points psp1,
1581: per_spinal_point_steps_f sps1,
1582: per_spinal_points psp,

Line 1847: -- segment order as held on the table pay_people_groups

1843: ||p_id_flex_num, 1900);
1844: END;
1845: --
1846: -- loop through for each segment, and re-arrange into the correct
1847: -- segment order as held on the table pay_people_groups
1848: --
1849: for c1rec in c1 loop
1850: l_count := l_count + 1;
1851: l_pos_sep := instr (p_concat_segs, l_concat_sep, 1, l_count);