DBA Data[Home] [Help]

APPS.PER_CHANGE_PAY_ANALYTICS_PKG dependencies on PER_PAY_PROPOSALS

Line 187: PER_PAY_PROPOSALS PRO ,

183: START WITH paf.assignment_id = EMP_ASSIGNMENT_ID
184: CONNECT BY NOCYCLE PRIOR paf.person_id = nvl(paf.supervisor_id,-1))
185: SUPH ,
186: PER_PAY_BASES PPB ,
187: PER_PAY_PROPOSALS PRO ,
188: PAY_INPUT_VALUES_F PIV ,
189: PAY_ELEMENT_TYPES_F PET ,
190: HR_LOCATIONS_ALL LOC ,
191: PAY_GRADE_RULES_F PGR ,

Line 210: FROM PER_PAY_PROPOSALS PRO2

206: AND ASG.GRADE_ID = PGR.GRADE_OR_SPINAL_POINT_ID
207: AND PPB.RATE_ID = PGR.RATE_ID
208: AND ASG.ASSIGNMENT_ID = PRO.ASSIGNMENT_ID
209: AND PRO.CHANGE_DATE = (SELECT CHANGE_DATE
210: FROM PER_PAY_PROPOSALS PRO2
211: WHERE PRO2.ASSIGNMENT_ID = PRO.ASSIGNMENT_ID
212: AND DAY.EFFECTIVE_DATE BETWEEN PRO2.CHANGE_DATE AND PRO2.DATE_TO
213: AND PRO2.APPROVED = 'Y')
214: AND ASG.PAY_BASIS_ID = PPB.PAY_BASIS_ID