APPS.PAYRPENP dependencies on HR_ORGANIZATION_UNITS

Line 47: hr_organization_units tax,

43: cursor c_get_gre_name is
44: select tax.name
45: from
46: hr_soft_coding_keyflex flx,
47: hr_organization_units tax,
48: hr_organization_information inf
49: where
50: tax.organization_id = inf.organization_id
51: and inf.org_information_context||'' = 'CLASS'

Line 56: l_gre_name hr_organization_units.name%TYPE;

52: and inf.org_information1 = 'HR_LEGAL'
53: and flx.soft_coding_keyflex_id = p_soft_coding_keyflex_id
54: and tax.organization_id = flx.segment1;
55:
56: l_gre_name hr_organization_units.name%TYPE;
57:
58: BEGIN
59:
60: open c_get_gre_name;

Line 92: hr_organization_units tax,

88: cursor c_get_gre_id is
89: select tax.organization_id
90: from
91: hr_soft_coding_keyflex flx,
92: hr_organization_units tax,
93: hr_organization_information inf
94: where
95: tax.organization_id = inf.organization_id
96: and inf.org_information_context||'' = 'CLASS'

Line 101: l_gre_id hr_organization_units.organization_id%TYPE;

97: and inf.org_information1 = 'HR_LEGAL'
98: and flx.soft_coding_keyflex_id = p_soft_coding_keyflex_id
99: and tax.organization_id = flx.segment1;
100:
101: l_gre_id hr_organization_units.organization_id%TYPE;
102:
103: BEGIN
104:
105: open c_get_gre_id;