DBA Data[Home] [Help]

APPS.GHR_CPDF_CHECK5 dependencies on GHR_GHRWS52L

Line 1658: IF GHR_GHRWS52L.g_temp_step IS NULL THEN

1654: -- 06/25/03 vravikan By passing this edit if the
1655: -- employee on RG Temporary promotion
1656: --upd47 26-Jun-06 Raju From 01-Apr-2006 Added pay plan is other than Yx condition
1657: if P_effective_date < fnd_date.canonical_to_date('2006/04/01') then
1658: IF GHR_GHRWS52L.g_temp_step IS NULL THEN
1659: if p_First_NOAC_Lookup_Code = '703' and
1660: p_prior_pay_rate_det_code in ('A','B','E','F','U','V') and
1661: p_pay_rate_determinant not in ('A','B','E','F','U','V') and
1662: p_pay_rate_determinant is not null

Line 1670: IF GHR_GHRWS52L.g_temp_step IS NULL THEN

1666: hr_utility.raise_error;
1667: end if;
1668: END IF;
1669: ELSE
1670: IF GHR_GHRWS52L.g_temp_step IS NULL THEN
1671: if p_First_NOAC_Lookup_Code = '703' and
1672: p_prior_pay_rate_det_code in ('A','B','E','F','U','V') and
1673: substr(p_prior_pay_plan,1,1) <> ('Y') and
1674: p_pay_rate_determinant not in ('A','B','E','F','U','V') and

Line 1717: IF GHR_GHRWS52L.g_temp_step IS NULL THEN

1713:
1714: IF P_effective_date < to_date('2005/09/01','YYYY/MM/DD') THEN
1715: -- FWFA Changes
1716: IF P_effective_date < to_date('2005/05/01','YYYY/MM/DD') THEN
1717: IF GHR_GHRWS52L.g_temp_step IS NULL THEN
1718: if (substr(p_First_NOAC_Lookup_Code,1,1) = '7'
1719: or
1720: substr(p_First_NOAC_Lookup_Code,1,1)='8')
1721: and

Line 1739: IF GHR_GHRWS52L.g_temp_step IS NULL THEN

1735: hr_utility.raise_error;
1736: end if;
1737: END IF;
1738: ELSIF P_effective_date >= to_date('2005/05/01','YYYY/MM/DD') THEN
1739: IF GHR_GHRWS52L.g_temp_step IS NULL THEN
1740: if (substr(p_First_NOAC_Lookup_Code,1,1) = '7'
1741: or
1742: substr(p_First_NOAC_Lookup_Code,1,1)='8')
1743: and