DBA Data[Home] [Help]

APPS.PER_SALADMIN_ANALYTICS_PKG dependencies on FND_PROFILE

Line 61: ,CASE WHEN PPB.PAY_BASIS = 'HOURLY' or fnd_profile.value('PER_ANNUAL_SALARY_ON_FTE') = 'N'

57: , PGR.RATE_ID
58: , HRI_BPL_ABV.CALC_ABV( ASG.ASSIGNMENT_ID
59: ,ASG.BUSINESS_GROUP_ID ,'HEAD'
60: ,PRO.CHANGE_DATE) HEADCOUNT
61: ,CASE WHEN PPB.PAY_BASIS = 'HOURLY' or fnd_profile.value('PER_ANNUAL_SALARY_ON_FTE') = 'N'
62: THEN (PPB.PAY_ANNUALIZATION_FACTOR * PRO.PROPOSED_SALARY_N)
63: ELSE (PPB.PAY_ANNUALIZATION_FACTOR * PRO.PROPOSED_SALARY_N)/CASE WHEN PER_SALADMIN_UTILITY.GET_FTE_FACTOR(ASG.ASSIGNMENT_ID ,DAY.EFFECTIVE_DATE) = 0 THEN 1
64: ELSE PER_SALADMIN_UTILITY.GET_FTE_FACTOR(ASG.ASSIGNMENT_ID ,DAY.EFFECTIVE_DATE) END END SALARY
65: ,PGR.CURRENCY_CODE GRADE_CURRENCY