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_MANAGEMENT_REPORTS_PKG dependencies on AP_EXPENSE_REPORT_VIOLATIONS_V

Line 429: FROM ap_expense_report_violations_v aerv

425: P_ExchangeRateType,
426: aerv.violation_amount
427: ))) as violation_amount,
428: count(aerv.report_header_id) as number_of_violations
429: FROM ap_expense_report_violations_v aerv
430: WHERE ( (aerv.employee_id = P_EmployeeId) or (aerv.paid_on_behalf_employee_id = P_EmployeeId))
431: AND aerv.week_end_date between P_StartDate and P_EndDate
432: AND nvl(aerv.category_code, 'ALL') = decode(P_ExpenseCategory, 'ALL', nvl(aerv.category_code, 'ALL'), P_ExpenseCategory)
433: AND aerv.violation_type = decode(P_ViolationType, 'ALL', aerv.violation_type, P_ViolationType)

Line 470: FROM ap_expense_report_violations_v aerv

466: P_ExchangeRateType,
467: aerv.violation_amount
468: ))) as violation_amount,
469: 1 as number_of_violations
470: FROM ap_expense_report_violations_v aerv
471: WHERE ( (aerv.employee_id = P_EmployeeId) or (aerv.paid_on_behalf_employee_id = P_EmployeeId))
472: AND ( (P_ViolationType = 'ALL') or (P_ViolationType = 'RECEIPT_MISSING')) AND aerv.violation_type = 'RECEIPT_MISSING'
473: AND nvl(aerv.category_code, 'ALL') = decode(P_ExpenseCategory, 'ALL', nvl(aerv.category_code, 'ALL'), P_ExpenseCategory)
474: AND aerv.week_end_date BETWEEN P_StartDate AND P_EndDate

Line 494: ap_expense_report_violations_v aerv

490: (
491: SELECT 1 as number_of_violations,
492: alc.displayed_field as violation_type
493: FROM ap_lookup_codes alc,
494: ap_expense_report_violations_v aerv
495: WHERE alc.lookup_type = 'OIE_POL_VIOLATION_TYPES'
496: AND alc.lookup_code = aerv.violation_type
497: AND ( aerv.employee_id = P_EmployeeId OR aerv.paid_on_behalf_employee_id = P_EmployeeId)
498: AND aerv.week_end_date between P_StartDate and P_EndDate

Line 529: ap_expense_report_violations_v aerv

525: /* Count all the violations for Receipts missing */
526: SELECT 1 as number_of_violations,
527: alc.displayed_field as violation_type
528: FROM ap_lookup_codes alc,
529: ap_expense_report_violations_v aerv
530: WHERE alc.lookup_type = 'OIE_POL_VIOLATION_TYPES'
531: AND alc.lookup_code = aerv.violation_type
532: AND ( aerv.employee_id = P_EmployeeId OR aerv.paid_on_behalf_employee_id = P_EmployeeId)
533: AND aerv.week_end_date between P_StartDate and P_EndDate

Line 1034: FROM ap_expense_report_violations_v aerv

1030: P_ExchangeRateType,
1031: aerv.allowable_amount
1032: ))) as allowable_amount,
1033: count(aerv.report_header_id) as number_of_violations
1034: FROM ap_expense_report_violations_v aerv
1035: WHERE ((aerv.employee_id = P_EmployeeId) or (aerv.paid_on_behalf_employee_id = P_EmployeeId))
1036: AND aerv.week_end_date between P_StartDate and P_EndDate
1037: AND nvl(aerv.category_code, 'ALL') = decode(P_ExpenseCategory, 'ALL', nvl(aerv.category_code, 'ALL'), P_ExpenseCategory)
1038: AND aerv.violation_type = decode(P_ViolationType, 'ALL', aerv.violation_type, P_ViolationType)

Line 1057: ap_expense_report_violations_v aerv

1053: aerv.allowable_amount
1054: ))) as allowable_amount,
1055: count(aerv.report_header_id) as number_of_violations
1056: FROM per_all_assignments_f paf,
1057: ap_expense_report_violations_v aerv
1058: WHERE paf.supervisor_id = P_EmployeeId
1059: AND paf.effective_start_date < P_EndDate
1060: AND paf.effective_end_date > P_StartDate
1061: AND (paf.assignment_type = 'E' OR paf.assignment_type = 'C')

Line 1156: FROM ap_expense_report_violations_v aerv

1152: P_ExchangeRateType,
1153: aerv.allowable_amount
1154: ))) as allowable_amount,
1155: count(aerv.report_header_id) as number_of_violations
1156: FROM ap_expense_report_violations_v aerv
1157: WHERE ((aerv.employee_id = P_EmployeeId) or (aerv.paid_on_behalf_employee_id = P_EmployeeId))
1158: AND aerv.week_end_date between P_StartDate and P_EndDate
1159: AND nvl(aerv.category_code, 'ALL') = decode(P_ExpenseCategory, 'ALL', nvl(aerv.category_code, 'ALL'), P_ExpenseCategory)
1160: AND ((P_ViolationType = 'ALL') or (P_ViolationType = 'RECEIPT_MISSING')) AND aerv.violation_type = 'RECEIPT_MISSING'

Line 1179: ap_expense_report_violations_v aerv

1175: aerv.allowable_amount
1176: ))) as allowable_amount,
1177: count(aerv.report_header_id) as number_of_violations
1178: FROM per_all_assignments_f paf,
1179: ap_expense_report_violations_v aerv
1180: WHERE paf.supervisor_id = P_EmployeeId
1181: AND paf.effective_start_date < P_EndDate
1182: AND paf.effective_end_date > P_StartDate
1183: AND (paf.assignment_type = 'E' OR paf.assignment_type = 'C')

Line 1557: FROM ap_expense_report_violations_v aerv

1553: P_ExchangeRateType,
1554: aerv.allowable_amount
1555: ))) as allowable_amount,
1556: count(aerv.report_header_id) as number_of_violations
1557: FROM ap_expense_report_violations_v aerv
1558: WHERE ((aerv.employee_id = P_EmployeeId) or (aerv.paid_on_behalf_employee_id = P_EmployeeId))
1559: AND aerv.week_end_date between P_StartDate and P_EndDate
1560: AND nvl(aerv.category_code, 'ALL') = decode(P_ExpenseCategory, 'ALL', nvl(aerv.category_code, 'ALL'), P_ExpenseCategory)
1561: AND aerv.violation_type = decode(P_ViolationType, 'ALL', aerv.violation_type, P_ViolationType)

Line 1580: ap_expense_report_violations_v aerv

1576: aerv.allowable_amount
1577: ))) as allowable_amount,
1578: count(aerv.report_header_id) as number_of_violations
1579: FROM per_all_assignments_f paf,
1580: ap_expense_report_violations_v aerv
1581: WHERE paf.supervisor_id = P_EmployeeId
1582: AND paf.effective_start_date < P_EndDate
1583: AND paf.effective_end_date > P_StartDate
1584: AND (paf.assignment_type = 'E' OR paf.assignment_type = 'C')

Line 1679: FROM ap_expense_report_violations_v aerv

1675: P_ExchangeRateType,
1676: aerv.allowable_amount
1677: ))) as allowable_amount,
1678: count(aerv.report_header_id) as number_of_violations
1679: FROM ap_expense_report_violations_v aerv
1680: WHERE ((aerv.employee_id = P_EmployeeId) or (aerv.paid_on_behalf_employee_id = P_EmployeeId))
1681: AND aerv.week_end_date between P_StartDate and P_EndDate
1682: AND nvl(aerv.category_code, 'ALL') = decode(P_ExpenseCategory, 'ALL', nvl(aerv.category_code, 'ALL'), P_ExpenseCategory)
1683: AND ((P_ViolationType = 'ALL') or (P_ViolationType = 'RECEIPT_MISSING')) AND aerv.violation_type = 'RECEIPT_MISSING'

Line 1702: ap_expense_report_violations_v aerv

1698: aerv.allowable_amount
1699: ))) as allowable_amount,
1700: count(aerv.report_header_id) as number_of_violations
1701: FROM per_all_assignments_f paf,
1702: ap_expense_report_violations_v aerv
1703: WHERE paf.supervisor_id = P_EmployeeId
1704: AND paf.effective_start_date < P_EndDate
1705: AND paf.effective_end_date > P_StartDate
1706: AND (paf.assignment_type = 'E' OR paf.assignment_type = 'C')