APPS.PAY_KR_YEA_PDF_PKG dependencies on HR_ASSIGNMENT_SET

Line 243: hr_assignment_set.assignment_in_set(g_assignment_set_id,pa.assignment_id)) = 'Y'

239: where pa.business_group_id + 0 = g_business_group_id
240: and pa.establishment_id = nvl(g_business_place_id,pa.establishment_id)
241: and decode(to_char(nvl(g_assignment_set_id,-1)),
242: '-1','Y',
243: hr_assignment_set.assignment_in_set(g_assignment_set_id,pa.assignment_id)) = 'Y'
244: and pa.assignment_type = 'E'
245: and pa.effective_start_date <= g_target_eoy
246: and pa.effective_end_date >= g_target_soy
247: and ppos.period_of_service_id = pa.period_of_service_id

Line 305: hr_assignment_set.assignment_in_set(p_assignment_set_id,pa.assignment_id)) = 'Y'

301: and pa.effective_end_date >= g_target_soy
302: and pa.establishment_id = nvl(p_business_place_id,pa.establishment_id)
303: and decode(to_char(nvl(p_assignment_set_id,-1)),
304: '-1','Y',
305: hr_assignment_set.assignment_in_set(p_assignment_set_id,pa.assignment_id)) = 'Y'
306: and ppos.period_of_service_id = pa.period_of_service_id
307: and pp.person_id = pa.person_id
308: and pp.effective_start_date <= g_target_eoy
309: and pp.effective_end_date >= g_target_soy

Line 7019: hr_assignment_set.assignment_in_set(g_assignment_set_id,pa.assignment_id)) = 'Y'

7015: and pa.business_group_id = hoi.organization_id
7016: and pa.establishment_id = nvl(g_business_place_id,pa.establishment_id)
7017: and decode(to_char(nvl(g_assignment_set_id,-1)),
7018: '-1','Y',
7019: hr_assignment_set.assignment_in_set(g_assignment_set_id,pa.assignment_id)) = 'Y'
7020: and pa.assignment_type = 'E'
7021: and pa.effective_start_date <= g_target_eoy
7022: and pa.effective_end_date >= g_target_soy
7023: and ppos.period_of_service_id = pa.period_of_service_id