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.AP_WEB_DB_EXPRPT_PKG dependencies on PER_PEOPLE_X

Line 36: -- Note: Instead of PER_WORKFORCE_X, PER_PEOPLE_X is used for the

32: ----------------------------------------------------------------------
33: BEGIN
34: -- Returns reports which can be modified by the web user
35: -- 3176205: hr_empcur includes all workers.
36: -- Note: Instead of PER_WORKFORCE_X, PER_PEOPLE_X is used for the
37: -- following reasons:
38: -- o Query is driven off AP_EXPENSE_REPORT_HEADERS
39: -- o Better performance using PER_PEOPLE_X
40: -- o PER_WORKFORCE_X can return more than one row for a person

Line 39: -- o Better performance using PER_PEOPLE_X

35: -- 3176205: hr_empcur includes all workers.
36: -- Note: Instead of PER_WORKFORCE_X, PER_PEOPLE_X is used for the
37: -- following reasons:
38: -- o Query is driven off AP_EXPENSE_REPORT_HEADERS
39: -- o Better performance using PER_PEOPLE_X
40: -- o PER_WORKFORCE_X can return more than one row for a person
41: -- o The only column selected from PER_PEOPLE_X is full_name
42: OPEN p_cursor FOR
43: SELECT ap_erh.REPORT_HEADER_ID,

Line 41: -- o The only column selected from PER_PEOPLE_X is full_name

37: -- following reasons:
38: -- o Query is driven off AP_EXPENSE_REPORT_HEADERS
39: -- o Better performance using PER_PEOPLE_X
40: -- o PER_WORKFORCE_X can return more than one row for a person
41: -- o The only column selected from PER_PEOPLE_X is full_name
42: OPEN p_cursor FOR
43: SELECT ap_erh.REPORT_HEADER_ID,
44: ap_erh.INVOICE_NUM,
45: hr_empcur.FULL_NAME,

Line 52: PER_PEOPLE_X hr_empcur,

48: ap_erh.DESCRIPTION,
49: ap_erh.TOTAL,
50: fndl.MEANING
51: FROM AP_EXPENSE_REPORT_HEADERS ap_erh,
52: PER_PEOPLE_X hr_empcur,
53: FND_LOOKUPS fndl
54: WHERE (ap_erh.EMPLOYEE_ID IN
55: (SELECT NUMBER_VALUE
56: FROM AK_WEB_USER_SEC_ATTR_VALUES

Line 215: -- Note: PER_PEOPLE_X would make more sense than PER_WORKFORCE_X

211: BEGIN
212: -- 3176205: This query includes all workers except for terminated
213: -- contingent workers and terminated employees who are active contingent
214: -- workers.
215: -- Note: PER_PEOPLE_X would make more sense than PER_WORKFORCE_X
216: -- but we cannot use that because default_code_combination_id
217: -- is selected.
218: -- Therefore we need to limit the query so that at most one
219: -- row will be returned.