APPS.PAY_IE_NES_REPORT_PKG dependencies on HR_ASSIGNMENT_SETS

Line 410: hr_assignment_sets has

406: IS
407: SELECT DISTINCT hasa.include_or_exclude inc_or_exc
408: FROM
409: hr_assignment_set_amendments hasa,
410: hr_assignment_sets has
411: WHERE hasa.assignment_set_id = has.assignment_set_id
412: AND has.business_group_id = p_business_Group_id
413: AND has.assignment_set_id = p_assignment_set_id;
414:

Line 518: , hr_assignment_sets has

514: IF p_assignment_set_id IS NOT NULL THEN
515: IF l_cur_inc_exc_flag_rec.inc_or_exc = 'I' THEN
516: g_where_clause_asg_set := ' AND EXISTS(SELECT 1
517: FROM hr_assignment_set_amendments hasa
518: , hr_assignment_sets has
519: , per_assignments_f paf
520: WHERE has.assignment_set_id = hasa.assignment_set_id
521: AND has.business_group_id = paaf.business_group_id
522: AND has.assignment_set_id = '|| p_assignment_set_id

Line 528: , hr_assignment_sets has

524: AND paf.person_id = ppf.person_id) ';
525: ELSIF l_cur_inc_exc_flag_rec.inc_or_exc = 'E' THEN
526: g_where_clause_asg_set := ' AND NOT EXISTS(SELECT 1
527: FROM hr_assignment_set_amendments hasa
528: , hr_assignment_sets has
529: , per_assignments_f paf
530: WHERE has.assignment_set_id = hasa.assignment_set_id
531: AND has.business_group_id = paaf.business_group_id
532: AND has.assignment_set_id = '|| p_assignment_set_id