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.PQP_GB_SWF_ARCHIVE dependencies on HR_LOOKUPS

Line 77: hr_lookups.meaning%type index by binary_integer;

73: type addl_payment_dtl_tab is table of
74: addl_payment_dtl_rec index by binary_integer;
75:
76: type addl_role_tab is table of
77: hr_lookups.meaning%type index by binary_integer;
78:
79: type act_info_rec is record
80: ( assignment_id number(20)
81: ,person_id number(20)

Line 1296: l_qt_status hr_lookups.meaning%type;

1292: l_swf_def_values_rec get_swf_dff_vaues%rowtype;
1293: l_asg_active_on_census_day boolean := true; -- variable set to true if he is active on census day
1294: l_person_id number;
1295: l_employee_number per_all_people_f.employee_number%type;
1296: l_qt_status hr_lookups.meaning%type;
1297: l_qts_route hr_lookups.meaning%type;
1298: l_disablity varchar2(5) := 'NO';
1299: l_hlta_status hr_lookups.meaning%type;
1300: l_teachers_number varchar2(240);

Line 1297: l_qts_route hr_lookups.meaning%type;

1293: l_asg_active_on_census_day boolean := true; -- variable set to true if he is active on census day
1294: l_person_id number;
1295: l_employee_number per_all_people_f.employee_number%type;
1296: l_qt_status hr_lookups.meaning%type;
1297: l_qts_route hr_lookups.meaning%type;
1298: l_disablity varchar2(5) := 'NO';
1299: l_hlta_status hr_lookups.meaning%type;
1300: l_teachers_number varchar2(240);
1301: l_arch boolean;

Line 1299: l_hlta_status hr_lookups.meaning%type;

1295: l_employee_number per_all_people_f.employee_number%type;
1296: l_qt_status hr_lookups.meaning%type;
1297: l_qts_route hr_lookups.meaning%type;
1298: l_disablity varchar2(5) := 'NO';
1299: l_hlta_status hr_lookups.meaning%type;
1300: l_teachers_number varchar2(240);
1301: l_arch boolean;
1302: l_effective_date date;
1303: e_cont_eff_dt_nt_found exception;

Line 1575: from hr_lookups hl

1571: into l_valid_ethnic_code
1572: from dual
1573: where exists
1574: (select lookup_code
1575: from hr_lookups hl
1576: where hl.lookup_type = 'UK_ETHNIC_CODES'
1577: and hl.enabled_flag = 'Y'
1578: and hl.lookup_code = l_staff_rec.ethnic_code);
1579: exception

Line 1634: from hr_lookups hl

1630: select 'Y'
1631: into l_valid_ethnic_code
1632: from dual
1633: where exists(select lookup_code
1634: from hr_lookups hl
1635: where hl.lookup_type = 'PQP_GB_SWF_QTS_ROUTES'
1636: and hl.enabled_flag = 'Y'
1637: and hl.lookup_code = l_qts_route);
1638: exception

Line 1956: l_main_role hr_lookups.lookup_code%type;

1952: and pcv_information_category = 'PQP_GB_SWF_ROLE_MAPPING'
1953: and pcv_information2 = p_role;
1954:
1955:
1956: l_main_role hr_lookups.lookup_code%type;
1957: l_assignment_number per_all_assignments_f.assignment_number%type;
1958: l_asg_cat per_all_assignments_f.employment_category%type;
1959: l_employee_cat per_all_assignments_f.employee_category%type;
1960: l_role_tab_idx pls_integer;

Line 2801: l_post hr_lookups.lookup_code%type;

2797:
2798:
2799: l_asg_rec get_assignment_details%rowtype;
2800: l_asg_dates_rec get_assignment_dates%rowtype;
2801: l_post hr_lookups.lookup_code%type;
2802: l_post_emp_cat hr_lookups.lookup_code%type;
2803: l_post_asg_cat hr_lookups.lookup_code%type;
2804: l_date_of_arrival_src pqp_configuration_values.pcv_information1%type;
2805: l_date_of_arrival date;

Line 2802: l_post_emp_cat hr_lookups.lookup_code%type;

2798:
2799: l_asg_rec get_assignment_details%rowtype;
2800: l_asg_dates_rec get_assignment_dates%rowtype;
2801: l_post hr_lookups.lookup_code%type;
2802: l_post_emp_cat hr_lookups.lookup_code%type;
2803: l_post_asg_cat hr_lookups.lookup_code%type;
2804: l_date_of_arrival_src pqp_configuration_values.pcv_information1%type;
2805: l_date_of_arrival date;
2806: l_daily_rate varchar2(150);

Line 2803: l_post_asg_cat hr_lookups.lookup_code%type;

2799: l_asg_rec get_assignment_details%rowtype;
2800: l_asg_dates_rec get_assignment_dates%rowtype;
2801: l_post hr_lookups.lookup_code%type;
2802: l_post_emp_cat hr_lookups.lookup_code%type;
2803: l_post_asg_cat hr_lookups.lookup_code%type;
2804: l_date_of_arrival_src pqp_configuration_values.pcv_information1%type;
2805: l_date_of_arrival date;
2806: l_daily_rate varchar2(150);
2807: l_origin hr_lookups.lookup_code%type;

Line 2807: l_origin hr_lookups.lookup_code%type;

2803: l_post_asg_cat hr_lookups.lookup_code%type;
2804: l_date_of_arrival_src pqp_configuration_values.pcv_information1%type;
2805: l_date_of_arrival date;
2806: l_daily_rate varchar2(150);
2807: l_origin hr_lookups.lookup_code%type;
2808: l_dcsf_origin hr_lookups.lookup_code%type;
2809: l_destination hr_lookups.lookup_code%type;
2810: l_dcsf_destination hr_lookups.lookup_code%type;
2811: l_la_or_school_level varchar2(150);

Line 2808: l_dcsf_origin hr_lookups.lookup_code%type;

2804: l_date_of_arrival_src pqp_configuration_values.pcv_information1%type;
2805: l_date_of_arrival date;
2806: l_daily_rate varchar2(150);
2807: l_origin hr_lookups.lookup_code%type;
2808: l_dcsf_origin hr_lookups.lookup_code%type;
2809: l_destination hr_lookups.lookup_code%type;
2810: l_dcsf_destination hr_lookups.lookup_code%type;
2811: l_la_or_school_level varchar2(150);
2812: l_establishment number := p_estab_no;

Line 2809: l_destination hr_lookups.lookup_code%type;

2805: l_date_of_arrival date;
2806: l_daily_rate varchar2(150);
2807: l_origin hr_lookups.lookup_code%type;
2808: l_dcsf_origin hr_lookups.lookup_code%type;
2809: l_destination hr_lookups.lookup_code%type;
2810: l_dcsf_destination hr_lookups.lookup_code%type;
2811: l_la_or_school_level varchar2(150);
2812: l_establishment number := p_estab_no;
2813: l_contract_agg_type hr_lookups.lookup_code%type;

Line 2810: l_dcsf_destination hr_lookups.lookup_code%type;

2806: l_daily_rate varchar2(150);
2807: l_origin hr_lookups.lookup_code%type;
2808: l_dcsf_origin hr_lookups.lookup_code%type;
2809: l_destination hr_lookups.lookup_code%type;
2810: l_dcsf_destination hr_lookups.lookup_code%type;
2811: l_la_or_school_level varchar2(150);
2812: l_establishment number := p_estab_no;
2813: l_contract_agg_type hr_lookups.lookup_code%type;
2814: l_user_formula_name ff_formulas_f.formula_name%type;

Line 2813: l_contract_agg_type hr_lookups.lookup_code%type;

2809: l_destination hr_lookups.lookup_code%type;
2810: l_dcsf_destination hr_lookups.lookup_code%type;
2811: l_la_or_school_level varchar2(150);
2812: l_establishment number := p_estab_no;
2813: l_contract_agg_type hr_lookups.lookup_code%type;
2814: l_user_formula_name ff_formulas_f.formula_name%type;
2815: l_arch_role boolean;
2816: l_person_category varchar2(30);
2817: l_arch boolean := true;

Line 2991: from hr_lookups hl

2987: select 'Y'
2988: into l_valid_flag
2989: from dual
2990: where exists(select lookup_code
2991: from hr_lookups hl
2992: where hl.lookup_type = 'PQP_GB_SWF_CNTRCT_AGRMNT_TYPES'
2993: and hl.enabled_flag = 'Y'
2994: and hl.lookup_code = l_contract_agg_type);
2995: exception

Line 3289: from hr_lookups hl

3285: into l_valid_flag
3286: from dual
3287: where exists
3288: (select lookup_code
3289: from hr_lookups hl
3290: where hl.lookup_type = 'PQP_GB_SWF_DESTINATION_CODES'
3291: and hl.enabled_flag = 'Y'
3292: and hl.lookup_code = l_dcsf_destination);
3293: exception

Line 3316: from hr_lookups hl

3312: into l_valid_flag
3313: from dual
3314: where exists
3315: (select lookup_code
3316: from hr_lookups hl
3317: where hl.lookup_type = 'PQP_GB_SWF_ORIGIN_CODES'
3318: and hl.enabled_flag = 'Y'
3319: and hl.lookup_code = l_dcsf_origin);
3320: exception

Line 3672: l_pay_scale_dcsf hr_lookups.lookup_code%type;

3668: l_regional_spine_segment varchar2(30);
3669: l_regional_spine_def_val varchar2(30);
3670: l_regional_spine_sql_str varchar2(3000);
3671: l_pay_scale per_parent_spines.parent_spine_id%type;
3672: l_pay_scale_dcsf hr_lookups.lookup_code%type;
3673: l_spinal_point per_spinal_points.spinal_point%type;
3674: l_spinal_point_dcsf hr_lookups.lookup_code%type;
3675: l_reg_spinal_point_dcsf hr_lookups.lookup_code%type;
3676: l_safe_grd_sal varchar2(5);

Line 3674: l_spinal_point_dcsf hr_lookups.lookup_code%type;

3670: l_regional_spine_sql_str varchar2(3000);
3671: l_pay_scale per_parent_spines.parent_spine_id%type;
3672: l_pay_scale_dcsf hr_lookups.lookup_code%type;
3673: l_spinal_point per_spinal_points.spinal_point%type;
3674: l_spinal_point_dcsf hr_lookups.lookup_code%type;
3675: l_reg_spinal_point_dcsf hr_lookups.lookup_code%type;
3676: l_safe_grd_sal varchar2(5);
3677: l_arch boolean := true;
3678: l_contract_st_date date := to_date(p_cont_st_date,'YYYY-MM-DD');

Line 3675: l_reg_spinal_point_dcsf hr_lookups.lookup_code%type;

3671: l_pay_scale per_parent_spines.parent_spine_id%type;
3672: l_pay_scale_dcsf hr_lookups.lookup_code%type;
3673: l_spinal_point per_spinal_points.spinal_point%type;
3674: l_spinal_point_dcsf hr_lookups.lookup_code%type;
3675: l_reg_spinal_point_dcsf hr_lookups.lookup_code%type;
3676: l_safe_grd_sal varchar2(5);
3677: l_arch boolean := true;
3678: l_contract_st_date date := to_date(p_cont_st_date,'YYYY-MM-DD');
3679: l_contract_end_date date := to_date(p_cont_end_date,'YYYY-MM-DD');

Line 3814: from hr_lookups hl

3810: into l_valid_flag
3811: from dual
3812: where exists
3813: (select lookup_code
3814: from hr_lookups hl
3815: where hl.lookup_type = 'PQP_GB_REGIONAL_SPINE_CODE'
3816: and hl.enabled_flag = 'Y'
3817: and hl.lookup_code = l_reg_spinal_point_dcsf);
3818: exception

Line 3841: from hr_lookups hl

3837: into l_valid_flag
3838: from dual
3839: where exists
3840: (select lookup_code
3841: from hr_lookups hl
3842: where hl.lookup_type = 'PQP_GB_DCSF_SPINE_POINTS'
3843: and hl.enabled_flag = 'Y'
3844: and hl.lookup_code = l_spinal_point_dcsf);
3845: exception