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 PER_ALL_ASSIGNMENTS_F

Line 27: PER_ALL_ASSIGNMENTS_F PAF

23: --CURSOR CSR_GET_LEGISLATION IS
24: CURSOR CSR_GET_LEGISLATION(CSR_L_INFORMATION67 VARCHAR2) IS
25: SELECT ORG_INFORMATION9
26: FROM HR_ORGANIZATION_INFORMATION HOI,
27: PER_ALL_ASSIGNMENTS_F PAF
28: WHERE PAF.ASSIGNMENT_ID = P_INFORMATION2
29: AND FND_DATE.CANONICAL_TO_DATE(CSR_L_INFORMATION67) BETWEEN PAF.EFFECTIVE_START_DATE
30: AND PAF.EFFECTIVE_END_DATE
31:

Line 469: from per_all_assignments_f

465: procedure admin_effective_warning( p_person_id in number ,p_effective_date in varchar2,p_return_status out NOCOPY varchar) IS
466:
467: Cursor csr_suggest_eff_dt Is
468: Select max(effective_start_date)
469: from per_all_assignments_f
470: where person_id = p_person_id
471: and primary_flag ='Y';
472: --
473: l_date date;

Line 503: from per_all_assignments_f

499: and to_date(p_effective_date,'RRRR-MM-DD') between effective_start_date and effective_end_date;
500: --
501: Cursor csr_chk_career IS
502: Select grade_ladder_pgm_id
503: from per_all_assignments_f
504: where person_id = p_person_id
505: and primary_flag ='Y'
506: and to_date(p_effective_date, 'RRRR-MM-DD') between effective_start_date and effective_end_date;
507:

Line 586: from per_all_assignments_f

582: procedure affectations_validations(p_person_id in number,p_effective_date in varchar2)
583: IS
584: Cursor csr_normal_hours IS
585: Select normal_hours
586: from per_all_assignments_f
587: where to_date(p_effective_date,'RRRR-MM-DD') between effective_start_date and effective_end_date
588: and person_id = p_person_id
589: and primary_flag ='Y';
590:

Line 591: l_normal_hours per_all_assignments_f.normal_hours%type;

587: where to_date(p_effective_date,'RRRR-MM-DD') between effective_start_date and effective_end_date
588: and person_id = p_person_id
589: and primary_flag ='Y';
590:
591: l_normal_hours per_all_assignments_f.normal_hours%type;
592:
593: Begin
594: --
595: admin_career_validations(p_person_id,p_effective_date);

Line 668: from per_all_assignments_f

664: Function Get_available_hours(p_person_id IN NUMBER, p_effective_date in date) return number
665: IS
666: Cursor csr_available_hours(p_flag varchar2) IS
667: Select sum(normal_hours)
668: from per_all_assignments_f
669: where person_id = p_person_id
670: and p_effective_date between effective_start_date and effective_end_date
671: and assignment_status_type_id = 1
672: and primary_flag = p_flag;

Line 675: l_normal_hours per_all_assignments_f.normal_hours%type;

671: and assignment_status_type_id = 1
672: and primary_flag = p_flag;
673:
674: --
675: l_normal_hours per_all_assignments_f.normal_hours%type;
676: l_consumed_hours per_all_assignments_f.normal_hours%type;
677: --
678: Begin
679: --

Line 676: l_consumed_hours per_all_assignments_f.normal_hours%type;

672: and primary_flag = p_flag;
673:
674: --
675: l_normal_hours per_all_assignments_f.normal_hours%type;
676: l_consumed_hours per_all_assignments_f.normal_hours%type;
677: --
678: Begin
679: --
680: Open csr_available_hours('N');

Line 786: FROM per_all_assignments_f

782: l_agent_type Varchar2(30);
783: l_emp_type Varchar2(30);
784: CURSOR csr_primary_asg(p_person_id IN NUMBER) IS
785: SELECT assignment_id, object_version_number
786: FROM per_all_assignments_f
787: WHERE person_id = p_person_id
788: AND hr_general.effective_date between effective_start_date and effective_end_date
789: AND primary_flag = 'Y';
790: l_asg_id NUMBER(15);

Line 955: from per_all_assignments_f

951: Function get_position_id (p_admin_career_id in Varchar2, p_effective_date in Date) return number
952: IS
953: Cursor csr_position_id IS
954: Select position_id
955: from per_all_assignments_f
956: where assignment_id = p_admin_career_id
957: and p_effective_date between effective_start_date and effective_end_date;
958: --
959: l_position_id Number;

Line 1040: FROM per_all_assignments_f asg,

1036: pqh_fr_utility.Get_Salary_Share(scl.segment9) "SALARY_SHARE",
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

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 1198: FROM per_all_assignments_f asg,

