APPS.PQH_GSP_STAGE_TO_HR dependencies on PAY_RATES

Line 546: From Pay_rates

542: and Information293 = P_Rat_Name_Id;
543:
544: Cursor Rt_Nam_Dtl (P_Rate_Id IN NUMBER) is
545: Select Rate_Id, Rate_type, Object_version_Number
546: From Pay_rates
547: Where Rate_Id = P_Rate_Id
548: and Not Exists
549: (Select 1
550: from Ben_Copy_Entity_results

Line 560: l_Rate_type Pay_Rates.Rate_Type%TYPE;

556: L_Hr_Rt_Esd Ben_Acty_Vrbl_Rt_F.Effective_Start_Date%TYPE;
557: L_Hr_Rt_Eed Ben_Acty_Vrbl_Rt_F.Effective_End_Date%TYPE;
558: l_Hr_RT_Ovn Ben_Acty_Vrbl_Rt_F.Object_version_Number%TYPE;
559:
560: l_Rate_type Pay_Rates.Rate_Type%TYPE;
561: l_Rate_Ovn PAy_rates.Object_version_Number%TYPE;
562: l_rate_Id Pay_rates.Rate_Id%TYPE;
563: Begin
564:

Line 561: l_Rate_Ovn PAy_rates.Object_version_Number%TYPE;

557: L_Hr_Rt_Eed Ben_Acty_Vrbl_Rt_F.Effective_End_Date%TYPE;
558: l_Hr_RT_Ovn Ben_Acty_Vrbl_Rt_F.Object_version_Number%TYPE;
559:
560: l_Rate_type Pay_Rates.Rate_Type%TYPE;
561: l_Rate_Ovn PAy_rates.Object_version_Number%TYPE;
562: l_rate_Id Pay_rates.Rate_Id%TYPE;
563: Begin
564:
565: For Rt_Rec In Csr_Pay_Rts

Line 562: l_rate_Id Pay_rates.Rate_Id%TYPE;

558: l_Hr_RT_Ovn Ben_Acty_Vrbl_Rt_F.Object_version_Number%TYPE;
559:
560: l_Rate_type Pay_Rates.Rate_Type%TYPE;
561: l_Rate_Ovn PAy_rates.Object_version_Number%TYPE;
562: l_rate_Id Pay_rates.Rate_Id%TYPE;
563: Begin
564:
565: For Rt_Rec In Csr_Pay_Rts
566: Loop

Line 754: from hr_lookups lkp, pay_rates rt

750: elsif p_frequency is not null then
751: begin
752: select rt.rate_id
753: into l_rate_id
754: from hr_lookups lkp, pay_rates rt
755: where lkp.lookup_code = p_frequency
756: and rt.rate_type ='G'
757: and rt.business_group_id = p_business_group_id
758: and lkp.lookup_type = 'PQH_GSP_GEN_PAY_RATE_NAME'

Line 773: from per_parent_spines scl, pay_rates rt

769: elsif p_scale_id is not null then
770: begin
771: select rt.rate_id
772: into l_rate_id
773: from per_parent_spines scl, pay_rates rt
774: where rt.parent_spine_id = scl.parent_spine_id
775: and scl.parent_spine_id = p_scale_id
776: and rt.rate_type ='SP'
777: and rt.name = scl.name;

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

1463: stage_to_prate(p_copy_entity_txn_id => p_copy_entity_txn_id,
1464: p_effective_date => l_effective_date,
1465: p_business_group_id => p_business_group_id,
1466: p_gl_frequency => p_gl_frequency);
1467: hr_utility.set_location('pay rates created if any reqd',41);
1468: stage_to_grd_sp(p_copy_entity_txn_id => p_copy_entity_txn_id,
1469: p_effective_date => l_effective_date,
1470: p_business_group_id => p_business_group_id,
1471: p_datetrack_mode => p_datetrack_mode);