[Home] [Help]
72: ---To Fetch Service Start Date of the employee
73: CURSOR C_SERVICE_START (P_PERSON_ID PER_ALL_PEOPLE_F.PERSON_ID%TYPE)
74: IS
75: SELECT DATE_START
76: FROM PER_PERIODS_OF_SERVICE
77: WHERE PERSON_ID = P_PERSON_ID
78: AND BUSINESS_GROUP_ID = G_BUSINESS_GROUP_ID;
79:
80: CURSOR C_GET_GLOBAL_VALUE(P_EFFECTIVE_DATE DATE)
1534: ---To Fetch Service Start Date of the employee
1535: CURSOR C_SERVICE_START (P_PERSON_ID PER_ALL_PEOPLE_F.PERSON_ID%TYPE)
1536: IS
1537: SELECT DATE_START
1538: FROM PER_PERIODS_OF_SERVICE
1539: WHERE PERSON_ID = P_PERSON_ID
1540: AND BUSINESS_GROUP_ID = G_BUSINESS_GROUP_ID;
1541:
1542: N_STATE_PENSION_AGE NUMBER := 0;
2871: ---To Fetch Service Start Date of the employee
2872: CURSOR C_SERVICE_START (P_PERSON_ID PER_ALL_PEOPLE_F.PERSON_ID%TYPE)
2873: IS
2874: SELECT DATE_START
2875: FROM PER_PERIODS_OF_SERVICE
2876: WHERE PERSON_ID = P_PERSON_ID
2877: AND BUSINESS_GROUP_ID = G_BUSINESS_GROUP_ID;
2878: -- To get the Period start date of the period - date paid immeditely after Auto-Enrolment Date
2879: CURSOR C_PENSION_ENTRY_START(P_PAYROLL_ID NUMBER,P_SERVICE_START DATE,P_ASG_START_DATE DATE)
3804: ---To Fetch Service Start Date of the employee
3805: CURSOR C_SERVICE_START (P_PERSON_ID PER_ALL_PEOPLE_F.PERSON_ID%TYPE)
3806: IS
3807: SELECT DATE_START
3808: FROM PER_PERIODS_OF_SERVICE
3809: WHERE PERSON_ID = P_PERSON_ID
3810: AND BUSINESS_GROUP_ID = G_BUSINESS_GROUP_ID;
3811:
3812:
3941: ---To Fetch Service Start Date of the employee
3942: CURSOR C_SERVICE_START (P_PERSON_ID PER_ALL_PEOPLE_F.PERSON_ID%TYPE)
3943: IS
3944: SELECT DATE_START
3945: FROM PER_PERIODS_OF_SERVICE
3946: WHERE PERSON_ID = P_PERSON_ID
3947: AND BUSINESS_GROUP_ID = G_BUSINESS_GROUP_ID;
3948: ------------------------------------------------------------------------------------------
3949: ---To find If the Person reaches 22 Yrs. within the Payroll Period