APPS.PAY_IE_NES_REPORT_PKG dependencies on HR_ASSIGNMENT_SET_AMENDMENTS

Line 409: hr_assignment_set_amendments hasa,

405: CURSOR cur_inc_exc_flag
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;

Line 517: FROM hr_assignment_set_amendments hasa

513:
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

Line 527: FROM hr_assignment_set_amendments hasa

523: ||' AND hasa.assignment_id = paf.assignment_id
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