1194: nvl(asg.normal_hours,-999) normal_hours,
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

Line 1213: FROM per_all_assignments_f asg

1209: SELECT asg.effective_start_date effective_start_date
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

Line 1224: l_normal_hours per_all_assignments_f.normal_hours%type;

1220: --
1221:
1222: l_old_start_date date;
1223:
1224: l_normal_hours per_all_assignments_f.normal_hours%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;

Line 1225: l_supervisor_id per_all_assignments_f.supervisor_id%type;

1221:
1222: l_old_start_date date;
1223:
1224: l_normal_hours per_all_assignments_f.normal_hours%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;

Line 1226: l_position per_all_assignments_f.position_id%type;

1222: l_old_start_date date;
1223:
1224: l_normal_hours per_all_assignments_f.normal_hours%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;

Line 1227: l_frequency per_all_assignments_f.frequency%type;

1223:
1224: l_normal_hours per_all_assignments_f.normal_hours%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;

Line 1228: l_establish per_all_assignments_f.establishment_id%type;

1224: l_normal_hours per_all_assignments_f.normal_hours%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;

Line 1236: l_category per_all_assignments_f.employment_category%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;
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;

Line 1237: l_assignment_status_type_id per_all_assignments_f.assignment_status_type_id%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;
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:

Line 1239: l_grd_ldr_pgm_id per_all_assignments_f.grade_ladder_pgm_id%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;
1243: l_old_supervisor_id per_all_assignments_f.supervisor_id%type;

Line 1240: l_grd_id per_all_assignments_f.grade_id%type;

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;
1243: l_old_supervisor_id per_all_assignments_f.supervisor_id%type;
1244: l_old_position per_all_assignments_f.position_id%type;

Line 1242: l_old_normal_hours per_all_assignments_f.normal_hours%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;
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;

Line 1243: l_old_supervisor_id per_all_assignments_f.supervisor_id%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;
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;

Line 1244: l_old_position per_all_assignments_f.position_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;
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;

Line 1245: l_old_frequency per_all_assignments_f.frequency%type;

1241:
1242: l_old_normal_hours per_all_assignments_f.normal_hours%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;

Line 1246: l_old_establish per_all_assignments_f.establishment_id%type;

1242: l_old_normal_hours per_all_assignments_f.normal_hours%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;

Line 1254: l_old_category per_all_assignments_f.employment_category%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;
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;

Line 1255: l_old_assign_status_type_id per_all_assignments_f.assignment_status_type_id%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;
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:

Line 1257: l_old_grd_ldr_pgm_id per_all_assignments_f.grade_ladder_pgm_id%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
1261: -- this function is to be called from the view pages query to get the rows which are to be displayed

Line 1258: l_old_grd_id per_all_assignments_f.grade_id%type;

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
1261: -- this function is to be called from the view pages query to get the rows which are to be displayed
1262: -- logic of this routine will be check the value change as of earlier date, if there is a change

Line 1482: FROM per_all_assignments_f asg,

1478: --
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

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 1700: FROM per_all_assignments_f asg

1696: ORDER by assign.effective_start_date;
1697:
1698: cursor csr_end_date is
1699: SELECT asg.effective_end_date effective_end_date
1700: FROM per_all_assignments_f asg
1701: WHERE asg.assignment_id = l_assignment_id
1702: and effective_start_date = p_start_date;
1703:
1704: cursor csr_asg_employ is

Line 1713: FROM per_all_assignments_f asg,

1709: nvl(asg.frequency,'-999') frequency,
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

Line 1729: FROM per_all_assignments_f asg

1725: ,scl.segment10 employment_category
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

Line 1742: l_normal_hours per_all_assignments_f.normal_hours%type;

1738: l_fut_end_date date;
1739:
1740: -- l_end_date date;
1741:
1742: l_normal_hours per_all_assignments_f.normal_hours%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;

Line 1743: l_supervisor_id per_all_assignments_f.supervisor_id%type;

1739:
1740: -- l_end_date date;
1741:
1742: l_normal_hours per_all_assignments_f.normal_hours%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;

Line 1744: l_position per_all_assignments_f.position_id%type;

1740: -- l_end_date date;
1741:
1742: l_normal_hours per_all_assignments_f.normal_hours%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;

Line 1745: l_frequency per_all_assignments_f.frequency%type;

1741:
1742: l_normal_hours per_all_assignments_f.normal_hours%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;

Line 1746: l_establish per_all_assignments_f.establishment_id%type;

1742: l_normal_hours per_all_assignments_f.normal_hours%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;

Line 1754: l_category per_all_assignments_f.employment_category%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;
1757: l_grade_id per_all_assignments_f.grade_id%type;
1758: l_emp_cat per_all_assignments_f.employment_category%type;

