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 PER_PARENT_SPINES

Line 3603: per_parent_spines ps,

3599: cursor pay_scale is
3600: select ps.parent_spine_id
3601: from per_grade_spines_f grs,
3602: per_grades gdt,
3603: per_parent_spines ps,
3604: per_all_assignments_f asg
3605: where grs.grade_id = gdt.grade_id
3606: and grs.parent_spine_id = ps.parent_spine_id
3607: and asg.grade_id = grs.grade_id

Line 3612: cursor pay_scale_dcsf(p_pay_scale in per_parent_spines.parent_spine_id%type) is

3608: and asg.assignment_id = p_assignment_id
3609: and p_effective_date between asg.effective_start_date and asg.effective_end_date
3610: and p_effective_date between grs.effective_start_date and grs.effective_end_date;
3611:
3612: cursor pay_scale_dcsf(p_pay_scale in per_parent_spines.parent_spine_id%type) is
3613: select pcv.pcv_information2
3614: from pqp_configuration_values pcv
3615: where pcv.pcv_information_category = 'PQP_GB_SWF_PAY_SCALE_MAPPING'
3616: and pcv.pcv_information1 = p_pay_scale

Line 3631: cursor spinal_point_dcsf(p_pay_scale in per_parent_spines.parent_spine_id%type,

3627: and p_effective_date between pspp.effective_start_date and pspp.effective_end_date
3628: and p_effective_date between psps.effective_start_date and psps.effective_end_date;
3629:
3630:
3631: cursor spinal_point_dcsf(p_pay_scale in per_parent_spines.parent_spine_id%type,
3632: p_spinal_point in per_spinal_points.spinal_point_id%type) is
3633: select pcv.pcv_information3
3634: from pqp_configuration_values pcv
3635: where pcv.pcv_information_category = 'PQP_GB_SWF_SPINE_POINT_MAPPING'

Line 3652: cursor reg_spinal_point_dcsf(p_pay_scale in per_parent_spines.name%type,

3648: from pqp_configuration_values pcv
3649: where pcv.pcv_information_category = 'PQP_GB_SWF_REG_SPINE_SRC'
3650: and pcv.business_group_id = g_business_group_id;
3651:
3652: cursor reg_spinal_point_dcsf(p_pay_scale in per_parent_spines.name%type,
3653: p_spinal_point in per_spinal_points.spinal_point%type) is
3654: select pcv.pcv_information4
3655: from pqp_configuration_values pcv
3656: where pcv.pcv_information_category = 'PQP_GB_SWF_REG_SPINE_MAP_PYSCL'

Line 3671: l_pay_scale per_parent_spines.parent_spine_id%type;

3667: l_regional_spine_context varchar2(30);
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;