APPS.PAY_IE_P35 dependencies on PAY_IE_P35_INSURABLE_WEEKS_V

Line 5182: FROM pay_ie_p35_insurable_weeks_v piw

5178: CURSOR c_p60_second_class
5179: IS
5180: SELECT SUBSTR (piw.combined_class, 1, 2),
5181: NVL (piw.insurable_weeks, 0)
5182: FROM pay_ie_p35_insurable_weeks_v piw
5183: WHERE piw.person_id =
5184: (SELECT asg.person_id
5185: FROM per_assignments_f asg
5186: WHERE asg.assignment_id = p_assignment_id

Line 5194: FROM pay_ie_p35_insurable_weeks_v piw2

5190: WHERE asg.assignment_id =
5191: asg2.assignment_id))
5192: AND piw.insurable_weeks =
5193: (SELECT MAX (piw2.insurable_weeks)
5194: FROM pay_ie_p35_insurable_weeks_v piw2
5195: WHERE piw2.person_id = piw.person_id
5196: AND SUBSTR (piw2.combined_class, 1, 2) <>
5197: RPAD (l_initial_class, 2))
5198: AND piw.minimum_effective_date =

Line 5200: FROM pay_ie_p35_insurable_weeks_v piw3

5196: AND SUBSTR (piw2.combined_class, 1, 2) <>
5197: RPAD (l_initial_class, 2))
5198: AND piw.minimum_effective_date =
5199: (SELECT MIN (piw3.minimum_effective_date)
5200: FROM pay_ie_p35_insurable_weeks_v piw3
5201: WHERE piw3.person_id = piw.person_id
5202: AND piw3.insurable_weeks = piw.insurable_weeks
5203: AND SUBSTR (piw3.combined_class, 1, 2) <>
5204: RPAD (l_initial_class, 2));