APPS.PAY_IE_P35 dependencies on PAY_IE_P35_INSURABLE_WEEKS_V

Line 8452: FROM pay_ie_p35_insurable_weeks_v piw

8448: CURSOR c_p60_second_class
8449: IS
8450: SELECT SUBSTR (piw.combined_class, 1, 2),
8451: NVL (piw.insurable_weeks, 0)
8452: FROM pay_ie_p35_insurable_weeks_v piw
8453: WHERE piw.person_id =
8454: (SELECT asg.person_id
8455: FROM per_assignments_f asg
8456: WHERE asg.assignment_id = p_assignment_id

Line 8464: FROM pay_ie_p35_insurable_weeks_v piw2

8460: WHERE asg.assignment_id =
8461: asg2.assignment_id))
8462: AND piw.insurable_weeks =
8463: (SELECT MAX (piw2.insurable_weeks)
8464: FROM pay_ie_p35_insurable_weeks_v piw2
8465: WHERE piw2.person_id = piw.person_id
8466: AND SUBSTR (piw2.combined_class, 1, 2) <>
8467: RPAD (l_initial_class, 2))
8468: AND piw.minimum_effective_date =

Line 8470: FROM pay_ie_p35_insurable_weeks_v piw3

8466: AND SUBSTR (piw2.combined_class, 1, 2) <>
8467: RPAD (l_initial_class, 2))
8468: AND piw.minimum_effective_date =
8469: (SELECT MIN (piw3.minimum_effective_date)
8470: FROM pay_ie_p35_insurable_weeks_v piw3
8471: WHERE piw3.person_id = piw.person_id
8472: AND piw3.insurable_weeks = piw.insurable_weeks
8473: AND SUBSTR (piw3.combined_class, 1, 2) <>
8474: RPAD (l_initial_class, 2));