APPS.PQH_GSP_STAGE_TO_HR dependencies on PAY_RATES

Line 576: From Pay_rates

572: and Information293 = P_Rat_Name_Id;
573:
574: Cursor Rt_Nam_Dtl (P_Rate_Id IN NUMBER) is
575: Select Rate_Id, Rate_type, Object_version_Number
576: From Pay_rates
577: Where Rate_Id = P_Rate_Id
578: and Not Exists
579: (Select 1
580: from Ben_Copy_Entity_results

Line 590: l_Rate_type Pay_Rates.Rate_Type%TYPE;

586: L_Hr_Rt_Esd Ben_Acty_Vrbl_Rt_F.Effective_Start_Date%TYPE;
587: L_Hr_Rt_Eed Ben_Acty_Vrbl_Rt_F.Effective_End_Date%TYPE;
588: l_Hr_RT_Ovn Ben_Acty_Vrbl_Rt_F.Object_version_Number%TYPE;
589:
590: l_Rate_type Pay_Rates.Rate_Type%TYPE;
591: l_Rate_Ovn PAy_rates.Object_version_Number%TYPE;
592: l_rate_Id Pay_rates.Rate_Id%TYPE;
593: Begin
594:

Line 591: l_Rate_Ovn PAy_rates.Object_version_Number%TYPE;

587: L_Hr_Rt_Eed Ben_Acty_Vrbl_Rt_F.Effective_End_Date%TYPE;
588: l_Hr_RT_Ovn Ben_Acty_Vrbl_Rt_F.Object_version_Number%TYPE;
589:
590: l_Rate_type Pay_Rates.Rate_Type%TYPE;
591: l_Rate_Ovn PAy_rates.Object_version_Number%TYPE;
592: l_rate_Id Pay_rates.Rate_Id%TYPE;
593: Begin
594:
595: For Rt_Rec In Csr_Pay_Rts

Line 592: l_rate_Id Pay_rates.Rate_Id%TYPE;

588: l_Hr_RT_Ovn Ben_Acty_Vrbl_Rt_F.Object_version_Number%TYPE;
589:
590: l_Rate_type Pay_Rates.Rate_Type%TYPE;
591: l_Rate_Ovn PAy_rates.Object_version_Number%TYPE;
592: l_rate_Id Pay_rates.Rate_Id%TYPE;
593: Begin
594:
595: For Rt_Rec In Csr_Pay_Rts
596: Loop

Line 793: from hr_lookups lkp, pay_rates rt

789: elsif p_frequency is not null then
790: begin
791: select rt.rate_id
792: into l_rate_id
793: from hr_lookups lkp, pay_rates rt
794: where lkp.lookup_code = p_frequency
795: and rt.rate_type ='G'
796: and rt.business_group_id = p_business_group_id
797: and lkp.lookup_type = 'PQH_GSP_GEN_PAY_RATE_NAME'

Line 812: from per_parent_spines scl, pay_rates rt

808: elsif p_scale_id is not null then
809: begin
810: select rt.rate_id
811: into l_rate_id
812: from per_parent_spines scl, pay_rates rt
813: where rt.parent_spine_id = scl.parent_spine_id
814: and scl.parent_spine_id = p_scale_id
815: and rt.rate_type ='SP'
816: and rt.name = scl.name;

Line 1506: hr_utility.set_location('pay rates created if any reqd',41);

1502: stage_to_prate(p_copy_entity_txn_id => p_copy_entity_txn_id,
1503: p_effective_date => l_effective_date,
1504: p_business_group_id => p_business_group_id,
1505: p_gl_frequency => p_gl_frequency);
1506: hr_utility.set_location('pay rates created if any reqd',41);
1507: stage_to_grd_sp(p_copy_entity_txn_id => p_copy_entity_txn_id,
1508: p_effective_date => l_effective_date,
1509: p_business_group_id => p_business_group_id,
1510: p_datetrack_mode => p_datetrack_mode);