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.PQH_FR_UTILITY dependencies on HR_SOFT_CODING_KEYFLEX

Line 1041: hr_soft_coding_keyflex scl,

1037: scl.segment8 "EMP_STAT_SITUATION_ID",
1038: sps.step_id "STEP_ID",
1039: sps.information4 "PGI"
1040: FROM per_all_assignments_f asg,
1041: hr_soft_coding_keyflex scl,
1042: per_spinal_point_placements_f sps
1043: WHERE asg.assignment_id = p_assignment_id
1044: AND p_effective_date BETWEEN asg.effective_start_date and asg.effective_end_date
1045: AND asg.soft_coding_keyflex_id = scl.soft_coding_keyflex_id

Line 1181: from per_all_assignments_f assign, hr_soft_coding_keyflex scl

1177: assign.frequency Frequency,
1178: nvl(assign.supervisor_id,-999) Supervisor,
1179: assign.effective_start_date,
1180: assign.assignment_status_type_id
1181: from per_all_assignments_f assign, hr_soft_coding_keyflex scl
1182: WHERE assign.person_id = p_assignment_id
1183: AND assign.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
1184: AND assign.primary_flag ='N'
1185: AND assign.assignment_status_type_id <> 3

Line 1199: hr_soft_coding_keyflex scl,

1195: nvl(asg.frequency,'-999') frequency,
1196: nvl(scl.segment19,'-999') reason,
1197: nvl(scl.segment9,'-999') share_part
1198: FROM per_all_assignments_f asg,
1199: hr_soft_coding_keyflex scl,
1200: per_shared_types pst
1201: WHERE asg.assignment_id = p_assignment_id
1202: AND pst.shared_type_id(+) = scl.segment9
1203: AND asg.soft_coding_keyflex_id = scl.soft_coding_keyflex_id(+)

Line 1214: ,hr_soft_coding_keyflex scl

1210: ,scl.segment10 employment_category
1211: ,NVL(asg.grade_ladder_pgm_id,-1) grade_ladder_pgm_id
1212: ,NVL(asg.grade_id,-1) grade_id
1213: FROM per_all_assignments_f asg
1214: ,hr_soft_coding_keyflex scl
1215: WHERE asg.assignment_id = p_assignment_id
1216: AND asg.soft_coding_keyflex_id = scl.soft_coding_keyflex_id(+)
1217: AND(asg.effective_start_date = p_start_date
1218: OR l_start_date BETWEEN asg.effective_start_date AND asg.effective_end_date)

Line 1229: l_reason hr_soft_coding_keyflex.segment19%type;

1225: l_supervisor_id per_all_assignments_f.supervisor_id%type;
1226: l_position per_all_assignments_f.position_id%type;
1227: l_frequency per_all_assignments_f.frequency%type;
1228: l_establish per_all_assignments_f.establishment_id%type;
1229: l_reason hr_soft_coding_keyflex.segment19%type;
1230: l_share hr_soft_coding_keyflex.segment9%type;
1231: l_seg26 hr_soft_coding_keyflex.segment26%type;
1232: l_seg27 hr_soft_coding_keyflex.segment27%type;
1233: l_identifier hr_soft_coding_keyflex.segment9%type;

Line 1230: l_share hr_soft_coding_keyflex.segment9%type;

1226: l_position per_all_assignments_f.position_id%type;
1227: l_frequency per_all_assignments_f.frequency%type;
1228: l_establish per_all_assignments_f.establishment_id%type;
1229: l_reason hr_soft_coding_keyflex.segment19%type;
1230: l_share hr_soft_coding_keyflex.segment9%type;
1231: l_seg26 hr_soft_coding_keyflex.segment26%type;
1232: l_seg27 hr_soft_coding_keyflex.segment27%type;
1233: l_identifier hr_soft_coding_keyflex.segment9%type;
1234: l_type hr_soft_coding_keyflex.segment9%type;

Line 1231: l_seg26 hr_soft_coding_keyflex.segment26%type;

1227: l_frequency per_all_assignments_f.frequency%type;
1228: l_establish per_all_assignments_f.establishment_id%type;
1229: l_reason hr_soft_coding_keyflex.segment19%type;
1230: l_share hr_soft_coding_keyflex.segment9%type;
1231: l_seg26 hr_soft_coding_keyflex.segment26%type;
1232: l_seg27 hr_soft_coding_keyflex.segment27%type;
1233: l_identifier hr_soft_coding_keyflex.segment9%type;
1234: l_type hr_soft_coding_keyflex.segment9%type;
1235: l_percent number;

Line 1232: l_seg27 hr_soft_coding_keyflex.segment27%type;

1228: l_establish per_all_assignments_f.establishment_id%type;
1229: l_reason hr_soft_coding_keyflex.segment19%type;
1230: l_share hr_soft_coding_keyflex.segment9%type;
1231: l_seg26 hr_soft_coding_keyflex.segment26%type;
1232: l_seg27 hr_soft_coding_keyflex.segment27%type;
1233: l_identifier hr_soft_coding_keyflex.segment9%type;
1234: l_type hr_soft_coding_keyflex.segment9%type;
1235: l_percent number;
1236: l_category per_all_assignments_f.employment_category%type;

Line 1233: l_identifier hr_soft_coding_keyflex.segment9%type;

1229: l_reason hr_soft_coding_keyflex.segment19%type;
1230: l_share hr_soft_coding_keyflex.segment9%type;
1231: l_seg26 hr_soft_coding_keyflex.segment26%type;
1232: l_seg27 hr_soft_coding_keyflex.segment27%type;
1233: l_identifier hr_soft_coding_keyflex.segment9%type;
1234: l_type hr_soft_coding_keyflex.segment9%type;
1235: l_percent number;
1236: l_category per_all_assignments_f.employment_category%type;
1237: l_assignment_status_type_id per_all_assignments_f.assignment_status_type_id%type;

Line 1234: l_type hr_soft_coding_keyflex.segment9%type;

1230: l_share hr_soft_coding_keyflex.segment9%type;
1231: l_seg26 hr_soft_coding_keyflex.segment26%type;
1232: l_seg27 hr_soft_coding_keyflex.segment27%type;
1233: l_identifier hr_soft_coding_keyflex.segment9%type;
1234: l_type hr_soft_coding_keyflex.segment9%type;
1235: l_percent number;
1236: l_category per_all_assignments_f.employment_category%type;
1237: l_assignment_status_type_id per_all_assignments_f.assignment_status_type_id%type;
1238: l_emp_catg hr_soft_coding_keyflex.segment10%type;

Line 1238: l_emp_catg hr_soft_coding_keyflex.segment10%type;

1234: l_type hr_soft_coding_keyflex.segment9%type;
1235: l_percent number;
1236: l_category per_all_assignments_f.employment_category%type;
1237: l_assignment_status_type_id per_all_assignments_f.assignment_status_type_id%type;
1238: l_emp_catg hr_soft_coding_keyflex.segment10%type;
1239: l_grd_ldr_pgm_id per_all_assignments_f.grade_ladder_pgm_id%type;
1240: l_grd_id per_all_assignments_f.grade_id%type;
1241:
1242: l_old_normal_hours per_all_assignments_f.normal_hours%type;

Line 1247: l_old_reason hr_soft_coding_keyflex.segment19%type;

1243: l_old_supervisor_id per_all_assignments_f.supervisor_id%type;
1244: l_old_position per_all_assignments_f.position_id%type;
1245: l_old_frequency per_all_assignments_f.frequency%type;
1246: l_old_establish per_all_assignments_f.establishment_id%type;
1247: l_old_reason hr_soft_coding_keyflex.segment19%type;
1248: l_old_share hr_soft_coding_keyflex.segment9%type;
1249: l_old_seg26 hr_soft_coding_keyflex.segment26%type;
1250: l_old_seg27 hr_soft_coding_keyflex.segment27%type;
1251: l_old_identifier hr_soft_coding_keyflex.segment9%type;

Line 1248: l_old_share hr_soft_coding_keyflex.segment9%type;

1244: l_old_position per_all_assignments_f.position_id%type;
1245: l_old_frequency per_all_assignments_f.frequency%type;
1246: l_old_establish per_all_assignments_f.establishment_id%type;
1247: l_old_reason hr_soft_coding_keyflex.segment19%type;
1248: l_old_share hr_soft_coding_keyflex.segment9%type;
1249: l_old_seg26 hr_soft_coding_keyflex.segment26%type;
1250: l_old_seg27 hr_soft_coding_keyflex.segment27%type;
1251: l_old_identifier hr_soft_coding_keyflex.segment9%type;
1252: l_old_type hr_soft_coding_keyflex.segment9%type;

Line 1249: l_old_seg26 hr_soft_coding_keyflex.segment26%type;

1245: l_old_frequency per_all_assignments_f.frequency%type;
1246: l_old_establish per_all_assignments_f.establishment_id%type;
1247: l_old_reason hr_soft_coding_keyflex.segment19%type;
1248: l_old_share hr_soft_coding_keyflex.segment9%type;
1249: l_old_seg26 hr_soft_coding_keyflex.segment26%type;
1250: l_old_seg27 hr_soft_coding_keyflex.segment27%type;
1251: l_old_identifier hr_soft_coding_keyflex.segment9%type;
1252: l_old_type hr_soft_coding_keyflex.segment9%type;
1253: l_old_percent number;

Line 1250: l_old_seg27 hr_soft_coding_keyflex.segment27%type;

1246: l_old_establish per_all_assignments_f.establishment_id%type;
1247: l_old_reason hr_soft_coding_keyflex.segment19%type;
1248: l_old_share hr_soft_coding_keyflex.segment9%type;
1249: l_old_seg26 hr_soft_coding_keyflex.segment26%type;
1250: l_old_seg27 hr_soft_coding_keyflex.segment27%type;
1251: l_old_identifier hr_soft_coding_keyflex.segment9%type;
1252: l_old_type hr_soft_coding_keyflex.segment9%type;
1253: l_old_percent number;
1254: l_old_category per_all_assignments_f.employment_category%type;

Line 1251: l_old_identifier hr_soft_coding_keyflex.segment9%type;

1247: l_old_reason hr_soft_coding_keyflex.segment19%type;
1248: l_old_share hr_soft_coding_keyflex.segment9%type;
1249: l_old_seg26 hr_soft_coding_keyflex.segment26%type;
1250: l_old_seg27 hr_soft_coding_keyflex.segment27%type;
1251: l_old_identifier hr_soft_coding_keyflex.segment9%type;
1252: l_old_type hr_soft_coding_keyflex.segment9%type;
1253: l_old_percent number;
1254: l_old_category per_all_assignments_f.employment_category%type;
1255: l_old_assign_status_type_id per_all_assignments_f.assignment_status_type_id%type;

Line 1252: l_old_type hr_soft_coding_keyflex.segment9%type;

1248: l_old_share hr_soft_coding_keyflex.segment9%type;
1249: l_old_seg26 hr_soft_coding_keyflex.segment26%type;
1250: l_old_seg27 hr_soft_coding_keyflex.segment27%type;
1251: l_old_identifier hr_soft_coding_keyflex.segment9%type;
1252: l_old_type hr_soft_coding_keyflex.segment9%type;
1253: l_old_percent number;
1254: l_old_category per_all_assignments_f.employment_category%type;
1255: l_old_assign_status_type_id per_all_assignments_f.assignment_status_type_id%type;
1256: l_old_emp_catg hr_soft_coding_keyflex.segment10%type;

Line 1256: l_old_emp_catg hr_soft_coding_keyflex.segment10%type;

1252: l_old_type hr_soft_coding_keyflex.segment9%type;
1253: l_old_percent number;
1254: l_old_category per_all_assignments_f.employment_category%type;
1255: l_old_assign_status_type_id per_all_assignments_f.assignment_status_type_id%type;
1256: l_old_emp_catg hr_soft_coding_keyflex.segment10%type;
1257: l_old_grd_ldr_pgm_id per_all_assignments_f.grade_ladder_pgm_id%type;
1258: l_old_grd_id per_all_assignments_f.grade_id%type;
1259:
1260: begin

Line 1483: hr_soft_coding_keyflex scl,

1479: --Cursor to check whether different Corp Affectations exist
1480: CURSOR csr_diff_corps_asg IS
1481: SELECT 'Y'
1482: FROM per_all_assignments_f asg,
1483: hr_soft_coding_keyflex scl,
1484: per_assignment_status_types ast
1485: WHERE scl.segment26 = to_char(p_primary_assign_id) --changed for bug 7211180
1486: AND asg.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
1487: AND ast.per_system_status = 'ACTIVE_ASSIGN'

Line 1688: from per_all_assignments_f assign, hr_soft_coding_keyflex scl

1684: nvl(assign.supervisor_id,-999) Supervisor,
1685: assign.effective_start_date,
1686: assign.assignment_status_type_id,
1687: assign.effective_end_date
1688: from per_all_assignments_f assign, hr_soft_coding_keyflex scl
1689: WHERE assign.person_id = p_person_id
1690: AND assign.assignment_id = l_assignment_id
1691: AND assign.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
1692: AND assign.primary_flag ='N'

Line 1714: hr_soft_coding_keyflex scl,

1710: nvl(scl.segment19,'-999') reason,
1711: nvl(scl.segment9,'-999') share_part,
1712: asg.effective_end_date effective_end_date
1713: FROM per_all_assignments_f asg,
1714: hr_soft_coding_keyflex scl,
1715: per_shared_types pst
1716: WHERE asg.assignment_id = p_assignment_id
1717: AND pst.shared_type_id(+) = scl.segment9
1718: AND asg.soft_coding_keyflex_id = scl.soft_coding_keyflex_id(+)

Line 1730: ,hr_soft_coding_keyflex scl

1726: ,NVL(asg.grade_ladder_pgm_id,-1) grade_ladder_pgm_id
1727: ,NVL(asg.grade_id,-1) grade_id
1728: ,asg.effective_end_date effective_end_date
1729: FROM per_all_assignments_f asg
1730: ,hr_soft_coding_keyflex scl
1731: WHERE asg.assignment_id = p_assignment_id
1732: AND asg.soft_coding_keyflex_id = scl.soft_coding_keyflex_id(+)
1733: AND(asg.effective_start_date = p_start_date
1734: OR asg.effective_start_date > l_end_date)

Line 1747: l_reason hr_soft_coding_keyflex.segment19%type;

1743: l_supervisor_id per_all_assignments_f.supervisor_id%type;
1744: l_position per_all_assignments_f.position_id%type;
1745: l_frequency per_all_assignments_f.frequency%type;
1746: l_establish per_all_assignments_f.establishment_id%type;
1747: l_reason hr_soft_coding_keyflex.segment19%type;
1748: l_share hr_soft_coding_keyflex.segment9%type;
1749: l_seg26 hr_soft_coding_keyflex.segment26%type;
1750: l_seg27 hr_soft_coding_keyflex.segment27%type;
1751: l_identifier hr_soft_coding_keyflex.segment9%type;

Line 1748: l_share hr_soft_coding_keyflex.segment9%type;

1744: l_position per_all_assignments_f.position_id%type;
1745: l_frequency per_all_assignments_f.frequency%type;
1746: l_establish per_all_assignments_f.establishment_id%type;
1747: l_reason hr_soft_coding_keyflex.segment19%type;
1748: l_share hr_soft_coding_keyflex.segment9%type;
1749: l_seg26 hr_soft_coding_keyflex.segment26%type;
1750: l_seg27 hr_soft_coding_keyflex.segment27%type;
1751: l_identifier hr_soft_coding_keyflex.segment9%type;
1752: l_type hr_soft_coding_keyflex.segment9%type;

Line 1749: l_seg26 hr_soft_coding_keyflex.segment26%type;

1745: l_frequency per_all_assignments_f.frequency%type;
1746: l_establish per_all_assignments_f.establishment_id%type;
1747: l_reason hr_soft_coding_keyflex.segment19%type;
1748: l_share hr_soft_coding_keyflex.segment9%type;
1749: l_seg26 hr_soft_coding_keyflex.segment26%type;
1750: l_seg27 hr_soft_coding_keyflex.segment27%type;
1751: l_identifier hr_soft_coding_keyflex.segment9%type;
1752: l_type hr_soft_coding_keyflex.segment9%type;
1753: l_percent number;

Line 1750: l_seg27 hr_soft_coding_keyflex.segment27%type;

1746: l_establish per_all_assignments_f.establishment_id%type;
1747: l_reason hr_soft_coding_keyflex.segment19%type;
1748: l_share hr_soft_coding_keyflex.segment9%type;
1749: l_seg26 hr_soft_coding_keyflex.segment26%type;
1750: l_seg27 hr_soft_coding_keyflex.segment27%type;
1751: l_identifier hr_soft_coding_keyflex.segment9%type;
1752: l_type hr_soft_coding_keyflex.segment9%type;
1753: l_percent number;
1754: l_category per_all_assignments_f.employment_category%type;

Line 1751: l_identifier hr_soft_coding_keyflex.segment9%type;

1747: l_reason hr_soft_coding_keyflex.segment19%type;
1748: l_share hr_soft_coding_keyflex.segment9%type;
1749: l_seg26 hr_soft_coding_keyflex.segment26%type;
1750: l_seg27 hr_soft_coding_keyflex.segment27%type;
1751: l_identifier hr_soft_coding_keyflex.segment9%type;
1752: l_type hr_soft_coding_keyflex.segment9%type;
1753: l_percent number;
1754: l_category per_all_assignments_f.employment_category%type;
1755: l_assignment_status_type_id per_all_assignments_f.assignment_status_type_id%type;

Line 1752: l_type hr_soft_coding_keyflex.segment9%type;

1748: l_share hr_soft_coding_keyflex.segment9%type;
1749: l_seg26 hr_soft_coding_keyflex.segment26%type;
1750: l_seg27 hr_soft_coding_keyflex.segment27%type;
1751: l_identifier hr_soft_coding_keyflex.segment9%type;
1752: l_type hr_soft_coding_keyflex.segment9%type;
1753: l_percent number;
1754: l_category per_all_assignments_f.employment_category%type;
1755: l_assignment_status_type_id per_all_assignments_f.assignment_status_type_id%type;
1756: l_grd_ldr_pgm_id per_all_assignments_f.grade_ladder_pgm_id%type;

Line 1765: l_fut_reason hr_soft_coding_keyflex.segment19%type;

1761: l_fut_supervisor_id per_all_assignments_f.supervisor_id%type;
1762: l_fut_position per_all_assignments_f.position_id%type;
1763: l_fut_frequency per_all_assignments_f.frequency%type;
1764: l_fut_establish per_all_assignments_f.establishment_id%type;
1765: l_fut_reason hr_soft_coding_keyflex.segment19%type;
1766: l_fut_share hr_soft_coding_keyflex.segment9%type;
1767: l_fut_seg26 hr_soft_coding_keyflex.segment26%type;
1768: l_fut_seg27 hr_soft_coding_keyflex.segment27%type;
1769: l_fut_identifier hr_soft_coding_keyflex.segment9%type;

