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 401: hr_organization_information info

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

Line 413: hr_organization_information info

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

Line 425: hr_organization_information info

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

Line 441: hr_organization_information info

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