Line 1755: l_assignment_status_type_id per_all_assignments_f.assignment_status_type_id%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;
1757: l_grade_id per_all_assignments_f.grade_id%type;
1758: l_emp_cat per_all_assignments_f.employment_category%type;
1759:

Line 1756: l_grd_ldr_pgm_id per_all_assignments_f.grade_ladder_pgm_id%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;
1757: l_grade_id per_all_assignments_f.grade_id%type;
1758: l_emp_cat per_all_assignments_f.employment_category%type;
1759:
1760: l_fut_normal_hours per_all_assignments_f.normal_hours%type;

Line 1757: l_grade_id per_all_assignments_f.grade_id%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;
1757: l_grade_id per_all_assignments_f.grade_id%type;
1758: l_emp_cat per_all_assignments_f.employment_category%type;
1759:
1760: l_fut_normal_hours per_all_assignments_f.normal_hours%type;
1761: l_fut_supervisor_id per_all_assignments_f.supervisor_id%type;

Line 1758: l_emp_cat per_all_assignments_f.employment_category%type;

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;
1757: l_grade_id per_all_assignments_f.grade_id%type;
1758: l_emp_cat per_all_assignments_f.employment_category%type;
1759:
1760: l_fut_normal_hours per_all_assignments_f.normal_hours%type;
1761: l_fut_supervisor_id per_all_assignments_f.supervisor_id%type;
1762: l_fut_position per_all_assignments_f.position_id%type;

Line 1760: l_fut_normal_hours per_all_assignments_f.normal_hours%type;

1756: l_grd_ldr_pgm_id per_all_assignments_f.grade_ladder_pgm_id%type;
1757: l_grade_id per_all_assignments_f.grade_id%type;
1758: l_emp_cat per_all_assignments_f.employment_category%type;
1759:
1760: l_fut_normal_hours per_all_assignments_f.normal_hours%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;

Line 1761: l_fut_supervisor_id per_all_assignments_f.supervisor_id%type;

1757: l_grade_id per_all_assignments_f.grade_id%type;
1758: l_emp_cat per_all_assignments_f.employment_category%type;
1759:
1760: l_fut_normal_hours per_all_assignments_f.normal_hours%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;

Line 1762: l_fut_position per_all_assignments_f.position_id%type;

1758: l_emp_cat per_all_assignments_f.employment_category%type;
1759:
1760: l_fut_normal_hours per_all_assignments_f.normal_hours%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;

Line 1763: l_fut_frequency per_all_assignments_f.frequency%type;

1759:
1760: l_fut_normal_hours per_all_assignments_f.normal_hours%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;

Line 1764: l_fut_establish per_all_assignments_f.establishment_id%type;

1760: l_fut_normal_hours per_all_assignments_f.normal_hours%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;

Line 1772: l_fut_category per_all_assignments_f.employment_category%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;
1775: l_fut_grade_id per_all_assignments_f.grade_id%type;
1776: l_fut_emp_cat per_all_assignments_f.employment_category%type;

Line 1773: l_fut_assign_status_type_id per_all_assignments_f.assignment_status_type_id%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;
1775: l_fut_grade_id per_all_assignments_f.grade_id%type;
1776: l_fut_emp_cat per_all_assignments_f.employment_category%type;
1777:

Line 1774: l_fut_grd_ldr_pgm_id per_all_assignments_f.grade_ladder_pgm_id%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;
1775: l_fut_grade_id per_all_assignments_f.grade_id%type;
1776: l_fut_emp_cat per_all_assignments_f.employment_category%type;
1777:
1778: l_return_end_date date;

Line 1775: l_fut_grade_id per_all_assignments_f.grade_id%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;
1775: l_fut_grade_id per_all_assignments_f.grade_id%type;
1776: l_fut_emp_cat per_all_assignments_f.employment_category%type;
1777:
1778: l_return_end_date date;
1779: begin

Line 1776: l_fut_emp_cat per_all_assignments_f.employment_category%type;

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;
1775: l_fut_grade_id per_all_assignments_f.grade_id%type;
1776: l_fut_emp_cat per_all_assignments_f.employment_category%type;
1777:
1778: l_return_end_date date;
1779: begin
1780: -- this function is to be called from the view pages query to get the rows which are to be displayed

Line 1960: from per_all_assignments_f

1956: Cursor csr_career_corp is
1957: Select Corps_Definition_Id
1958: From Pqh_Corps_Definitions
1959: where Ben_Pgm_Id in (select grade_ladder_pgm_id
1960: from per_all_assignments_f
1961: where assignment_id = p_primary_assign_id
1962: and p_effective_date between effective_start_date and effective_end_date
1963: and primary_flag = 'Y' );
1964: