APPS.PQH_GSP_POST_PROCESS dependencies on PER_PAY_BASES

Line 938: L_pay_basis_id per_pay_bases.pay_basis_id%TYPE;

934: l_Prog_style Ben_Pgm_F.Enrt_Cd%TYPE;
935: L_Prog_opt Ben_Pgm_F.DFLT_STEP_CD%TYPE;
936: L_Elctbl_Flag Varchar2(1) := 'N';
937: L_Update_Salary_Cd Ben_Pgm_F.Update_Salary_Cd%TYPE;
938: L_pay_basis_id per_pay_bases.pay_basis_id%TYPE;
939: l_Dflt_Element_typ_Id Ben_Pgm_F.DFLT_ELEMENT_TYPE_ID%TYPE;
940: L_Enrt_Rt_Id Ben_Enrt_Rt.Enrt_Rt_Id%TYPE;
941: l_Cur_Sal Ben_Enrt_Rt.Val%TYPE;
942: l_Rt_Typ_Cd Ben_Enrt_Rt.Rt_Typ_Cd%TYPE;

Line 1828: from per_pay_bases bas,

1824:
1825:
1826: CURSOR Element_Info(P_assignmnet_id number,P_pay_basis_id number, P_Effective_Date in DAte) IS
1827: Select ele.element_entry_id
1828: from per_pay_bases bas,
1829: pay_element_entries_f ele,
1830: pay_element_entry_values_f entval
1831: where bas.pay_basis_id = P_pay_basis_id
1832: and entval.input_value_id = bas.input_value_id

Line 3079: L_pay_basis_id per_pay_bases.pay_basis_id%TYPE;

3075: l_Prog_style Ben_Pgm_F.Enrt_Cd%TYPE;
3076: L_Prog_opt Ben_Pgm_F.DFLT_STEP_CD%TYPE;
3077: L_Elctbl_Flag Varchar2(1) := 'N';
3078: L_Update_Salary_Cd Ben_Pgm_F.Update_Salary_Cd%TYPE;
3079: L_pay_basis_id per_pay_bases.pay_basis_id%TYPE;
3080: l_Dflt_Element_typ_Id Ben_Pgm_F.DFLT_ELEMENT_TYPE_ID%TYPE;
3081: L_Enrt_Rt_Id Ben_Enrt_Rt.Enrt_Rt_Id%TYPE;
3082: l_Cur_Sal Ben_Enrt_Rt.Val%TYPE;
3083: l_Rt_Typ_Cd Ben_Enrt_Rt.Rt_Typ_Cd%TYPE;

Line 3416: from per_pay_bases bas,

3412:
3413:
3414: CURSOR Element_Info(P_assignmnet_id number,P_pay_basis_id number, P_Effective_Date in DAte) IS
3415: Select ele.element_entry_id
3416: from per_pay_bases bas,
3417: pay_element_entries_f ele,
3418: pay_element_entry_values_f entval
3419: where bas.pay_basis_id = P_pay_basis_id
3420: and entval.input_value_id = bas.input_value_id

Line 3469: from per_pay_bases

3465: and Assignment_id = P_Assignment_id;
3466:
3467: Cursor pay_basis_frequency (p_pay_basis_id in number)is
3468: select pay_basis,PAY_ANNUALIZATION_FACTOR
3469: from per_pay_bases
3470: where pay_basis_id =p_pay_basis_id;
3471:
3472:
3473: L_Enroll_Info Enroll_Info%ROWTYPE;

Line 3479: l_pay_basis per_pay_bases.PAY_BASIS%TYPE;

3475: l_def_elct_chc_id number;
3476: l_plan_elct_chc_id number;
3477: l_oipl_elct_chc_id number;
3478: l_pgm_id number;
3479: l_pay_basis per_pay_bases.PAY_BASIS%TYPE;
3480: l_annualization_factor per_pay_bases.PAY_ANNUALIZATION_FACTOR%TYPE;
3481: l_gl_ann_factor ben_pgm_extra_info.pgi_information5%TYPE;
3482:
3483: Begin

Line 3480: l_annualization_factor per_pay_bases.PAY_ANNUALIZATION_FACTOR%TYPE;

3476: l_plan_elct_chc_id number;
3477: l_oipl_elct_chc_id number;
3478: l_pgm_id number;
3479: l_pay_basis per_pay_bases.PAY_BASIS%TYPE;
3480: l_annualization_factor per_pay_bases.PAY_ANNUALIZATION_FACTOR%TYPE;
3481: l_gl_ann_factor ben_pgm_extra_info.pgi_information5%TYPE;
3482:
3483: Begin
3484: