eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_UM_APPROVAL_REQUESTS_PVT dependencies on HZ_PARTIES

Line 41: FROM JTF_UM_USERTYPES_VL UT, JTF_UM_APPROVALS_B APPR, HZ_PARTIES PARTY,

37: SELECT UTREG.USERTYPE_REG_ID REG_ID, UTREG.LAST_UPDATE_DATE REG_LAST_UPDATE_DATE,
38: FU.USER_NAME USER_NAME, PARTY.PARTY_TYPE PARTY_TYPE, PARTY.PARTY_ID PARTY_ID,
39: ''USERTYPE'' ENTITY_SOURCE, UT.USERTYPE_SHORTNAME ENTITY_NAME,
40: UTREG.WF_ITEM_TYPE WF_ITEM_TYPE, FU2.USER_NAME APPROVER
41: FROM JTF_UM_USERTYPES_VL UT, JTF_UM_APPROVALS_B APPR, HZ_PARTIES PARTY,
42: JTF_UM_USERTYPE_REG UTREG, FND_USER FU, FND_USER FU2
43: WHERE UTREG.STATUS_CODE in (''PENDING'', ''UPGRADE_APPROVAL_PENDING'')
44: AND UTREG.USERTYPE_ID = UT.USERTYPE_ID
45: AND UT.APPROVAL_ID = APPR.APPROVAL_ID

Line 58: HZ_PARTIES PARTY,

54: ''ENROLLMENT'' ENTITY_SOURCE, SUB.SUBSCRIPTION_NAME ENTITY_NAME,
55: SUBREG.WF_ITEM_TYPE WF_ITEM_TYPE, FU2.USER_NAME APPROVER
56: FROM JTF_UM_SUBSCRIPTIONS_VL SUB,
57: JTF_UM_APPROVALS_B APPR,
58: HZ_PARTIES PARTY,
59: JTF_UM_SUBSCRIPTION_REG SUBREG,
60: FND_USER FU,
61: JTF_UM_USERTYPE_REG UTREG,
62: FND_USER FU2

Line 75: l_party_id HZ_PARTIES.PARTY_ID%TYPE;

71: AND UTREG.STATUS_CODE not in (''PENDING'', ''UPGRADE_APPROVAL_PENDING'')
72: AND nvl (UTREG.EFFECTIVE_END_DATE, sysdate + 1) > sysdate
73: AND FU2.USER_ID (+) = SUBREG.APPROVER_USER_ID
74: ) sys_requests ';
75: l_party_id HZ_PARTIES.PARTY_ID%TYPE;
76: CURSOR GET_COMPANY_NAME IS
77: SELECT PARTY.PARTY_NAME FROM HZ_PARTIES PARTY, HZ_RELATIONSHIPS PREL
78: WHERE PARTY.PARTY_ID = PREL.OBJECT_ID
79: AND PREL.PARTY_ID = l_party_id

Line 77: SELECT PARTY.PARTY_NAME FROM HZ_PARTIES PARTY, HZ_RELATIONSHIPS PREL

73: AND FU2.USER_ID (+) = SUBREG.APPROVER_USER_ID
74: ) sys_requests ';
75: l_party_id HZ_PARTIES.PARTY_ID%TYPE;
76: CURSOR GET_COMPANY_NAME IS
77: SELECT PARTY.PARTY_NAME FROM HZ_PARTIES PARTY, HZ_RELATIONSHIPS PREL
78: WHERE PARTY.PARTY_ID = PREL.OBJECT_ID
79: AND PREL.PARTY_ID = l_party_id
80: AND PREL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
81: AND PREL.OBJECT_TABLE_NAME = 'HZ_PARTIES'

Line 80: AND PREL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

76: CURSOR GET_COMPANY_NAME IS
77: SELECT PARTY.PARTY_NAME FROM HZ_PARTIES PARTY, HZ_RELATIONSHIPS PREL
78: WHERE PARTY.PARTY_ID = PREL.OBJECT_ID
79: AND PREL.PARTY_ID = l_party_id
80: AND PREL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
81: AND PREL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
82: AND PREL.START_DATE < SYSDATE
83: AND NVL(PREL.END_DATE, SYSDATE+1) > SYSDATE
84: AND PREL.RELATIONSHIP_CODE in ('EMPLOYEE_OF', 'CONTACT_OF')

Line 81: AND PREL.OBJECT_TABLE_NAME = 'HZ_PARTIES'

77: SELECT PARTY.PARTY_NAME FROM HZ_PARTIES PARTY, HZ_RELATIONSHIPS PREL
78: WHERE PARTY.PARTY_ID = PREL.OBJECT_ID
79: AND PREL.PARTY_ID = l_party_id
80: AND PREL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
81: AND PREL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
82: AND PREL.START_DATE < SYSDATE
83: AND NVL(PREL.END_DATE, SYSDATE+1) > SYSDATE
84: AND PREL.RELATIONSHIP_CODE in ('EMPLOYEE_OF', 'CONTACT_OF')
85: ORDER BY PREL.START_DATE;

Line 86: l_party_type HZ_PARTIES.PARTY_TYPE%TYPE;

82: AND PREL.START_DATE < SYSDATE
83: AND NVL(PREL.END_DATE, SYSDATE+1) > SYSDATE
84: AND PREL.RELATIONSHIP_CODE in ('EMPLOYEE_OF', 'CONTACT_OF')
85: ORDER BY PREL.START_DATE;
86: l_party_type HZ_PARTIES.PARTY_TYPE%TYPE;
87: i NUMBER := 1;
88: BEGIN
89: IF p_number_of_records IS NOT NULL AND p_number_of_records <> 0 THEN
90: l_rownum := p_number_of_records;

Line 153: l_company_id HZ_PARTIES.PARTY_ID%TYPE;

149: p_approver_user_id in number,
150: x_result out NOCOPY APPROVAL_REQUEST_TABLE_TYPE) IS
151: l_rownum number := 10; -- Default value
152: l_dummy_user_id FND_USER.USER_ID%TYPE;
153: l_company_id HZ_PARTIES.PARTY_ID%TYPE;
154: l_party_name HZ_PARTIES.PARTY_NAME%TYPE;
155: APPR_REQ APPR_REQ_CUR;
156: qry varchar2(4000) := 'SELECT * FROM
157: (SELECT REG_ID, REG_LAST_UPDATE_DATE, USER_NAME, ENTITY_SOURCE,

Line 154: l_party_name HZ_PARTIES.PARTY_NAME%TYPE;

150: x_result out NOCOPY APPROVAL_REQUEST_TABLE_TYPE) IS
151: l_rownum number := 10; -- Default value
152: l_dummy_user_id FND_USER.USER_ID%TYPE;
153: l_company_id HZ_PARTIES.PARTY_ID%TYPE;
154: l_party_name HZ_PARTIES.PARTY_NAME%TYPE;
155: APPR_REQ APPR_REQ_CUR;
156: qry varchar2(4000) := 'SELECT * FROM
157: (SELECT REG_ID, REG_LAST_UPDATE_DATE, USER_NAME, ENTITY_SOURCE,
158: ENTITY_NAME, WF_ITEM_TYPE,

Line 173: AND PREL.SUBJECT_TABLE_NAME = ''HZ_PARTIES''

169: AND APPR.USE_PENDING_REQ_FLAG = ''Y''
170: AND UTREG.USER_ID = FU.USER_ID
171: AND FU.CUSTOMER_ID = PREL.PARTY_ID
172: AND PREL.OBJECT_ID = :l_company_id
173: AND PREL.SUBJECT_TABLE_NAME = ''HZ_PARTIES''
174: AND PREL.OBJECT_TABLE_NAME = ''HZ_PARTIES''
175: AND PREL.START_DATE < SYSDATE
176: AND NVL(PREL.END_DATE, SYSDATE+1) > SYSDATE
177: AND PREL.RELATIONSHIP_CODE in (''EMPLOYEE_OF'', ''CONTACT_OF'')

Line 174: AND PREL.OBJECT_TABLE_NAME = ''HZ_PARTIES''

170: AND UTREG.USER_ID = FU.USER_ID
171: AND FU.CUSTOMER_ID = PREL.PARTY_ID
172: AND PREL.OBJECT_ID = :l_company_id
173: AND PREL.SUBJECT_TABLE_NAME = ''HZ_PARTIES''
174: AND PREL.OBJECT_TABLE_NAME = ''HZ_PARTIES''
175: AND PREL.START_DATE < SYSDATE
176: AND NVL(PREL.END_DATE, SYSDATE+1) > SYSDATE
177: AND PREL.RELATIONSHIP_CODE in (''EMPLOYEE_OF'', ''CONTACT_OF'')
178: AND nvl (UTREG.EFFECTIVE_END_DATE, sysdate + 1) > sysdate

Line 194: AND PREL.SUBJECT_TABLE_NAME = ''HZ_PARTIES''

190: AND APPR.USE_PENDING_REQ_FLAG = ''Y''
191: AND SUBREG.USER_ID = FU.USER_ID
192: AND FU.CUSTOMER_ID = PREL.PARTY_ID
193: AND PREL.OBJECT_ID = :l_company_id
194: AND PREL.SUBJECT_TABLE_NAME = ''HZ_PARTIES''
195: AND PREL.OBJECT_TABLE_NAME = ''HZ_PARTIES''
196: AND PREL.RELATIONSHIP_CODE in (''EMPLOYEE_OF'', ''CONTACT_OF'')
197: AND PREL.START_DATE < SYSDATE
198: AND NVL(PREL.END_DATE, SYSDATE+1) > SYSDATE

Line 195: AND PREL.OBJECT_TABLE_NAME = ''HZ_PARTIES''

191: AND SUBREG.USER_ID = FU.USER_ID
192: AND FU.CUSTOMER_ID = PREL.PARTY_ID
193: AND PREL.OBJECT_ID = :l_company_id
194: AND PREL.SUBJECT_TABLE_NAME = ''HZ_PARTIES''
195: AND PREL.OBJECT_TABLE_NAME = ''HZ_PARTIES''
196: AND PREL.RELATIONSHIP_CODE in (''EMPLOYEE_OF'', ''CONTACT_OF'')
197: AND PREL.START_DATE < SYSDATE
198: AND NVL(PREL.END_DATE, SYSDATE+1) > SYSDATE
199: AND (SUBREG.EFFECTIVE_END_DATE IS null OR SUBREG.EFFECTIVE_END_DATE > sysdate)

Line 207: FROM HZ_PARTIES PARTY, HZ_RELATIONSHIPS PREL, FND_USER FU

203: AND SUBREG.APPROVER_USER_ID = :l_dummy_user_id
204: ) pri_requests ';
205: CURSOR GET_COMPANY_NAME IS
206: SELECT PARTY.PARTY_NAME, PARTY.PARTY_ID
207: FROM HZ_PARTIES PARTY, HZ_RELATIONSHIPS PREL, FND_USER FU
208: WHERE PARTY.PARTY_ID = PREL.OBJECT_ID
209: AND PREL.PARTY_ID = FU.CUSTOMER_ID
210: AND FU.USER_ID = p_approver_user_id
211: AND PREL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

Line 211: AND PREL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

207: FROM HZ_PARTIES PARTY, HZ_RELATIONSHIPS PREL, FND_USER FU
208: WHERE PARTY.PARTY_ID = PREL.OBJECT_ID
209: AND PREL.PARTY_ID = FU.CUSTOMER_ID
210: AND FU.USER_ID = p_approver_user_id
211: AND PREL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
212: AND PREL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
213: AND PREL.START_DATE < SYSDATE
214: AND NVL(PREL.END_DATE, SYSDATE+1) > SYSDATE
215: AND PREL.RELATIONSHIP_CODE = 'EMPLOYEE_OF'

Line 212: AND PREL.OBJECT_TABLE_NAME = 'HZ_PARTIES'

208: WHERE PARTY.PARTY_ID = PREL.OBJECT_ID
209: AND PREL.PARTY_ID = FU.CUSTOMER_ID
210: AND FU.USER_ID = p_approver_user_id
211: AND PREL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
212: AND PREL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
213: AND PREL.START_DATE < SYSDATE
214: AND NVL(PREL.END_DATE, SYSDATE+1) > SYSDATE
215: AND PREL.RELATIONSHIP_CODE = 'EMPLOYEE_OF'
216: ORDER BY PREL.START_DATE DESC;

Line 304: FROM JTF_UM_USERTYPES_VL UT, JTF_UM_APPROVALS_B APPR, HZ_PARTIES PARTY,

300: REG_LAST_UPDATE_DATE, FU.USER_NAME USER_NAME,
301: PARTY.PARTY_TYPE PARTY_TYPE, PARTY.PARTY_ID PARTY_ID,
302: ''USERTYPE'' ENTITY_SOURCE, UT.USERTYPE_SHORTNAME ENTITY_NAME,
303: UTREG.WF_ITEM_TYPE WF_ITEM_TYPE
304: FROM JTF_UM_USERTYPES_VL UT, JTF_UM_APPROVALS_B APPR, HZ_PARTIES PARTY,
305: JTF_UM_USERTYPE_REG UTREG, FND_USER FU
306: WHERE UTREG.STATUS_CODE in (''PENDING'', ''UPGRADE_APPROVAL_PENDING'')
307: AND UTREG.USERTYPE_ID = UT.USERTYPE_ID
308: AND UT.APPROVAL_ID = APPR.APPROVAL_ID

Line 319: FROM JTF_UM_SUBSCRIPTIONS_VL SUB, JTF_UM_APPROVALS_B APPR, HZ_PARTIES PARTY,

