APPS.ENG_CHANGE_ROUTE_PEOPLE_UTIL dependencies on FND_LOOKUPS

Line 138: FROM FND_LOOKUPS AssigneeTypeLookup

134:
135: CURSOR assignee_type_cur(p_assignee_type VARCHAR2)
136: IS
137: SELECT AssigneeTypeLookup.MEANING ASSIGNEE_TYPE
138: FROM FND_LOOKUPS AssigneeTypeLookup
139: WHERE AssigneeTypeLookup.LOOKUP_CODE = p_assignee_type
140: AND AssigneeTypeLookup.LOOKUP_TYPE = 'ENG_ROUTE_ASSIGNEE_TYPES' ;
141:
142: CURSOR role_assignee_cur(p_role_id NUMBER)

Line 154: FROM FND_LOOKUPS AssigneeTypeLookup

150: CURSOR role_assignee_lkup_cur
151: IS
152: SELECT AssigneeTypeLookup.MEANING ASSIGNEE_TYPE
153: , '' ASSIGNEE_COMPANY
154: FROM FND_LOOKUPS AssigneeTypeLookup
155: WHERE AssigneeTypeLookup.LOOKUP_CODE = 'ROLE'
156: AND AssigneeTypeLookup.LOOKUP_TYPE = 'ENG_ROUTE_ASSIGNEE_TYPES' ;
157:
158:

Line 178: FROM FND_LOOKUPS AssigneeTypeLookup

174: IS
175: SELECT Parties.PARTY_NAME ASSIGNEE_NAME
176: , AssigneeTypeLookup.MEANING ASSIGNEE_TYPE
177: , Company.PARTY_NAME ASSIGNEE_COMPANY
178: FROM FND_LOOKUPS AssigneeTypeLookup
179: , HZ_RELATIONSHIPS Emp_Cmpy
180: , HZ_PARTIES Company
181: , HZ_PARTIES Parties
182: WHERE AssigneeTypeLookup.LOOKUP_CODE = 'PERSON'

Line 203: FROM FND_LOOKUPS AssigneeTypeLookup

199: IS
200: SELECT Grp.PARTY_NAME ASSIGNEE_NAME
201: , AssigneeTypeLookup.MEANING ASSIGNEE_TYPE
202: , '' ASSIGNEE_COMPANY
203: FROM FND_LOOKUPS AssigneeTypeLookup
204: , HZ_PARTIES Grp
205: WHERE AssigneeTypeLookup.LOOKUP_CODE = 'GROUP'
206: AND AssigneeTypeLookup.LOOKUP_TYPE = 'ENG_ROUTE_ASSIGNEE_TYPES'
207: AND Grp.PARTY_TYPE = 'GROUP'

Line 216: FROM FND_LOOKUPS ChgPolicyAssigneeLookup

212: IS
213: SELECT ChgPolicyAssigneeLookup.MEANING ASSIGNEE_NAME
214: , AssigneeTypeLookup.MEANING ASSIGNEE_TYPE
215: , '' ASSIGNEE_COMPANY
216: FROM FND_LOOKUPS ChgPolicyAssigneeLookup
217: , FND_LOOKUPS AssigneeTypeLookup
218: WHERE AssigneeTypeLookup.LOOKUP_CODE = 'CHANGE_POLICY'
219: AND AssigneeTypeLookup.LOOKUP_TYPE = 'ENG_ROUTE_ASSIGNEE_TYPES'
220: AND ChgPolicyAssigneeLookup.LOOKUP_TYPE = 'ENG_ROUTE_CHG_POLICY_ASSIGNEES'

Line 217: , FND_LOOKUPS AssigneeTypeLookup

213: SELECT ChgPolicyAssigneeLookup.MEANING ASSIGNEE_NAME
214: , AssigneeTypeLookup.MEANING ASSIGNEE_TYPE
215: , '' ASSIGNEE_COMPANY
216: FROM FND_LOOKUPS ChgPolicyAssigneeLookup
217: , FND_LOOKUPS AssigneeTypeLookup
218: WHERE AssigneeTypeLookup.LOOKUP_CODE = 'CHANGE_POLICY'
219: AND AssigneeTypeLookup.LOOKUP_TYPE = 'ENG_ROUTE_ASSIGNEE_TYPES'
220: AND ChgPolicyAssigneeLookup.LOOKUP_TYPE = 'ENG_ROUTE_CHG_POLICY_ASSIGNEES'
221: AND ChgPolicyAssigneeLookup.LOOKUP_CODE = p_chg_policy_assignee_id ;