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_LENGTH_OF_SERVICE_PKG dependencies on PER_ASSIGNMENTS_F

Line 144: l_emp_type per_assignments_f.employee_category%TYPE;

140:
141: FUNCTION get_employee_type (p_person_id IN per_all_people_f.person_id%TYPE,
142: p_determination_date IN DATE)
143: RETURN VARCHAR2 IS
144: l_emp_type per_assignments_f.employee_category%TYPE;
145: l_proc varchar2(60) := g_package||'get_emp_type';
146: l_leg_code varchar2(30) := 'x';
147: CURSOR csr_emp_type IS
148: SELECT per.per_information15

Line 297: l_emp_type per_assignments_f.employee_category%TYPE;

293: p_start_date IN DATE,
294: p_end_date IN DATE)
295:
296: RETURN NUMBER IS
297: l_emp_type per_assignments_f.employee_category%TYPE;
298: l_emp_catg per_assignments_f.employment_category%TYPE;
299: l_entitlement_flag VARCHAR2(30);
300: l_work_proportional VARCHAR2(30) ;
301: l_parttime_entitlement NUMBER(22,3) := 0;

Line 298: l_emp_catg per_assignments_f.employment_category%TYPE;

294: p_end_date IN DATE)
295:
296: RETURN NUMBER IS
297: l_emp_type per_assignments_f.employee_category%TYPE;
298: l_emp_catg per_assignments_f.employment_category%TYPE;
299: l_entitlement_flag VARCHAR2(30);
300: l_work_proportional VARCHAR2(30) ;
301: l_parttime_entitlement NUMBER(22,3) := 0;
302: l_bg_normal_day NUMBER(22,3) := 0;

Line 403: p_assignment_id IN per_assignments_f.assignment_id%TYPE,

399: -- while calculating the LOS.
400: -- -----------------------------------------------------------------------*
401:
402: FUNCTION get_previous_employment(p_person_id IN per_all_people_f.person_id%TYPE,
403: p_assignment_id IN per_assignments_f.assignment_id%TYPE,
404: p_start_date IN DATE,
405: p_end_date IN DATE) RETURN NUMBER IS
406: l_prev_emp_period NUMBER(22,3) := 0;
407: l_proc varchar2(60) := g_package||'get_previous_employment';

Line 625: p_assignment_id IN per_assignments_f.assignment_id%TYPE,

621: -- person as held in FR_PQH_BONIFICATION_DETAILS
622: -- -----------------------------------------------------------------------*
623: FUNCTION get_military_service_period (p_bg_id IN hr_all_organization_units.organization_id%TYPE,
624: p_person_id IN per_all_people_f.person_id%TYPE,
625: p_assignment_id IN per_assignments_f.assignment_id%TYPE,
626: p_los_type IN hr_lookups.lookup_code%TYPE,
627: p_start_date IN DATE,
628: p_end_date IN DATE)
629: RETURN NUMBER IS

Line 631: l_emp_type per_assignments_f.employee_category%TYPE;

627: p_start_date IN DATE,
628: p_end_date IN DATE)
629: RETURN NUMBER IS
630:
631: l_emp_type per_assignments_f.employee_category%TYPE;
632: l_entitlement_value NUMBER(22,3) := 0;
633: l_proc varchar2(60) := g_package||'get_military_service_period';
634: l_military_duration NUMBER(22,3) :=0;
635:

Line 795: l_assignment_id per_assignments_f.assignment_id%TYPE;

791: AND (p_assignment_id IS NOT NULL OR asg.primary_flag ='Y')
792: AND (p_assignment_id IS NULL OR asg.assignment_id = p_assignment_id)
793: AND p_determination_date BETWEEN asg.effective_start_date AND asg.effective_end_date;
794:
795: l_assignment_id per_assignments_f.assignment_id%TYPE;
796: l_grade_id per_assignments_f.grade_id%TYPE;
797:
798: l_proc varchar2(60) := g_package||'get_grade_LOS';
799:

Line 796: l_grade_id per_assignments_f.grade_id%TYPE;

792: AND (p_assignment_id IS NULL OR asg.assignment_id = p_assignment_id)
793: AND p_determination_date BETWEEN asg.effective_start_date AND asg.effective_end_date;
794:
795: l_assignment_id per_assignments_f.assignment_id%TYPE;
796: l_grade_id per_assignments_f.grade_id%TYPE;
797:
798: l_proc varchar2(60) := g_package||'get_grade_LOS';
799:
800: CURSOR csr_grade_period IS

Line 909: l_assignment_id per_assignments_f.assignment_id%TYPE;

905: WHERE asg.person_id = p_person_id
906: AND (p_assignment_id IS NOT NULL OR asg.primary_flag ='Y')
907: AND (p_assignment_id IS NULL OR asg.assignment_id = p_assignment_id)
908: AND p_determination_date BETWEEN asg.effective_start_date AND asg.effective_end_date;
909: l_assignment_id per_assignments_f.assignment_id%TYPE;
910: l_position_id per_assignments_f.position_id%TYPE;
911:
912: CURSOR csr_position_period IS
913: SELECT asg.effective_start_date,

Line 910: l_position_id per_assignments_f.position_id%TYPE;

906: AND (p_assignment_id IS NOT NULL OR asg.primary_flag ='Y')
907: AND (p_assignment_id IS NULL OR asg.assignment_id = p_assignment_id)
908: AND p_determination_date BETWEEN asg.effective_start_date AND asg.effective_end_date;
909: l_assignment_id per_assignments_f.assignment_id%TYPE;
910: l_position_id per_assignments_f.position_id%TYPE;
911:
912: CURSOR csr_position_period IS
913: SELECT asg.effective_start_date,
914: asg.effective_end_date

Line 1026: l_assignment_id per_assignments_f.assignment_id%TYPE;

1022: AND p_determination_date BETWEEN asg.effective_start_date
1023: AND asg.effective_end_date;
1024:
1025:
1026: l_assignment_id per_assignments_f.assignment_id%TYPE;
1027: l_corps_id hr_soft_coding_keyflex.segment7%TYPE;
1028:
1029: CURSOR csr_corps_period
1030: IS

Line 1138: l_assignment_id per_assignments_f.assignment_id%TYPE;

1134: AND p_determination_date BETWEEN asg.effective_start_date AND asg.effective_end_date
1135: AND spp.assignment_id = asg.assignment_id
1136: AND p_determination_date BETWEEN spp.effective_start_date and spp.effective_end_date;
1137:
1138: l_assignment_id per_assignments_f.assignment_id%TYPE;
1139: l_step_id per_spinal_point_placements_f.step_id%TYPE;
1140: l_start_date DATE;
1141: l_end_date DATE;
1142: l_step_los NUMBER(22,3) := 0;

Line 1474: l_emp_type per_assignments_f.employee_category%TYPE;

1470: p_start_date IN DATE,
1471: p_end_date IN DATE)
1472: RETURN VARCHAR2 IS
1473:
1474: l_emp_type per_assignments_f.employee_category%TYPE;
1475: l_military_entitlement VARCHAR2(30);
1476: l_proc VARCHAR2(60) := g_package||'get_military_service_period';
1477: l_military_duration NUMBER(22,3) :=0;
1478: l_los_return VARCHAR2(240);

Line 1988: l_curr_grade_id per_assignments_f.grade_id%TYPE;

1984: FROM per_all_assignments_f asg
1985: WHERE asg.person_id = p_person_id
1986: AND trunc(sysdate) between effective_start_date and effective_end_date;
1987:
1988: l_curr_grade_id per_assignments_f.grade_id%TYPE;
1989:
1990: BEGIN
1991: --
1992: -- Fetch the grade in the current assignment

Line 2037: l_grade_id per_assignments_f.grade_id%TYPE;

2033: WHERE assignment_id = p_assignment_id
2034: AND nvl(aei_information1,'x') = p_los_type
2035: AND information_type = 'DE_PQH_ASSG_LOS_INFO';
2036:
2037: l_grade_id per_assignments_f.grade_id%TYPE;
2038: l_curr_grade_id per_assignments_f.grade_id%TYPE;
2039: l_proc VARCHAR2(60) := g_package||'get_grade_LOS';
2040: l_grade_los NUMBER(22,3) := 0;
2041: l_absent_duration NUMBER(22,3) := 0;

Line 2038: l_curr_grade_id per_assignments_f.grade_id%TYPE;

2034: AND nvl(aei_information1,'x') = p_los_type
2035: AND information_type = 'DE_PQH_ASSG_LOS_INFO';
2036:
2037: l_grade_id per_assignments_f.grade_id%TYPE;
2038: l_curr_grade_id per_assignments_f.grade_id%TYPE;
2039: l_proc VARCHAR2(60) := g_package||'get_grade_LOS';
2040: l_grade_los NUMBER(22,3) := 0;
2041: l_absent_duration NUMBER(22,3) := 0;
2042: l_grade_entitlements NUMBER(22,3) := 0;

Line 2164: l_assignment_id per_assignments_f.assignment_id%TYPE;

2160: WHERE assignment_id = p_assignment_id
2161: AND nvl(aei_information1,'x') = p_los_type
2162: AND information_type = 'DE_PQH_ASSG_LOS_INFO';
2163:
2164: l_assignment_id per_assignments_f.assignment_id%TYPE;
2165: l_step_id per_spinal_point_placements_f.step_id%TYPE;
2166: l_curr_step_id per_spinal_point_placements_f.step_id%TYPE;
2167: l_start_date DATE;
2168: l_end_date DATE;

Line 2288: l_assignment_id per_assignments_f.assignment_id%TYPE;

2284: AND nvl(aei_information1,'x') = p_los_type
2285: AND information_type = 'DE_PQH_ASSG_LOS_INFO';
2286:
2287:
2288: l_assignment_id per_assignments_f.assignment_id%TYPE;
2289: l_position_id per_assignments_f.position_id%TYPE;
2290: l_position_los NUMBER(22,3) := 0;
2291: l_absent_duration NUMBER(22,3) := 0;
2292: l_prev_employment NUMBER(22,3) := 0;

Line 2289: l_position_id per_assignments_f.position_id%TYPE;

2285: AND information_type = 'DE_PQH_ASSG_LOS_INFO';
2286:
2287:
2288: l_assignment_id per_assignments_f.assignment_id%TYPE;
2289: l_position_id per_assignments_f.position_id%TYPE;
2290: l_position_los NUMBER(22,3) := 0;
2291: l_absent_duration NUMBER(22,3) := 0;
2292: l_prev_employment NUMBER(22,3) := 0;
2293: l_military_duration NUMBER(22,3) := 0;

Line 2363: l_curr_grade_id per_assignments_f.grade_id%TYPE;

2359: l_exists VARCHAR2(2) := '0';
2360: l_correction_factor NUMBER(22,3) := 0;
2361: l_prev_grade_id per_previous_jobs.pjo_information2%TYPE;
2362: l_prev_step_id per_previous_jobs.pjo_information3%TYPE;
2363: l_curr_grade_id per_assignments_f.grade_id%TYPE;
2364: l_curr_step_id per_spinal_point_placements_f.step_id%TYPE;
2365: l_emp_type per_previous_jobs.employment_category%TYPE := 'x';
2366: l_employer_type per_previous_employers.employer_type%TYPE := 'x';
2367: l_prev_empl_id per_previous_employers.previous_employer_id%TYPE;