APPS.FTE_CAT_VALIDATE_PKG dependencies on HR_GENERAL

Line 105: and nvl (hl.business_group_id,nvl(hr_general.get_business_group_id, -99) )

101: and nvl(wrb.country_code,'XX') = decode(wrb.country_code, NULL, 'XX', nvl(hl.country,wrb.country_code))
102: and nvl(wr.postal_code_from,'99') <= decode(wr.postal_code_from, NULL, '99',nvl(hl.postal_code,wr.postal_code_from))
103: and nvl(wr.postal_code_to,'99') <= decode(wr.postal_code_to, NULL, '99',nvl(hl.postal_code,wr.postal_code_to))
104: and nvl(wrb.state_code,'XX') = nvl(hl.region_2,wrb.state_code)
105: and nvl (hl.business_group_id,nvl(hr_general.get_business_group_id, -99) )
106: = nvl (hr_general.get_business_group_id, -99)
107: and hl.location_id = hlt.location_id and hlt.language = userenv('LANG')
108: ;
109:

Line 106: = nvl (hr_general.get_business_group_id, -99)

102: and nvl(wr.postal_code_from,'99') <= decode(wr.postal_code_from, NULL, '99',nvl(hl.postal_code,wr.postal_code_from))
103: and nvl(wr.postal_code_to,'99') <= decode(wr.postal_code_to, NULL, '99',nvl(hl.postal_code,wr.postal_code_to))
104: and nvl(wrb.state_code,'XX') = nvl(hl.region_2,wrb.state_code)
105: and nvl (hl.business_group_id,nvl(hr_general.get_business_group_id, -99) )
106: = nvl (hr_general.get_business_group_id, -99)
107: and hl.location_id = hlt.location_id and hlt.language = userenv('LANG')
108: ;
109:
110:

Line 142: and nvl (hl.business_group_id,nvl(hr_general.get_business_group_id, -99) )

138: and nvl(wrb.country_code,'XX') = decode(wrb.country_code, NULL, 'XX', nvl(hl.country,wrb.country_code))
139: and nvl(wr.postal_code_from,'99') <= decode(wr.postal_code_from, NULL, '99',nvl(hl.postal_code,wr.postal_code_from))
140: and nvl(wr.postal_code_to,'99') <= decode(wr.postal_code_to, NULL, '99',nvl(hl.postal_code,wr.postal_code_to))
141: and nvl(wrb.state_code,'XX') = nvl(hl.region_2,wrb.state_code)
142: and nvl (hl.business_group_id,nvl(hr_general.get_business_group_id, -99) )
143: = nvl (hr_general.get_business_group_id, -99)
144: and hl.location_id = hlt.location_id and hlt.language = userenv('LANG')
145: ;
146:

Line 143: = nvl (hr_general.get_business_group_id, -99)

139: and nvl(wr.postal_code_from,'99') <= decode(wr.postal_code_from, NULL, '99',nvl(hl.postal_code,wr.postal_code_from))
140: and nvl(wr.postal_code_to,'99') <= decode(wr.postal_code_to, NULL, '99',nvl(hl.postal_code,wr.postal_code_to))
141: and nvl(wrb.state_code,'XX') = nvl(hl.region_2,wrb.state_code)
142: and nvl (hl.business_group_id,nvl(hr_general.get_business_group_id, -99) )
143: = nvl (hr_general.get_business_group_id, -99)
144: and hl.location_id = hlt.location_id and hlt.language = userenv('LANG')
145: ;
146:
147:

Line 178: and nvl (hl.business_group_id,nvl(hr_general.get_business_group_id, -99) )

174: and nvl(wrb.country_code,'XX') = decode(wrb.country_code, NULL, 'XX', nvl(hl.country,wrb.country_code))
175: and nvl(wr.postal_code_from,'99') <= decode(wr.postal_code_from, NULL, '99',nvl(hl.postal_code,wr.postal_code_from))
176: and nvl(wr.postal_code_to,'99') <= decode(wr.postal_code_to, NULL, '99',nvl(hl.postal_code,wr.postal_code_to))
177: and nvl(wrb.state_code,'XX') = nvl(hl.region_2,wrb.state_code)
178: and nvl (hl.business_group_id,nvl(hr_general.get_business_group_id, -99) )
179: = nvl (hr_general.get_business_group_id, -99)
180: and hl.location_id = hlt.location_id and hlt.language = userenv('LANG')
181: ;
182:

Line 179: = nvl (hr_general.get_business_group_id, -99)

175: and nvl(wr.postal_code_from,'99') <= decode(wr.postal_code_from, NULL, '99',nvl(hl.postal_code,wr.postal_code_from))
176: and nvl(wr.postal_code_to,'99') <= decode(wr.postal_code_to, NULL, '99',nvl(hl.postal_code,wr.postal_code_to))
177: and nvl(wrb.state_code,'XX') = nvl(hl.region_2,wrb.state_code)
178: and nvl (hl.business_group_id,nvl(hr_general.get_business_group_id, -99) )
179: = nvl (hr_general.get_business_group_id, -99)
180: and hl.location_id = hlt.location_id and hlt.language = userenv('LANG')
181: ;
182:
183: