APPS.AP_WEB_MANAGEMENT_REPORTS_PKG dependencies on AP_EXPENSE_REPORT_LINES_V

Line 380: FROM ap_expense_report_lines_v aerl

376: sysdate,
377: P_ExchangeRateType,
378: aerl.amount
379: ))) as expense_amount
380: FROM ap_expense_report_lines_v aerl
381: WHERE aerl.employee_id = P_EmployeeId
382: AND aerl.week_end_date between P_StartDate and P_EndDate
383: AND nvl(aerl.category_code, 'ALL') = decode(P_ExpenseCategory, 'ALL', nvl(aerl.category_code, 'ALL'), P_ExpenseCategory);
384:

Line 406: FROM ap_expense_report_lines_v aerl

402: sysdate,
403: P_ExchangeRateType,
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

Line 941: FROM ap_expense_report_lines_v aerl

937: sysdate,
938: P_ExchangeRateType,
939: aerl.amount
940: )) as expense_amount
941: FROM ap_expense_report_lines_v aerl
942: WHERE ((aerl.employee_id= P_EmployeeId) or (aerl.paid_on_behalf_employee_id = P_EmployeeId))
943: AND aerl.week_end_date BETWEEN P_StartDate AND P_EndDate
944: AND nvl(aerl.category_code, 'ALL') = decode (P_ExpenseCategory, 'ALL', nvl(aerl.category_code, 'ALL'), P_ExpenseCategory)
945: UNION ALL

Line 954: ap_expense_report_lines_v aerl

950: P_ExchangeRateType,
951: aerl.amount
952: )) as expense_amount
953: FROM per_all_assignments_f paf,
954: ap_expense_report_lines_v aerl
955: WHERE paf.supervisor_id = P_EmployeeId
956: AND paf.effective_start_date < P_EndDate
957: AND paf.effective_end_date > P_StartDate
958: AND (paf.assignment_type = 'E' OR paf.assignment_type = 'C')

Line 986: FROM ap_expense_report_lines_v aerl

982: sysdate,
983: P_ExchangeRateType,
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

Line 1003: FROM ap_expense_report_lines_v aerl,

999: sysdate,
1000: P_ExchangeRateType,
1001: aerl.amount
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

Line 1512: FROM ap_expense_report_lines_v aerl

1508: sysdate,
1509: P_ExchangeRateType,
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

Line 1529: FROM ap_expense_report_lines_v aerl,

1525: sysdate,
1526: P_ExchangeRateType,
1527: aerl.amount
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