APPS.PAY_US_TRR_ENGINE_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 36: hr_organization_information info

32:
33: cursor gre_sizes_gre is
34: select count(*) gre_size, info.organization_id gre_id, hoi.name gre_name
35: from hr_organization_units hoi,
36: hr_organization_information info
37: where hoi.organization_id = info.organization_id
38: and info.org_information_context = 'CLASS'
39: and info.org_information1 = 'HR_LEGAL'
40: and hoi.business_group_id = p_business_group

Line 48: hr_organization_information info

44:
45: cursor gre_sizes is
46: select count(*) gre_size, info.organization_id gre_id, hoi.name gre_name
47: from hr_organization_units hoi,
48: hr_organization_information info
49: where hoi.organization_id = info.organization_id
50: and info.org_information_context = 'CLASS'
51: and info.org_information1 = 'HR_LEGAL'
52: and hoi.business_group_id = p_business_group

Line 60: hr_organization_information info

56:
57: cursor gre_sizes_gre_state is
58: select count(*) gre_size, info.organization_id gre_id, hoi.name gre_name
59: from hr_organization_units hoi,
60: hr_organization_information info
61: where hoi.organization_id = info.organization_id
62: and info.org_information_context = 'CLASS'
63: and info.org_information1 = 'HR_LEGAL'
64: and hoi.business_group_id = p_business_group

Line 76: hr_organization_information info

72: cursor gre_sizes_state is
73: select /*+ INDEX(hoi.hao HR_ORGANIZATION_UNITS_FK1) */
74: count(*) gre_size,info.organization_id gre_id, hoi.name gre_name
75: from hr_organization_units hoi,
76: hr_organization_information info
77: where hoi.organization_id = info.organization_id
78: and info.org_information_context = 'CLASS'
79: and info.org_information1 = 'HR_LEGAL'
80: and hoi.business_group_id = p_business_group

Line 399: hr_organization_information info

395:
396: cursor gre_sizes_gre is
397: select count(*) gre_size, info.organization_id gre_id, hoi.name gre_name
398: from hr_organization_units hoi,
399: hr_organization_information info
400: where hoi.organization_id = info.organization_id
401: and info.org_information_context = 'CLASS'
402: and info.org_information1 = 'HR_LEGAL'
403: and hoi.business_group_id = p_business_group

Line 411: hr_organization_information info

407:
408: cursor gre_sizes is
409: select count(*) gre_size, info.organization_id gre_id, hoi.name gre_name
410: from hr_organization_units hoi,
411: hr_organization_information info
412: where hoi.organization_id = info.organization_id
413: and info.org_information_context = 'CLASS'
414: and info.org_information1 = 'HR_LEGAL'
415: and hoi.business_group_id = p_business_group

Line 423: hr_organization_information info

419:
420: cursor gre_sizes_gre_juri(cv_jurisdiction varchar2) is
421: select count(*) gre_size, info.organization_id gre_id, hoi.name gre_name
422: from hr_organization_units hoi,
423: hr_organization_information info
424: where hoi.organization_id = info.organization_id
425: and info.org_information_context = 'CLASS'
426: and info.org_information1 = 'HR_LEGAL'
427: and hoi.business_group_id = p_business_group

Line 439: hr_organization_information info

435: cursor gre_sizes_juri(cv_jurisdiction varchar2) is
436: select /*+ INDEX(hoi.hao HR_ORGANIZATION_UNITS_FK1) */
437: count(*) gre_size, info.organization_id gre_id, hoi.name gre_name
438: from hr_organization_units hoi,
439: hr_organization_information info
440: where hoi.organization_id = info.organization_id
441: and info.org_information_context = 'CLASS'
442: and info.org_information1 = 'HR_LEGAL'
443: and hoi.business_group_id = p_business_group