DBA Data[Home] [Help]

APPS.GHR_CPDF_CHECK5 dependencies on GHR_GHRWS52L

Line 1406: IF GHR_GHRWS52L.g_temp_step IS NULL THEN

1402: -- 06/25/03 vravikan By passing this edit if the
1403: -- employee on RG Temporary promotion
1404: --upd47 26-Jun-06 Raju From 01-Apr-2006 Added pay plan is other than Yx condition
1405: if P_effective_date < fnd_date.canonical_to_date('2006/04/01') then
1406: IF GHR_GHRWS52L.g_temp_step IS NULL THEN
1407: if p_First_NOAC_Lookup_Code = '703' and
1408: p_prior_pay_rate_det_code in ('A','B','E','F','U','V') and
1409: p_pay_rate_determinant not in ('A','B','E','F','U','V') and
1410: p_pay_rate_determinant is not null

Line 1418: IF GHR_GHRWS52L.g_temp_step IS NULL THEN

1414: hr_utility.raise_error;
1415: end if;
1416: END IF;
1417: ELSE
1418: IF GHR_GHRWS52L.g_temp_step IS NULL THEN
1419: if p_First_NOAC_Lookup_Code = '703' and
1420: p_prior_pay_rate_det_code in ('A','B','E','F','U','V') and
1421: substr(p_prior_pay_plan,1,1) <> ('Y') and
1422: p_pay_rate_determinant not in ('A','B','E','F','U','V') and

Line 1462: IF GHR_GHRWS52L.g_temp_step IS NULL THEN

1458:
1459: IF P_effective_date < to_date('2005/09/01','YYYY/MM/DD') THEN
1460: -- FWFA Changes
1461: IF P_effective_date < to_date('2005/05/01','YYYY/MM/DD') THEN
1462: IF GHR_GHRWS52L.g_temp_step IS NULL THEN
1463: if (substr(p_First_NOAC_Lookup_Code,1,1) = '7'
1464: or
1465: substr(p_First_NOAC_Lookup_Code,1,1)='8')
1466: and

Line 1484: IF GHR_GHRWS52L.g_temp_step IS NULL THEN

1480: hr_utility.raise_error;
1481: end if;
1482: END IF;
1483: ELSIF P_effective_date >= to_date('2005/05/01','YYYY/MM/DD') THEN
1484: IF GHR_GHRWS52L.g_temp_step IS NULL THEN
1485: if (substr(p_First_NOAC_Lookup_Code,1,1) = '7'
1486: or
1487: substr(p_First_NOAC_Lookup_Code,1,1)='8')
1488: and