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.PER_SG_ORG_INFO_LEG_HOOK dependencies on HR_ORGANIZATION_INFORMATION

Line 36: FROM hr_organization_information

32:
33: CURSOR csr_check_csn
34: IS
35: SELECT count(org_information_id)
36: FROM hr_organization_information
37: WHERE org_information_context= 'SG_LEGAL_ENTITY'
38: AND org_information10 = p_org_information1
39: AND organization_id = p_organization_id
40: AND (org_information_id <> p_org_information_id

Line 46: FROM hr_organization_information

42:
43: CURSOR csr_check_csn_multi
44: IS
45: SELECT count(org_information_id)
46: FROM hr_organization_information
47: WHERE org_information_context= 'SG_MULTI_CSN'
48: AND org_information1 = p_org_information1
49: AND organization_id = p_organization_id
50: AND (org_information_id <> p_org_information_id

Line 212: FROM hr_organization_information

208: CURSOR csr_get_payer_id_category
209: IS
210: SELECT org_information3,
211: org_information15
212: FROM hr_organization_information
213: WHERE org_information_context= 'SG_LEGAL_ENTITY'
214: AND organization_id = p_organization_id;
215:
216: l_procedure VARCHAR2(100);

Line 515: FROM hr_organization_information

511: ,org_information17
512: ,org_information18
513: ,org_information19
514: ,org_information20
515: FROM hr_organization_information
516: WHERE org_information_id = p_org_information_id;
517:
518: BEGIN
519: