APPS.PAY_US_USER_CITY_UPGRADE_PKG dependencies on PER_ALL_PEOPLE_F

Line 694: FROM per_all_people_f ppf

690: pugu.old_juri_code,pugu.new_juri_code;
691:
692: CURSOR get_emp_details (p_person_id NUMBER) IS
693: SELECT substr(ppf.full_name,1,100)
694: FROM per_all_people_f ppf
695: WHERE ppf.person_id = p_person_id
696: AND NOT EXISTS
697: (
698: SELECT NULL

Line 699: FROM per_all_people_f ppf1

695: WHERE ppf.person_id = p_person_id
696: AND NOT EXISTS
697: (
698: SELECT NULL
699: FROM per_all_people_f ppf1
700: WHERE ppf1.person_id =ppf.person_id
701: AND ppf1.effective_end_date > ppf.effective_end_date
702: );
703:

Line 727: per_all_people_f ppf

723: SELECT DISTINCT
724: substr(ppf.full_name,1,100),
725: pugu.assignment_id
726: FROM pay_us_geo_update pugu,
727: per_all_people_f ppf
728: WHERE pugu.id = p_id
729: AND pugu.process_type = 'D'
730: AND pugu.process_mode = p_mode
731: AND pugu.person_id = ppf.person_id

Line 737: FROM per_all_people_f ppf1

733: AND pugu.table_value_id IS NULL
734: AND NVL(pugu.status,'E') <>'C'
735: AND NOT EXISTS (
736: SELECT NULL
737: FROM per_all_people_f ppf1
738: WHERE ppf1.person_id =ppf.person_id
739: AND ppf1.effective_end_date > ppf.effective_end_date
740: )
741: GROUP BY ppf.full_name,pugu.assignment_id

Line 767: l_full_name per_all_people_f.full_name%TYPE;

763: l_county_name pay_us_counties.county_name%TYPE;
764: l_city_name pay_us_city_names.city_name%TYPE;
765: l_old_juri_code pay_us_geo_update.old_juri_code%TYPE;
766: l_new_juri_code pay_us_geo_update.new_juri_code%TYPE;
767: l_full_name per_all_people_f.full_name%TYPE;
768: l_assignment_id pay_us_geo_update.assignment_id%TYPE;
769: l_person_id pay_us_geo_update.person_id%TYPE;
770: l_table_name pay_us_geo_update.table_name%TYPE;
771: l_table_count NUMBER;