315: SELECT SUBREG.SUBSCRIPTION_REG_ID REG_ID, SUBREG.LAST_UPDATE_DATE REG_LAST_UPDATE_DATE,
316: FU.USER_NAME USER_NAME, PARTY.PARTY_TYPE PARTY_TYPE,
317: PARTY.PARTY_ID PARTY_ID, ''ENROLLMENT'' ENTITY_SOURCE,
318: SUB.SUBSCRIPTION_NAME ENTITY_NAME, SUBREG.WF_ITEM_TYPE WF_ITEM_TYPE
319: FROM JTF_UM_SUBSCRIPTIONS_VL SUB, JTF_UM_APPROVALS_B APPR, HZ_PARTIES PARTY,
320: JTF_UM_SUBSCRIPTION_REG SUBREG, FND_USER FU, JTF_UM_USERTYPE_REG UTREG
321: WHERE SUBREG.STATUS_CODE in (''PENDING'', ''UPGRADE_APPROVAL_PENDING'')
322: AND SUBREG.SUBSCRIPTION_ID = SUB.SUBSCRIPTION_ID
323: AND SUB.APPROVAL_ID = APPR.APPROVAL_ID

Line 333: l_party_id HZ_PARTIES.PARTY_ID%TYPE;

329: AND UTREG.STATUS_CODE not in (''PENDING'', ''UPGRADE_APPROVAL_PENDING'')
330: AND nvl (UTREG.EFFECTIVE_END_DATE, sysdate + 1) > sysdate
331: AND SUBREG.APPROVER_USER_ID = :p_approver_user_id
332: ) owner_requests ';
333: l_party_id HZ_PARTIES.PARTY_ID%TYPE;
334: CURSOR GET_COMPANY_NAME IS
335: SELECT PARTY.PARTY_NAME
336: FROM HZ_PARTIES PARTY, HZ_RELATIONSHIPS PREL
337: WHERE PARTY.PARTY_ID = PREL.OBJECT_ID

Line 336: FROM HZ_PARTIES PARTY, HZ_RELATIONSHIPS PREL

332: ) owner_requests ';
333: l_party_id HZ_PARTIES.PARTY_ID%TYPE;
334: CURSOR GET_COMPANY_NAME IS
335: SELECT PARTY.PARTY_NAME
336: FROM HZ_PARTIES PARTY, HZ_RELATIONSHIPS PREL
337: WHERE PARTY.PARTY_ID = PREL.OBJECT_ID
338: AND PREL.PARTY_ID = l_party_id
339: AND PREL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
340: AND PREL.OBJECT_TABLE_NAME = 'HZ_PARTIES'

Line 339: AND PREL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

335: SELECT PARTY.PARTY_NAME
336: FROM HZ_PARTIES PARTY, HZ_RELATIONSHIPS PREL
337: WHERE PARTY.PARTY_ID = PREL.OBJECT_ID
338: AND PREL.PARTY_ID = l_party_id
339: AND PREL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
340: AND PREL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
341: AND PREL.START_DATE < SYSDATE
342: AND NVL(PREL.END_DATE, SYSDATE+1) > SYSDATE
343: AND PREL.RELATIONSHIP_CODE in ('EMPLOYEE_OF', 'CONTACT_OF')

Line 340: AND PREL.OBJECT_TABLE_NAME = 'HZ_PARTIES'

336: FROM HZ_PARTIES PARTY, HZ_RELATIONSHIPS PREL
337: WHERE PARTY.PARTY_ID = PREL.OBJECT_ID
338: AND PREL.PARTY_ID = l_party_id
339: AND PREL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
340: AND PREL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
341: AND PREL.START_DATE < SYSDATE
342: AND NVL(PREL.END_DATE, SYSDATE+1) > SYSDATE
343: AND PREL.RELATIONSHIP_CODE in ('EMPLOYEE_OF', 'CONTACT_OF')
344: ORDER BY PREL.START_DATE;

Line 345: l_party_type HZ_PARTIES.PARTY_TYPE%TYPE;

341: AND PREL.START_DATE < SYSDATE
342: AND NVL(PREL.END_DATE, SYSDATE+1) > SYSDATE
343: AND PREL.RELATIONSHIP_CODE in ('EMPLOYEE_OF', 'CONTACT_OF')
344: ORDER BY PREL.START_DATE;
345: l_party_type HZ_PARTIES.PARTY_TYPE%TYPE;
346: i NUMBER := 1;
347: BEGIN
348: IF p_number_of_records IS NOT NULL AND p_number_of_records <> 0 THEN
349: l_rownum := p_number_of_records;