eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_US_USER_CITY_UPGRADE_PKG dependencies on PAY_US_GEO_UPDATE

Line 27: FROM pay_us_geo_update pugu,

23: l_upgrade_needed := 'Y';
24:
25: SELECT DECODE(count(0),0,'N','Y')
26: INTO l_upgrade_needed
27: FROM pay_us_geo_update pugu,
28: pay_patch_status pps
29: WHERE pps.patch_name = 'USER_CITY_UPGRADE'
30: AND pps.phase = 'TO_BE_UPDATED'
31: AND pps.process_type = 'USER_CITY_UPGRADE'

Line 103: FROM pay_us_geo_update pugu,

99: 'N',
100: 'D',
101: l_patch_name,
102: NULL
103: FROM pay_us_geo_update pugu,
104: pay_patch_status pps
105: WHERE pps.patch_name = 'USER_CITY_UPGRADE'
106: AND pps.phase = 'TO_BE_UPDATED'
107: AND pps.process_type = 'USER_CITY_UPGRADE'

Line 130: pay_us_geo_update pugu,

126:
127: sqlstr := ' SELECT DISTINCT paf.person_id
128: FROM per_all_assignments_f paf,
129: pay_us_emp_city_tax_rules_f pect,
130: pay_us_geo_update pugu,
131: pay_patch_status pps
132: WHERE pect.assignment_id = paf.assignment_id
133: AND substr(pugu.old_juri_code,1,2) = pect.state_code
134: AND substr(pugu.old_juri_code,4,3) = pect.county_code

Line 190: pay_us_geo_update pugu,

186: ) IS
187: SELECT DISTINCT ectr.assignment_id
188: FROM per_all_assignments_f paf,
189: pay_us_emp_city_tax_rules_f ectr,
190: pay_us_geo_update pugu,
191: pay_patch_status pps
192: WHERE pps.patch_name = 'USER_CITY_UPGRADE'
193: AND pps.phase = 'TO_BE_UPDATED'
194: AND pps.process_type = 'USER_CITY_UPGRADE'

Line 339: FROM pay_us_geo_update pugu

335: p_status VARCHAR2,
336: p_process_type VARCHAR2) IS
337: SELECT COUNT(0)
338: FROM (SELECT DISTINCT assignment_id
339: FROM pay_us_geo_update pugu
340: WHERE pugu.id = p_id
341: AND pugu.process_type = p_process_type
342: AND pugu.process_mode = p_mode
343: AND pugu.table_name is null

Line 358: FROM pay_us_geo_update pugu,

354: SELECT pugu.old_juri_code,
355: pugu.new_juri_code,
356: substr(pugu.description,3) city_name,
357: substr(pugu.description,1,1) primary_flag
358: FROM pay_us_geo_update pugu,
359: pay_patch_status pps
360: WHERE pps.patch_name = 'USER_CITY_UPGRADE'
361: AND pps.phase = 'TO_BE_UPDATED'
362: AND pps.process_type = 'USER_CITY_UPGRADE'

Line 372: l_process_type pay_us_geo_update.process_type%TYPE;

368:
369: l_upgrade_needed VARCHAR2(2);
370: l_mode VARCHAR2(8);
371: l_id pay_patch_status.id%TYPE;
372: l_process_type pay_us_geo_update.process_type%TYPE;
373: l_applied_date DATE;
374: l_total_assignments NUMBER;
375: l_success_assignments NUMBER;
376: l_error_assignments NUMBER;

Line 378: l_old_juri_code pay_us_geo_update.old_juri_code%TYPE;

374: l_total_assignments NUMBER;
375: l_success_assignments NUMBER;
376: l_error_assignments NUMBER;
377: l_assignments_to_be_updated NUMBER;
378: l_old_juri_code pay_us_geo_update.old_juri_code%TYPE;
379: l_new_juri_code pay_us_geo_update.new_juri_code%TYPE;
380: l_city_name pay_us_city_names.city_name%TYPE;
381: l_primary_flag pay_us_city_names.primary_flag%TYPE;
382:

Line 379: l_new_juri_code pay_us_geo_update.new_juri_code%TYPE;

375: l_success_assignments NUMBER;
376: l_error_assignments NUMBER;
377: l_assignments_to_be_updated NUMBER;
378: l_old_juri_code pay_us_geo_update.old_juri_code%TYPE;
379: l_new_juri_code pay_us_geo_update.new_juri_code%TYPE;
380: l_city_name pay_us_city_names.city_name%TYPE;
381: l_primary_flag pay_us_city_names.primary_flag%TYPE;
382:
383: BEGIN

Line 397: FROM pay_us_geo_update pugu,

393: l_upgrade_needed := 'Y';
394:
395: SELECT DECODE(count(0),0,'N','Y')
396: INTO l_upgrade_needed
397: FROM pay_us_geo_update pugu,
398: pay_patch_status pps
399: WHERE pps.patch_name = 'USER_CITY_UPGRADE'
400: AND pps.phase = 'TO_BE_UPDATED'
401: AND pps.process_type = 'USER_CITY_UPGRADE'

Line 460: pay_us_geo_update pugu,

456: SELECT count(DISTINCT paf.assignment_id)
457: INTO l_assignments_to_be_updated
458: FROM per_all_assignments_f paf,
459: pay_us_emp_city_tax_rules_f pect,
460: pay_us_geo_update pugu,
461: pay_patch_status pps
462: WHERE pect.assignment_id = paf.assignment_id
463: AND substr(pugu.old_juri_code,1,2) = pect.state_code
464: AND substr(pugu.old_juri_code,4,3) = pect.county_code

Line 574: UPDATE pay_us_geo_update pugu

570: END LOOP;
571:
572: CLOSE get_user_city_update_details;
573:
574: UPDATE pay_us_geo_update pugu
575: SET process_mode = 'UPDATED'
576: WHERE EXISTS
577: (SELECT NULL
578: FROM pay_patch_status pps

Line 646: FROM pay_us_geo_update pugu,

642: puc.county_name,
643: substr(pugu.description,3) city_name,
644: pugu.old_juri_code,
645: pugu.new_juri_code
646: FROM pay_us_geo_update pugu,
647: pay_patch_status pps,
648: pay_us_states pus,
649: pay_us_counties puc
650: WHERE pps.patch_name = 'USER_CITY_UPGRADE'

Line 670: FROM pay_us_geo_update pugu

666: pugu.assignment_id,
667: pugu.old_juri_code,
668: pugu.new_juri_code,
669: COUNT(DISTINCT pugu.table_name)
670: FROM pay_us_geo_update pugu
671: WHERE pugu.id = p_id
672: AND pugu.process_type = 'D'
673: AND pugu.process_mode = p_mode
674: AND pugu.table_name IS NOT NULL

Line 677: FROM pay_us_geo_update pugu1

673: AND pugu.process_mode = p_mode
674: AND pugu.table_name IS NOT NULL
675: AND EXISTS
676: (SELECT NULL
677: FROM pay_us_geo_update pugu1
678: WHERE pugu1.id = p_id
679: AND pugu1.process_type = 'D'
680: AND pugu1.process_mode = p_mode
681: AND pugu1.person_id = pugu.person_id

Line 711: FROM pay_us_geo_update pugu

707: p_assignment_id NUMBER,
708: p_old_juri_code VARCHAR2,
709: p_new_juri_code VARCHAR2) IS
710: SELECT DISTINCT pugu.table_name
711: FROM pay_us_geo_update pugu
712: WHERE pugu.id = p_id
713: AND pugu.process_type = 'D'
714: AND pugu.process_mode = p_mode
715: AND pugu.person_id = p_person_id

Line 726: FROM pay_us_geo_update pugu,

722: CURSOR get_emp_in_error(p_id NUMBER,p_mode VARCHAR2) IS
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

Line 750: FROM pay_us_geo_update pugu

746: p_status VARCHAR2,
747: p_process_type VARCHAR2) IS
748: SELECT COUNT(0)
749: FROM (SELECT DISTINCT assignment_id
750: FROM pay_us_geo_update pugu
751: WHERE pugu.id = p_id
752: AND pugu.process_type = p_process_type
753: AND pugu.process_mode = p_mode
754: AND pugu.table_name is null

Line 765: l_old_juri_code pay_us_geo_update.old_juri_code%TYPE;

761: l_state_name pay_us_states.state_name%TYPE;
762: l_state_abbrev pay_us_states.state_abbrev%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;

Line 766: l_new_juri_code pay_us_geo_update.new_juri_code%TYPE;

762: l_state_abbrev pay_us_states.state_abbrev%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;

Line 768: l_assignment_id pay_us_geo_update.assignment_id%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;
772: l_process_type VARCHAR2(2) := 'D';

Line 769: l_person_id pay_us_geo_update.person_id%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;
772: l_process_type VARCHAR2(2) := 'D';
773: l_total_assignments NUMBER;

Line 770: l_table_name pay_us_geo_update.table_name%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;
772: l_process_type VARCHAR2(2) := 'D';
773: l_total_assignments NUMBER;
774: l_success_assignments NUMBER;