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_GEO_UPD_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 1336: from hr_organization_information hoi

1332: )
1333: OR (piv.legislation_code is null
1334: and piv.business_group_id is not null
1335: and exists (select 'Y'
1336: from hr_organization_information hoi
1337: where hoi.organization_id = piv.business_group_id
1338: and hoi.org_information_context = 'Business Group Information'
1339: and hoi.org_information9 in ('US','CA')
1340: )

Line 4237: 'HR_ORGANIZATION_INFORMATION',

4233: SELECT DISTINCT
4234: p_geo_phase_id,
4235: NULL,
4236: NULL,
4237: 'HR_ORGANIZATION_INFORMATION',
4238: hoi.org_information_id,
4239: l_jurisdiction_code,
4240: l_jurisdiction_code,
4241: 'CY',

Line 4246: FROM hr_organization_information hoi

4242: sysdate,
4243: p_mode,
4244: NULL,
4245: 'EEO_REPORT'||':'||'ORG_INFORMATION7'
4246: FROM hr_organization_information hoi
4247: WHERE org_information7 = l_city_name_change.old_city_name
4248: AND org_information8 = l_city_name_change.state_abbrev
4249: AND org_information_context = 'EEO_REPORT';
4250:

Line 4251: UPDATE hr_organization_information

4247: WHERE org_information7 = l_city_name_change.old_city_name
4248: AND org_information8 = l_city_name_change.state_abbrev
4249: AND org_information_context = 'EEO_REPORT';
4250:
4251: UPDATE hr_organization_information
4252: SET org_information7 = l_city_name_change.new_city_name
4253: WHERE org_information7 = l_city_name_change.old_city_name
4254: AND org_information8 = l_city_name_change.state_abbrev
4255: AND org_information_context = 'EEO_REPORT';

Line 4587: 'HR_ORGANIZATION_INFORMATION',

4583: SELECT DISTINCT
4584: p_geo_phase_id,
4585: NULL,
4586: NULL,
4587: 'HR_ORGANIZATION_INFORMATION',
4588: hoi.org_information_id,
4589: l_jurisdiction_code,
4590: l_jurisdiction_code,
4591: 'CY',

Line 4596: FROM hr_organization_information hoi

4592: sysdate,
4593: p_mode,
4594: NULL,
4595: 'EEO_REPORT'||':'||'ORG_INFORMATION7'
4596: FROM hr_organization_information hoi
4597: WHERE org_information7 = l_city_name_change.old_city_name
4598: AND org_information8 = l_city_name_change.state_abbrev
4599: AND org_information_context = 'EEO_REPORT';
4600:

Line 4639: -- hr_organization_information table where the org_information_context

4635: /* End of Changes for Bug#14314081 */
4636:
4637: -- This procedure is separate from the above main upgrade_geocodes
4638: -- This procedure will update the org_information1 column in the
4639: -- hr_organization_information table where the org_information_context
4640: -- is 'Local Tax Rules'
4641: -- This procedure will only be run by one process, NOT MULTIPLE TIMES
4642:
4643: PROCEDURE update_org_info(P_GEO_PHASE_ID IN NUMBER,

Line 4649: --Retrieve all changed geocodes in the hr_organization_information table

4645: P_PATCH_NAME IN VARCHAR2)
4646:
4647: IS
4648:
4649: --Retrieve all changed geocodes in the hr_organization_information table
4650:
4651: CURSOR org_info_cur IS
4652: SELECT distinct org_information1
4653: FROM pay_us_modified_geocodes pmod,

Line 4654: hr_organization_information hoi

4650:
4651: CURSOR org_info_cur IS
4652: SELECT distinct org_information1
4653: FROM pay_us_modified_geocodes pmod,
4654: hr_organization_information hoi
4655: WHERE pmod.state_code = substr(hoi.org_information1,1,2)
4656: AND pmod.county_code = substr(hoi.org_information1,4,3)
4657: AND pmod.old_city_code = substr(hoi.org_information1,8,4)
4658: AND pmod.process_type in ('UP','PU','RP')

Line 4662: where pugu.table_name = 'HR_ORGANIZATION_INFORMATION'

4658: AND pmod.process_type in ('UP','PU','RP')
4659: AND pmod.patch_name = p_patch_name
4660: AND hoi.org_information_context = 'Local Tax Rules'
4661: AND NOT EXISTS (select 'Y' from PAY_US_GEO_UPDATE pugu
4662: where pugu.table_name = 'HR_ORGANIZATION_INFORMATION'
4663: and pugu.new_juri_code = hoi.org_information1
4664: and pugu.process_mode = g_mode
4665: and pugu.process_type = g_process_type
4666: and pugu.id = g_geo_phase_id);

Line 4674: --Retrieve all changed org_information1 on hr_organization_information table.

4670: --
4671: --
4672: --Per bug 2996546
4673: --Added a cursor org_info_ca_cur to the procedure update_org_info
4674: --Retrieve all changed org_information1 on hr_organization_information table.
4675: --and update (for Canadian Legislation)
4676: --
4677:
4678: CURSOR org_info_ca_cur IS

Line 4681: hr_organization_information hoi

4677:
4678: CURSOR org_info_ca_cur IS
4679: SELECT distinct hoi.org_information1, hoi.org_information_id
4680: FROM pay_us_modified_geocodes pmod,
4681: hr_organization_information hoi
4682: WHERE pmod.state_code = 'CA'
4683: AND pmod.county_code = substr(hoi.org_information1,1,2)
4684: AND pmod.patch_name = p_patch_name
4685: AND hoi.org_information_context in

Line 4696: new_geocode hr_organization_information.org_information1%TYPE;

4692: ) ;
4693: org_info_ca_rec org_info_ca_cur%ROWTYPE;
4694: --
4695: --
4696: new_geocode hr_organization_information.org_information1%TYPE;
4697: l_proc_type pay_us_modified_geocodes.process_type%TYPE;
4698: l_error_message_text varchar2(240);
4699:
4700: BEGIN

Line 4726: UPDATE hr_organization_information

4722: hr_utility.set_location('pay_us_geo_upd_pkg.update_org_info',2);
4723:
4724: IF G_MODE = 'UPGRADE' THEN
4725:
4726: UPDATE hr_organization_information
4727: SET org_information1 = new_geocode
4728: WHERE org_information1 = org_info_rec.org_information1
4729: AND org_information_context = 'Local Tax Rules';
4730:

Line 4746: p_location => 'HR_ORGANIZATION_INFORMATION',

4742: p_person_id => null,
4743: p_assign_id => null,
4744: p_old_juri_code => org_info_rec.org_information1,
4745: p_new_juri_code => new_geocode,
4746: p_location => 'HR_ORGANIZATION_INFORMATION',
4747: p_id => null);
4748:
4749: hr_utility.set_location('pay_us_geo_upd_pkg.update_org_info',4);
4750:

Line 4759: --Update of hr_organization_information . org_information1

4755: --
4756: --
4757:
4758: --Per bug 2996546
4759: --Update of hr_organization_information . org_information1
4760: --(Canadian Legislation)
4761:
4762: OPEN org_info_ca_cur;
4763: LOOP

Line 4780: UPDATE hr_organization_information

4776: AND pmod.patch_name = p_patch_name;
4777:
4778: IF G_MODE = 'UPGRADE' THEN
4779:
4780: UPDATE hr_organization_information
4781: SET org_information1 = new_geocode
4782: WHERE org_information1 = org_info_ca_rec.org_information1
4783: AND org_information_id = org_info_ca_rec.org_information_id
4784: AND org_information_context in

Line 4808: p_location => 'HR_ORGANIZATION_INFORMATION',

4804: p_person_id => null,
4805: p_assign_id => null,
4806: p_old_juri_code => org_info_rec.org_information1,
4807: p_new_juri_code => new_geocode,
4808: p_location => 'HR_ORGANIZATION_INFORMATION',
4809: p_id => null);
4810:
4811: hr_utility.set_location('pay_us_geo_upd_pkg.update_org_info',20);
4812: END LOOP ;