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 408: FROM ap_pol_violations_all apv

404: aerl.amount
405: )) as line_amount
406: FROM ap_expense_report_lines_v aerl
407: WHERE EXISTS ( SELECT 'X'
408: FROM ap_pol_violations_all apv
409: WHERE apv.report_header_id = aerl.report_header_id
410: AND apv.distribution_line_number = aerl.distribution_line_number
411: AND apv.violation_type = decode(P_ViolationType, 'ALL', apv.violation_type, P_ViolationType) )
412: AND ( aerl.employee_id= P_EmployeeId or aerl.paid_on_behalf_employee_id = P_EmployeeId )

Line 457: ap_pol_violations_all apv

453: apv.exceeded_amount
454: )) as violation_amount,
455: 1 as number_of_violations
456: FROM ap_expense_report_headers_all aerh,
457: ap_pol_violations_all apv
458: WHERE aerh.report_header_id = apv.report_header_id
459: AND apv.distribution_line_number = -1
460: AND (aerh.source <> 'NonValidatedWebExpense' OR aerh.workflow_approved_flag IS NULL)
461: AND aerh.source <> 'Both Pay'

Line 519: ap_pol_violations_all apv,

515: /* Count all the violations for Daily Sum Limit */
516: SELECT 1 as number_of_violations,
517: alc.displayed_field as violation_type
518: FROM ap_expense_report_headers_all aerh,
519: ap_pol_violations_all apv,
520: ap_lookup_codes alc
521: WHERE aerh.report_header_id = apv.report_header_id
522: AND apv.distribution_line_number = -1
523: AND (aerh.source <> 'NonValidatedWebExpense' OR aerh.workflow_approved_flag IS NULL)

Line 988: FROM ap_pol_violations_all apv

984: aerl.amount
985: )) as line_amount
986: FROM ap_expense_report_lines_v aerl
987: WHERE EXISTS ( SELECT 'X'
988: FROM ap_pol_violations_all apv
989: WHERE apv.report_header_id = aerl.report_header_id
990: AND apv.distribution_line_number = aerl.distribution_line_number
991: AND apv.violation_type = decode(P_ViolationType, 'ALL', apv.violation_type, P_ViolationType) )
992: AND ((aerl.employee_id= P_EmployeeId) or (aerl.paid_on_behalf_employee_id = P_EmployeeId))

Line 1006: FROM ap_pol_violations_all apv

1002: )) as line_amount
1003: FROM ap_expense_report_lines_v aerl,
1004: per_all_assignments_f paf
1005: WHERE EXISTS ( SELECT 'X'
1006: FROM ap_pol_violations_all apv
1007: WHERE apv.report_header_id = aerl.report_header_id
1008: AND apv.distribution_line_number = aerl.distribution_line_number
1009: AND apv.violation_type = decode(P_ViolationType, 'ALL', apv.violation_type, P_ViolationType) )
1010: AND paf.supervisor_id = P_EmployeeId

Line 1103: ap_pol_violations_all apv

1099: apv.allowable_amount
1100: )) as allowable_amount,
1101: 1 as number_of_violations
1102: FROM ap_expense_report_headers_all aerh,
1103: ap_pol_violations_all apv
1104: WHERE aerh.report_header_id = apv.report_header_id
1105: AND aerh.org_id = apv.org_id
1106: AND apv.distribution_line_number = -1
1107: AND (aerh.source <> 'NonValidatedWebExpense' OR aerh.workflow_approved_flag IS NULL)

Line 1137: ap_pol_violations_all apv,

1133: apv.allowable_amount
1134: )) as allowable_amount,
1135: 1 as number_of_violations
1136: FROM ap_expense_report_headers_all aerh,
1137: ap_pol_violations_all apv,
1138: per_all_assignments_f paf
1139: WHERE aerh.report_header_id = apv.report_header_id
1140: AND aerh.org_id = apv.org_id
1141: AND apv.distribution_line_number = -1

Line 1514: FROM ap_pol_violations_all apv

1510: aerl.amount
1511: )) as line_amount
1512: FROM ap_expense_report_lines_v aerl
1513: WHERE EXISTS ( SELECT 'X'
1514: FROM ap_pol_violations_all apv
1515: WHERE apv.report_header_id = aerl.report_header_id
1516: AND apv.distribution_line_number = aerl.distribution_line_number
1517: AND apv.violation_type = decode(P_ViolationType, 'ALL', apv.violation_type, P_ViolationType))
1518: AND ((aerl.employee_id= P_EmployeeId) or (aerl.paid_on_behalf_employee_id = P_EmployeeId))

Line 1532: FROM ap_pol_violations_all apv

1528: )) as line_amount
1529: FROM ap_expense_report_lines_v aerl,
1530: per_all_assignments_f paf
1531: WHERE EXISTS ( SELECT 'X'
1532: FROM ap_pol_violations_all apv
1533: WHERE apv.report_header_id = aerl.report_header_id
1534: AND apv.distribution_line_number = aerl.distribution_line_number
1535: AND apv.violation_type = decode(P_ViolationType, 'ALL', apv.violation_type, P_ViolationType) )
1536: AND paf.supervisor_id = P_EmployeeId

Line 1630: ap_pol_violations_all apv

1626: apv.allowable_amount
1627: )) as allowable_amount,
1628: 1 as number_of_violations
1629: FROM ap_expense_report_headers_all aerh,
1630: ap_pol_violations_all apv
1631: WHERE aerh.report_header_id = apv.report_header_id
1632: AND aerh.org_id = apv.org_id
1633: AND apv.distribution_line_number = -1
1634: AND (aerh.source <> 'NonValidatedWebExpense' OR aerh.workflow_approved_flag IS NULL)

Line 1664: ap_pol_violations_all apv,

1660: apv.allowable_amount
1661: )) as allowable_amount,
1662: 1 as number_of_violations
1663: FROM ap_expense_report_headers_all aerh,
1664: ap_pol_violations_all apv,
1665: per_all_assignments_f paf
1666: WHERE aerh.report_header_id = apv.report_header_id
1667: AND aerh.org_id = apv.org_id
1668: AND apv.distribution_line_number = -1