Line 1766: l_fut_share hr_soft_coding_keyflex.segment9%type;

1762: l_fut_position per_all_assignments_f.position_id%type;
1763: l_fut_frequency per_all_assignments_f.frequency%type;
1764: l_fut_establish per_all_assignments_f.establishment_id%type;
1765: l_fut_reason hr_soft_coding_keyflex.segment19%type;
1766: l_fut_share hr_soft_coding_keyflex.segment9%type;
1767: l_fut_seg26 hr_soft_coding_keyflex.segment26%type;
1768: l_fut_seg27 hr_soft_coding_keyflex.segment27%type;
1769: l_fut_identifier hr_soft_coding_keyflex.segment9%type;
1770: l_fut_type hr_soft_coding_keyflex.segment9%type;

Line 1767: l_fut_seg26 hr_soft_coding_keyflex.segment26%type;

1763: l_fut_frequency per_all_assignments_f.frequency%type;
1764: l_fut_establish per_all_assignments_f.establishment_id%type;
1765: l_fut_reason hr_soft_coding_keyflex.segment19%type;
1766: l_fut_share hr_soft_coding_keyflex.segment9%type;
1767: l_fut_seg26 hr_soft_coding_keyflex.segment26%type;
1768: l_fut_seg27 hr_soft_coding_keyflex.segment27%type;
1769: l_fut_identifier hr_soft_coding_keyflex.segment9%type;
1770: l_fut_type hr_soft_coding_keyflex.segment9%type;
1771: l_fut_percent number;

Line 1768: l_fut_seg27 hr_soft_coding_keyflex.segment27%type;

1764: l_fut_establish per_all_assignments_f.establishment_id%type;
1765: l_fut_reason hr_soft_coding_keyflex.segment19%type;
1766: l_fut_share hr_soft_coding_keyflex.segment9%type;
1767: l_fut_seg26 hr_soft_coding_keyflex.segment26%type;
1768: l_fut_seg27 hr_soft_coding_keyflex.segment27%type;
1769: l_fut_identifier hr_soft_coding_keyflex.segment9%type;
1770: l_fut_type hr_soft_coding_keyflex.segment9%type;
1771: l_fut_percent number;
1772: l_fut_category per_all_assignments_f.employment_category%type;

Line 1769: l_fut_identifier hr_soft_coding_keyflex.segment9%type;

1765: l_fut_reason hr_soft_coding_keyflex.segment19%type;
1766: l_fut_share hr_soft_coding_keyflex.segment9%type;
1767: l_fut_seg26 hr_soft_coding_keyflex.segment26%type;
1768: l_fut_seg27 hr_soft_coding_keyflex.segment27%type;
1769: l_fut_identifier hr_soft_coding_keyflex.segment9%type;
1770: l_fut_type hr_soft_coding_keyflex.segment9%type;
1771: l_fut_percent number;
1772: l_fut_category per_all_assignments_f.employment_category%type;
1773: l_fut_assign_status_type_id per_all_assignments_f.assignment_status_type_id%type;

Line 1770: l_fut_type hr_soft_coding_keyflex.segment9%type;

1766: l_fut_share hr_soft_coding_keyflex.segment9%type;
1767: l_fut_seg26 hr_soft_coding_keyflex.segment26%type;
1768: l_fut_seg27 hr_soft_coding_keyflex.segment27%type;
1769: l_fut_identifier hr_soft_coding_keyflex.segment9%type;
1770: l_fut_type hr_soft_coding_keyflex.segment9%type;
1771: l_fut_percent number;
1772: l_fut_category per_all_assignments_f.employment_category%type;
1773: l_fut_assign_status_type_id per_all_assignments_f.assignment_status_type_id%type;
1774: l_fut_grd_ldr_pgm_id per_all_assignments_f.grade_ladder_pgm_id%type;