APPS.PAY_US_PSD_UPGRADE_PKG dependencies on PER_ALL_PEOPLE_F

Line 2057: per_all_people_f ppf

2053: pugu.old_juri_code,
2054: pugu.new_juri_code,
2055: pugu.table_name
2056: FROM pay_us_geo_update pugu,
2057: per_all_people_f ppf
2058: WHERE pugu.id = p_id
2059: AND pugu.process_type = 'PA'
2060: AND pugu.process_mode = p_mode
2061: AND pugu.process_date = p_date

Line 2066: FROM per_all_people_f ppf1

2062: AND pugu.person_id = ppf.person_id
2063: AND NVL(pugu.status,'NULL') = decode(p_mode,'GENERATE','NULL','UPGRADE','C')
2064: AND NOT EXISTS (
2065: SELECT NULL
2066: FROM per_all_people_f ppf1
2067: WHERE ppf1.person_id =ppf.person_id
2068: AND ppf1.effective_end_date > ppf.effective_end_date
2069: )
2070: GROUP BY ppf.full_name,pugu.assignment_id,pugu.old_juri_code,

Line 2101: per_all_people_f ppf

2097: SELECT DISTINCT
2098: substr(ppf.full_name,1,100),
2099: pugu.assignment_id
2100: FROM pay_us_geo_update pugu,
2101: per_all_people_f ppf
2102: WHERE pugu.id = p_id
2103: AND pugu.process_type = 'PA'
2104: AND pugu.process_mode = p_mode
2105: AND pugu.process_date = p_date

Line 2110: FROM per_all_people_f ppf1

2106: AND pugu.person_id = ppf.person_id
2107: AND NVL(pugu.status,'X') ='E'
2108: AND NOT EXISTS (
2109: SELECT NULL
2110: FROM per_all_people_f ppf1
2111: WHERE ppf1.person_id =ppf.person_id
2112: AND ppf1.effective_end_date > ppf.effective_end_date
2113: )
2114: GROUP BY ppf.full_name,pugu.assignment_id

Line 2180: l_full_name per_all_people_f.full_name%TYPE;

2176: l_old_psd_code VARCHAR2(6);
2177: l_new_psd_code VARCHAR2(6);
2178: l_school_dsts_code VARCHAR2(5);
2179: l_jurisdiction_code VARCHAR2(11);
2180: l_full_name per_all_people_f.full_name%TYPE;
2181: l_emp_assignment_id NUMBER;
2182: l_old_jurisdiction_code VARCHAR2(16);
2183: l_new_jurisdiction_code VARCHAR2(16);
2184: l_table_name VARCHAR2(100);

Line 2185: l_print_full_name per_all_people_f.full_name%TYPE;

2181: l_emp_assignment_id NUMBER;
2182: l_old_jurisdiction_code VARCHAR2(16);
2183: l_new_jurisdiction_code VARCHAR2(16);
2184: l_table_name VARCHAR2(100);
2185: l_print_full_name per_all_people_f.full_name%TYPE;
2186: l_print_emp_assignment_id NUMBER;
2187: l_print_old_juri_code VARCHAR2(16);
2188: l_print_new_juri_code VARCHAR2(16);
2189: l_pay_us_asg_reporting VARCHAR2(10);