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_PSD_UPGRADE_PKG dependencies on PAY_US_MODIFIED_GEOCODES

Line 26: FROM pay_us_modified_geocodes pumg

22: SELECT city_name psdcode_change,
23: state_code,
24: county_code,
25: old_city_code
26: FROM pay_us_modified_geocodes pumg
27: WHERE process_type = 'PA'
28: AND NOT EXISTS
29: (SELECT NULL
30: FROM pay_us_geo_update pugu,

Line 46: l_psdcode_change pay_us_modified_geocodes.city_name%TYPE;

42: AND pps.status = 'C');
43:
44: l_upgrade_needed VARCHAR2(2) DEFAULT 'N';
45: l_index VARCHAR2(17);
46: l_psdcode_change pay_us_modified_geocodes.city_name%TYPE;
47: l_state_code pay_us_modified_geocodes.state_code%TYPE;
48: l_county_code pay_us_modified_geocodes.county_code%TYPE;
49: l_city_code pay_us_modified_geocodes.old_city_code%TYPE;
50: l_count NUMBER;

Line 47: l_state_code pay_us_modified_geocodes.state_code%TYPE;

43:
44: l_upgrade_needed VARCHAR2(2) DEFAULT 'N';
45: l_index VARCHAR2(17);
46: l_psdcode_change pay_us_modified_geocodes.city_name%TYPE;
47: l_state_code pay_us_modified_geocodes.state_code%TYPE;
48: l_county_code pay_us_modified_geocodes.county_code%TYPE;
49: l_city_code pay_us_modified_geocodes.old_city_code%TYPE;
50: l_count NUMBER;
51:

Line 48: l_county_code pay_us_modified_geocodes.county_code%TYPE;

44: l_upgrade_needed VARCHAR2(2) DEFAULT 'N';
45: l_index VARCHAR2(17);
46: l_psdcode_change pay_us_modified_geocodes.city_name%TYPE;
47: l_state_code pay_us_modified_geocodes.state_code%TYPE;
48: l_county_code pay_us_modified_geocodes.county_code%TYPE;
49: l_city_code pay_us_modified_geocodes.old_city_code%TYPE;
50: l_count NUMBER;
51:
52: BEGIN

Line 49: l_city_code pay_us_modified_geocodes.old_city_code%TYPE;

45: l_index VARCHAR2(17);
46: l_psdcode_change pay_us_modified_geocodes.city_name%TYPE;
47: l_state_code pay_us_modified_geocodes.state_code%TYPE;
48: l_county_code pay_us_modified_geocodes.county_code%TYPE;
49: l_city_code pay_us_modified_geocodes.old_city_code%TYPE;
50: l_count NUMBER;
51:
52: BEGIN
53:

Line 502: FROM pay_us_modified_geocodes pumg

498: SELECT substr(pumg.city_name,1,6),
499: substr(pumg.city_name,8,6),
500: substr(pumg.city_name,15,5),
501: state_code||'-'||county_code||'-'||old_city_code
502: FROM pay_us_modified_geocodes pumg
503: WHERE pumg.process_type = 'PA'
504: AND pay_us_psd_upgrade_pkg.upgrade_needed(pumg.state_code,
505: pumg.county_code,
506: pumg.old_city_code,

Line 513: FROM pay_us_modified_geocodes pumg1,

509:
510: CURSOR get_swap_psdcode_details IS
511: SELECT substr(pumg1.city_name,1,6),
512: substr(pumg1.city_name,8,6)
513: FROM pay_us_modified_geocodes pumg1,
514: pay_us_modified_geocodes pumg2
515: WHERE pumg1.process_type = 'PA'
516: AND pay_us_psd_upgrade_pkg.upgrade_needed(pumg1.state_code,
517: pumg1.county_code,

Line 514: pay_us_modified_geocodes pumg2

510: CURSOR get_swap_psdcode_details IS
511: SELECT substr(pumg1.city_name,1,6),
512: substr(pumg1.city_name,8,6)
513: FROM pay_us_modified_geocodes pumg1,
514: pay_us_modified_geocodes pumg2
515: WHERE pumg1.process_type = 'PA'
516: AND pay_us_psd_upgrade_pkg.upgrade_needed(pumg1.state_code,
517: pumg1.county_code,
518: pumg1.old_city_code,

Line 578: pay_us_modified_geocodes pumg

574: ,p_date
575: ,p_mode
576: ,substr(pumg.city_name,8,6)
577: FROM pay_us_asg_reporting puar,
578: pay_us_modified_geocodes pumg
579: WHERE puar.assignment_id = p_assignment_id
580: AND length(puar.jurisdiction_code) = 16
581: AND substr(puar.jurisdiction_code,1,2) = '39'
582: AND (substr(puar.jurisdiction_code,4,6) = substr(pumg.city_name,1,6) or

Line 623: pay_us_modified_geocodes pumg

619: FROM pay_element_entries_f pee,
620: pay_element_entry_values_f peev,
621: pay_input_values_f piv,
622: pay_element_type_rules petr,
623: pay_us_modified_geocodes pumg
624: WHERE pee.assignment_id = p_assignment_id
625: AND pee.element_type_id = petr.element_type_id
626: AND peev.element_entry_id = pee.element_entry_id
627: AND petr.element_set_id = p_element_set_id

Line 685: pay_us_modified_geocodes pumg,

681: ,p_date
682: ,p_mode
683: ,substr(pumg.city_name,8,6)
684: FROM pay_run_results prr,
685: pay_us_modified_geocodes pumg,
686: pay_element_types_f pet,
687: pay_input_values_f piv
688: WHERE prr.assignment_action_id = tab_assignment_action_id(i)
689: AND length(prr.jurisdiction_code) = 16

Line 734: pay_us_modified_geocodes pumg,

730: ,p_mode
731: ,substr(pumg.city_name,8,6)
732: FROM pay_run_results prr,
733: pay_run_result_values prv,
734: pay_us_modified_geocodes pumg,
735: pay_element_types_f pet,
736: pay_input_values_f piv,
737: pay_element_type_rules petr
738: WHERE prr.assignment_action_id = tab_assignment_action_id(i)

Line 808: pay_us_modified_geocodes pumg

804: ,p_date
805: ,p_mode
806: ,substr(pumg.city_name,8,6)
807: FROM pay_action_information pai,
808: pay_us_modified_geocodes pumg
809: WHERE pai.action_context_id = tab_assignment_action_id(i)
810: AND pai.action_context_type = 'AAP'
811: AND pai.action_information_category = 'US PSD'
812: AND length(pai.jurisdiction_code) = 16

Line 878: pay_us_modified_geocodes pumg

874: ,p_date
875: ,p_mode
876: ,substr(pumg.city_name,8,6)
877: FROM ff_archive_item_contexts faic,
878: pay_us_modified_geocodes pumg
879: WHERE faic.archive_item_id = l_archive_item_id
880: AND length(faic.context) = 16
881: AND substr(faic.context,1,2) = '39'
882: AND (substr(faic.context,4,6) = substr(pumg.city_name,1,6) or

Line 917: pay_us_modified_geocodes pumg

913: AND EXISTS
914: (SELECT NULL
915: FROM pay_us_emp_city_tax_rules_f pect,
916: pay_us_city_school_dsts pcsd,
917: pay_us_modified_geocodes pumg
918: WHERE pect.assignment_id = p_assignment_id
919: AND pect.jurisdiction_code = pumg.state_code||'-'||pumg.county_code||'-'||pumg.old_city_code
920: AND pugu.description = substr(pumg.city_name,8,6)
921: AND nvl(pect.school_district_code,substr(pumg.city_name,15,5)) <> substr(pumg.city_name,15,5)

Line 1211: pay_us_modified_geocodes pumg

1207:
1208: sqlstr := ' SELECT DISTINCT paf.person_id
1209: FROM per_all_assignments_f paf,
1210: pay_us_emp_city_tax_rules_f pect,
1211: pay_us_modified_geocodes pumg
1212: WHERE pumg.process_type = ''PA''
1213: AND pect.assignment_id = paf.assignment_id
1214: AND pect.state_code = pumg.state_code
1215: AND pect.county_code = pumg.county_code

Line 1284: pay_us_modified_geocodes pumg

1280: ) IS
1281: SELECT DISTINCT ectr.assignment_id
1282: FROM per_all_assignments_f paf,
1283: pay_us_emp_city_tax_rules_f ectr,
1284: pay_us_modified_geocodes pumg
1285: WHERE pumg.state_code = ectr.state_code
1286: AND pumg.county_code = ectr.county_code
1287: AND pumg.old_city_code = ectr.city_code
1288: AND pumg.process_type = 'PA'

Line 1807: pay_us_modified_geocodes pumg

1803: ,l_date
1804: ,l_mode
1805: ,substr(pumg.city_name,8,6)
1806: FROM ff_archive_items fai,
1807: pay_us_modified_geocodes pumg
1808: WHERE fai.context1 = l_psd_pact_id
1809: AND fai.user_entity_id = l_er_psd_entity_id
1810: AND fai.value= substr(pumg.city_name,1,6)
1811: AND pumg.process_type = 'PA'

Line 1849: pay_us_modified_geocodes pumg

1845: ,l_mode
1846: ,substr(pumg.city_name,8,6)
1847: FROM hr_organization_information hoi,
1848: hr_organization_units hou,
1849: pay_us_modified_geocodes pumg
1850: WHERE hoi.org_information_context='PSD Reporting Rules'
1851: AND substr(hoi.org_information10,1,6) = substr(pumg.city_name,1,6)
1852: AND pumg.process_type = 'PA'
1853: AND hou.organization_id =hoi.organization_id

Line 1993: FROM pay_us_modified_geocodes pumg

1989: 'PA',
1990: l_date,
1991: l_mode,
1992: 'C'
1993: FROM pay_us_modified_geocodes pumg
1994: WHERE pumg.process_type = 'PA'
1995: AND pay_us_psd_upgrade_pkg.upgrade_needed(pumg.state_code,
1996: pumg.county_code,
1997: pumg.old_city_code,

Line 2041: FROM pay_us_modified_geocodes pumg

2037: SELECT substr(pumg.city_name,1,6),
2038: substr(pumg.city_name,8,6),
2039: substr(pumg.city_name,15,5),
2040: state_code||'-'||county_code||'-'||old_city_code
2041: FROM pay_us_modified_geocodes pumg
2042: WHERE pumg.process_type = 'PA'
2043: AND pay_us_psd_upgrade_pkg.upgrade_needed(pumg.state_code,
2044: pumg.county_code,
2045: pumg.old_city_code,