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_POL_VIOLATIONS_ALL

Line 397: FROM ap_pol_violations_all apv

393: aerl.amount
394: )) as line_amount
395: FROM ap_expense_report_lines_v aerl
396: WHERE EXISTS ( SELECT 'X'
397: FROM ap_pol_violations_all apv
398: WHERE apv.report_header_id = aerl.report_header_id
399: AND apv.distribution_line_number = aerl.distribution_line_number
400: AND apv.violation_type = decode(P_ViolationType, 'ALL', apv.violation_type, P_ViolationType) )
401: AND ( aerl.employee_id= P_EmployeeId or aerl.paid_on_behalf_employee_id = P_EmployeeId )

Line 446: ap_pol_violations_all apv

442: apv.exceeded_amount
443: )) as violation_amount,
444: 1 as number_of_violations
445: FROM ap_expense_report_headers_all aerh,
446: ap_pol_violations_all apv
447: WHERE aerh.report_header_id = apv.report_header_id
448: AND apv.distribution_line_number = -1
449: AND (aerh.source <> 'NonValidatedWebExpense' OR aerh.workflow_approved_flag IS NULL)
450: AND aerh.source <> 'Both Pay'

Line 506: ap_pol_violations_all apv,

502: /* Count all the violations for Daily Sum Limit */
503: SELECT 1 as number_of_violations,
504: alc.displayed_field as violation_type
505: FROM ap_expense_report_headers_all aerh,
506: ap_pol_violations_all apv,
507: ap_lookup_codes alc
508: WHERE aerh.report_header_id = apv.report_header_id
509: AND apv.distribution_line_number = -1
510: AND (aerh.source <> 'NonValidatedWebExpense' OR aerh.workflow_approved_flag IS NULL)

Line 971: FROM ap_pol_violations_all apv

967: aerl.amount
968: )) as line_amount
969: FROM ap_expense_report_lines_v aerl
970: WHERE EXISTS ( SELECT 'X'
971: FROM ap_pol_violations_all apv
972: WHERE apv.report_header_id = aerl.report_header_id
973: AND apv.distribution_line_number = aerl.distribution_line_number
974: AND apv.violation_type = decode(P_ViolationType, 'ALL', apv.violation_type, P_ViolationType) )
975: AND ((aerl.employee_id= P_EmployeeId) or (aerl.paid_on_behalf_employee_id = P_EmployeeId))

Line 989: FROM ap_pol_violations_all apv

985: )) as line_amount
986: FROM ap_expense_report_lines_v aerl,
987: per_all_assignments_f paf
988: WHERE EXISTS ( SELECT 'X'
989: FROM ap_pol_violations_all apv
990: WHERE apv.report_header_id = aerl.report_header_id
991: AND apv.distribution_line_number = aerl.distribution_line_number
992: AND apv.violation_type = decode(P_ViolationType, 'ALL', apv.violation_type, P_ViolationType) )
993: AND paf.supervisor_id = P_EmployeeId

Line 1086: ap_pol_violations_all apv

1082: apv.allowable_amount
1083: )) as allowable_amount,
1084: 1 as number_of_violations
1085: FROM ap_expense_report_headers_all aerh,
1086: ap_pol_violations_all apv
1087: WHERE aerh.report_header_id = apv.report_header_id
1088: AND aerh.org_id = apv.org_id
1089: AND apv.distribution_line_number = -1
1090: AND (aerh.source <> 'NonValidatedWebExpense' OR aerh.workflow_approved_flag IS NULL)

Line 1118: ap_pol_violations_all apv,

1114: apv.allowable_amount
1115: )) as allowable_amount,
1116: 1 as number_of_violations
1117: FROM ap_expense_report_headers_all aerh,
1118: ap_pol_violations_all apv,
1119: per_all_assignments_f paf
1120: WHERE aerh.report_header_id = apv.report_header_id
1121: AND aerh.org_id = apv.org_id
1122: AND apv.distribution_line_number = -1

Line 1493: FROM ap_pol_violations_all apv

1489: aerl.amount
1490: )) as line_amount
1491: FROM ap_expense_report_lines_v aerl
1492: WHERE EXISTS ( SELECT 'X'
1493: FROM ap_pol_violations_all apv
1494: WHERE apv.report_header_id = aerl.report_header_id
1495: AND apv.distribution_line_number = aerl.distribution_line_number
1496: AND apv.violation_type = decode(P_ViolationType, 'ALL', apv.violation_type, P_ViolationType))
1497: AND ((aerl.employee_id= P_EmployeeId) or (aerl.paid_on_behalf_employee_id = P_EmployeeId))

Line 1511: FROM ap_pol_violations_all apv

1507: )) as line_amount
1508: FROM ap_expense_report_lines_v aerl,
1509: per_all_assignments_f paf
1510: WHERE EXISTS ( SELECT 'X'
1511: FROM ap_pol_violations_all apv
1512: WHERE apv.report_header_id = aerl.report_header_id
1513: AND apv.distribution_line_number = aerl.distribution_line_number
1514: AND apv.violation_type = decode(P_ViolationType, 'ALL', apv.violation_type, P_ViolationType) )
1515: AND paf.supervisor_id = P_EmployeeId

Line 1609: ap_pol_violations_all apv

1605: apv.allowable_amount
1606: )) as allowable_amount,
1607: 1 as number_of_violations
1608: FROM ap_expense_report_headers_all aerh,
1609: ap_pol_violations_all apv
1610: WHERE aerh.report_header_id = apv.report_header_id
1611: AND aerh.org_id = apv.org_id
1612: AND apv.distribution_line_number = -1
1613: AND (aerh.source <> 'NonValidatedWebExpense' OR aerh.workflow_approved_flag IS NULL)

Line 1641: ap_pol_violations_all apv,

1637: apv.allowable_amount
1638: )) as allowable_amount,
1639: 1 as number_of_violations
1640: FROM ap_expense_report_headers_all aerh,
1641: ap_pol_violations_all apv,
1642: per_all_assignments_f paf
1643: WHERE aerh.report_header_id = apv.report_header_id
1644: AND aerh.org_id = apv.org_id
1645: AND apv.distribution_line_number = -1