DBA Data[Home] [Help]

APPS.PER_CHANGE_PAY_ANALYTICS_PKG dependencies on PER_SALADMIN_UTILITY

Line 134: PER_SALADMIN_UTILITY.GET_FTE_FACTOR(ASG.ASSIGNMENT_ID

130: CASE WHEN PPB.PAY_BASIS = 'HOURLY' THEN (PPB.PAY_ANNUALIZATION_FACTOR *
131: PRO.PROPOSED_SALARY_N)
132: ELSE (PPB.PAY_ANNUALIZATION_FACTOR * PRO.PROPOSED_SALARY_N)/CASE WHEN
133:
134: PER_SALADMIN_UTILITY.GET_FTE_FACTOR(ASG.ASSIGNMENT_ID
135: ,DAY.EFFECTIVE_DATE) = 0 THEN 1 ELSE
136:
137: PER_SALADMIN_UTILITY.GET_FTE_FACTOR(ASG.ASSIGNMENT_ID
138: ,DAY.EFFECTIVE_DATE) END END SALARY ,

Line 137: PER_SALADMIN_UTILITY.GET_FTE_FACTOR(ASG.ASSIGNMENT_ID

133:
134: PER_SALADMIN_UTILITY.GET_FTE_FACTOR(ASG.ASSIGNMENT_ID
135: ,DAY.EFFECTIVE_DATE) = 0 THEN 1 ELSE
136:
137: PER_SALADMIN_UTILITY.GET_FTE_FACTOR(ASG.ASSIGNMENT_ID
138: ,DAY.EFFECTIVE_DATE) END END SALARY ,
139: PGR.CURRENCY_CODE GRADE_CURRENCY ,
140: CASE WHEN PET.INPUT_CURRENCY_CODE IS NOT NULL
141: AND PGR.CURRENCY_CODE IS NOT NULL

Line 143: THEN PER_SALADMIN_UTILITY.GET_CURRENCY_RATE( PGR.CURRENCY_CODE,

139: PGR.CURRENCY_CODE GRADE_CURRENCY ,
140: CASE WHEN PET.INPUT_CURRENCY_CODE IS NOT NULL
141: AND PGR.CURRENCY_CODE IS NOT NULL
142: AND PGR.CURRENCY_CODE <> PET.INPUT_CURRENCY_CODE
143: THEN PER_SALADMIN_UTILITY.GET_CURRENCY_RATE( PGR.CURRENCY_CODE,
144: PET.INPUT_CURRENCY_CODE, DAY.EFFECTIVE_DATE,
145:
146: ASG.BUSINESS_GROUP_ID) * PGR.MINIMUM*PPB.GRADE_ANNUALIZATION_FACTOR
147: ELSE PGR.MINIMUM*PPB.GRADE_ANNUALIZATION_FACTOR END GRADE_MIN ,

Line 151: THEN PER_SALADMIN_UTILITY.GET_CURRENCY_RATE( PGR.CURRENCY_CODE,

147: ELSE PGR.MINIMUM*PPB.GRADE_ANNUALIZATION_FACTOR END GRADE_MIN ,
148: CASE WHEN PET.INPUT_CURRENCY_CODE IS NOT NULL
149: AND PGR.CURRENCY_CODE IS NOT NULL
150: AND PGR.CURRENCY_CODE <> PET.INPUT_CURRENCY_CODE
151: THEN PER_SALADMIN_UTILITY.GET_CURRENCY_RATE( PGR.CURRENCY_CODE,
152: PET.INPUT_CURRENCY_CODE, DAY.EFFECTIVE_DATE,
153:
154: ASG.BUSINESS_GROUP_ID) * PGR.MAXIMUM*PPB.GRADE_ANNUALIZATION_FACTOR ELSE
155: PGR.MAXIMUM*PPB.GRADE_ANNUALIZATION_FACTOR END

Line 161: THEN PER_SALADMIN_UTILITY.GET_CURRENCY_RATE( PGR.CURRENCY_CODE,

157: GRADE_MAX ,
158: CASE WHEN PET.INPUT_CURRENCY_CODE IS NOT NULL
159: AND PGR.CURRENCY_CODE IS NOT NULL
160: AND PGR.CURRENCY_CODE <> PET.INPUT_CURRENCY_CODE
161: THEN PER_SALADMIN_UTILITY.GET_CURRENCY_RATE( PGR.CURRENCY_CODE,
162: PET.INPUT_CURRENCY_CODE, DAY.EFFECTIVE_DATE,
163:
164: ASG.BUSINESS_GROUP_ID) * PGR.MID_VALUE*PPB.GRADE_ANNUALIZATION_FACTOR
165: ELSE PGR.MID_VALUE*PPB.GRADE_ANNUALIZATION_FACTOR END