APPS.PQH_GSP_POST_PROCESS dependencies on PER_PAY_BASES

Line 997: from per_pay_bases

993:
994:
995: cursor csr_annual_factor is
996: select pay_annualization_factor
997: from per_pay_bases
998: where pay_basis_id in (
999: select pay_basis_id
1000: from per_all_assignments_f
1001: where assignment_id= P_Assignment_id

Line 1039: L_pay_basis_id per_pay_bases.pay_basis_id%TYPE;

1035: l_Prog_style Ben_Pgm_F.Enrt_Cd%TYPE;
1036: L_Prog_opt Ben_Pgm_F.DFLT_STEP_CD%TYPE;
1037: L_Elctbl_Flag Varchar2(1) := 'N';
1038: L_Update_Salary_Cd Ben_Pgm_F.Update_Salary_Cd%TYPE;
1039: L_pay_basis_id per_pay_bases.pay_basis_id%TYPE;
1040: l_Dflt_Element_typ_Id Ben_Pgm_F.DFLT_ELEMENT_TYPE_ID%TYPE;
1041: L_Enrt_Rt_Id Ben_Enrt_Rt.Enrt_Rt_Id%TYPE;
1042: l_Cur_Sal Ben_Enrt_Rt.Val%TYPE;
1043: l_Rt_Typ_Cd Ben_Enrt_Rt.Rt_Typ_Cd%TYPE;

Line 1988: from per_pay_bases bas,

1984:
1985:
1986: CURSOR Element_Info(P_assignmnet_id number,P_pay_basis_id number, P_Effective_Date in DAte) IS
1987: Select ele.element_entry_id
1988: from per_pay_bases bas,
1989: pay_element_entries_f ele,
1990: pay_element_entry_values_f entval
1991: where bas.pay_basis_id = P_pay_basis_id
1992: and entval.input_value_id = bas.input_value_id

Line 3239: L_pay_basis_id per_pay_bases.pay_basis_id%TYPE;

3235: l_Prog_style Ben_Pgm_F.Enrt_Cd%TYPE;
3236: L_Prog_opt Ben_Pgm_F.DFLT_STEP_CD%TYPE;
3237: L_Elctbl_Flag Varchar2(1) := 'N';
3238: L_Update_Salary_Cd Ben_Pgm_F.Update_Salary_Cd%TYPE;
3239: L_pay_basis_id per_pay_bases.pay_basis_id%TYPE;
3240: l_Dflt_Element_typ_Id Ben_Pgm_F.DFLT_ELEMENT_TYPE_ID%TYPE;
3241: L_Enrt_Rt_Id Ben_Enrt_Rt.Enrt_Rt_Id%TYPE;
3242: l_Cur_Sal Ben_Enrt_Rt.Val%TYPE;
3243: l_Rt_Typ_Cd Ben_Enrt_Rt.Rt_Typ_Cd%TYPE;

Line 3576: from per_pay_bases bas,

3572:
3573:
3574: CURSOR Element_Info(P_assignmnet_id number,P_pay_basis_id number, P_Effective_Date in DAte) IS
3575: Select ele.element_entry_id
3576: from per_pay_bases bas,
3577: pay_element_entries_f ele,
3578: pay_element_entry_values_f entval
3579: where bas.pay_basis_id = P_pay_basis_id
3580: and entval.input_value_id = bas.input_value_id

Line 3629: from per_pay_bases

3625: and Assignment_id = P_Assignment_id;
3626:
3627: Cursor pay_basis_frequency (p_pay_basis_id in number)is
3628: select pay_basis,PAY_ANNUALIZATION_FACTOR
3629: from per_pay_bases
3630: where pay_basis_id =p_pay_basis_id;
3631:
3632:
3633: L_Enroll_Info Enroll_Info%ROWTYPE;

Line 3639: l_pay_basis per_pay_bases.PAY_BASIS%TYPE;

3635: l_def_elct_chc_id number;
3636: l_plan_elct_chc_id number;
3637: l_oipl_elct_chc_id number;
3638: l_pgm_id number;
3639: l_pay_basis per_pay_bases.PAY_BASIS%TYPE;
3640: l_annualization_factor per_pay_bases.PAY_ANNUALIZATION_FACTOR%TYPE;
3641: l_gl_ann_factor ben_pgm_extra_info.pgi_information5%TYPE;
3642:
3643: Begin

Line 3640: l_annualization_factor per_pay_bases.PAY_ANNUALIZATION_FACTOR%TYPE;

3636: l_plan_elct_chc_id number;
3637: l_oipl_elct_chc_id number;
3638: l_pgm_id number;
3639: l_pay_basis per_pay_bases.PAY_BASIS%TYPE;
3640: l_annualization_factor per_pay_bases.PAY_ANNUALIZATION_FACTOR%TYPE;
3641: l_gl_ann_factor ben_pgm_extra_info.pgi_information5%TYPE;
3642:
3643: Begin
3644: