APPS.PAY_IE_NES_REPORT_PKG dependencies on PER_ASSIGNMENTS_F

Line 519: , per_assignments_f paf

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

Line 529: , per_assignments_f paf

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

Line 941: l_assg_id per_assignments_f.assignment_id%TYPE;

937: stperson in number,
938: endperson in number,
939: chunk in number)
940: IS
941: l_assg_id per_assignments_f.assignment_id%TYPE;
942: l_person_id Number;
943: l_assignment_number per_all_assignments_f.assignment_number%type;
944: l_period_of_service_id per_all_assignments_f.period_of_service_id%type;
945: