APPS.FTE_COMP_CONSTRAINT_UTIL dependencies on FTE_LOCATION_PARAMETERS

Line 81: wsh_locations wl, fte_location_parameters flp

77: 'ORGANIZATION' company_type,
78: nvl(nvl(flp.facility_code,wl.location_code),to_char(wl.wsh_location_id)) facility_code,
79: nvl(flp.description,wl.ui_location_code) description
80: FROM HR_ORGANIZATION_UNITS HAOU, HR_ORGANIZATION_INFORMATION HOI1, MTL_PARAMETERS MP,
81: wsh_locations wl, fte_location_parameters flp
82: WHERE haou.location_id = wl.source_location_id
83: AND wl.location_source_code = 'HR'
84: AND HAOU.ORGANIZATION_ID = HOI1.ORGANIZATION_ID
85: AND HAOU.ORGANIZATION_ID = MP.ORGANIZATION_ID

Line 101: fte_location_parameters flp

97: nvl(flp.description,wl.ui_location_code) description
98: from hz_parties hp , hz_party_sites hps,
99: hz_cust_acct_sites_all hcas,
100: wsh_locations wl,
101: fte_location_parameters flp
102: where hcas.party_site_id = hps.party_site_id
103: and hps.party_id = hp.party_id
104: AND hps.location_id = wl.source_location_id
105: and wl.location_source_code = 'HZ'

Line 119: fte_location_parameters flp

115: nvl(flp.description,wl.ui_location_code) description
116: from hz_party_sites hps,
117: wsh_carriers_v wc,
118: wsh_locations wl,
119: fte_location_parameters flp
120: where hps.party_id = wc.carrier_id
121: AND hps.location_id = wl.source_location_id
122: and wl.location_source_code = 'HZ'
123: and wc.active='A'

Line 138: fte_location_parameters flp

134: po_vendors po,
135: hz_relationships rel,
136: hz_party_sites hps,
137: wsh_locations wl,
138: fte_location_parameters flp
139: WHERE hps.party_id = hp.party_id
140: AND rel.relationship_type = 'POS_VENDOR_PARTY'
141: and rel.object_id = hp.party_id
142: and rel.object_table_name = 'HZ_PARTIES'