APPS.AP_WEB_MANAGEMENT_REPORTS_PKG dependencies on AP_LOOKUP_CODES

Line 320: most_violated_policy ap_lookup_codes.DISPLAYED_FIELD%TYPE,

316: violation_line_amount NUMBER,
317: violation_amount NUMBER,
318: percent_violation NUMBER,
319: number_of_violations NUMBER,
320: most_violated_policy ap_lookup_codes.DISPLAYED_FIELD%TYPE,
321: supervisor_id per_workforce_x.SUPERVISOR_ID%TYPE,
322: effective_start_date DATE, -- 4319234 the two date columns are added to the record
323: effective_end_date DATE
324: );

Line 493: FROM ap_lookup_codes alc,

489: from
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)

Line 507: ap_lookup_codes alc

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)
511: AND aerh.source <> 'Both Pay'

Line 528: FROM ap_lookup_codes alc,

524: UNION ALL
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)

Line 864: expense_category ap_lookup_codes.LOOKUP_CODE%TYPE,

860: allowable_amount NUMBER,
861: percent_violation NUMBER,
862: percent_allowable NUMBER,
863: number_of_violations NUMBER,
864: expense_category ap_lookup_codes.LOOKUP_CODE%TYPE,
865: expense_category_desc ap_lookup_codes.DISPLAYED_FIELD%TYPE
866: );
867:
868:

Line 865: expense_category_desc ap_lookup_codes.DISPLAYED_FIELD%TYPE

861: percent_violation NUMBER,
862: percent_allowable NUMBER,
863: number_of_violations NUMBER,
864: expense_category ap_lookup_codes.LOOKUP_CODE%TYPE,
865: expense_category_desc ap_lookup_codes.DISPLAYED_FIELD%TYPE
866: );
867:
868:
869: TYPE ByExpenseCategoryTabType IS TABLE OF ByExpenseCategoryRecType

Line 879: L_ExpenseCategory ap_lookup_codes.LOOKUP_CODE%TYPE;

875: L_TabIndex BINARY_INTEGER := 0;
876: L_EmployeeId ap_expense_report_headers.EMPLOYEE_ID%TYPE;
877: L_BaseCurrencyCode ap_system_parameters.BASE_CURRENCY_CODE%TYPE;
878: L_ExchangeRateType ap_system_parameters.DEFAULT_EXCHANGE_RATE_TYPE%TYPE;
879: L_ExpenseCategory ap_lookup_codes.LOOKUP_CODE%TYPE;
880: L_ExpenseAmount NUMBER := 0;
881: L_ViolationLineAmount NUMBER;
882: L_ViolationAmount NUMBER;
883: L_AllowableAmount NUMBER;

Line 900: FROM ap_lookup_codes

896: --
897: CURSOR C_ExpenseCategories ( P_ExpenseCategory VARCHAR2 )IS
898: SELECT lookup_code,
899: displayed_field
900: FROM ap_lookup_codes
901: WHERE lookup_type = 'OIE_EXPENSE_CATEGORY'
902: AND lookup_code = decode (P_ExpenseCategory, 'ALL', lookup_code, P_ExpenseCategory);
903:
904: --

Line 1431: violation_type ap_lookup_codes.LOOKUP_CODE%TYPE,

1427: allowable_amount NUMBER,
1428: percent_violation NUMBER,
1429: percent_allowable NUMBER,
1430: number_of_violations NUMBER,
1431: violation_type ap_lookup_codes.LOOKUP_CODE%TYPE,
1432: violation_type_desc ap_lookup_codes.DISPLAYED_FIELD%TYPE
1433: );
1434:
1435:

Line 1432: violation_type_desc ap_lookup_codes.DISPLAYED_FIELD%TYPE

1428: percent_violation NUMBER,
1429: percent_allowable NUMBER,
1430: number_of_violations NUMBER,
1431: violation_type ap_lookup_codes.LOOKUP_CODE%TYPE,
1432: violation_type_desc ap_lookup_codes.DISPLAYED_FIELD%TYPE
1433: );
1434:
1435:
1436: TYPE ByViolationTypeTabType IS TABLE OF ByViolationTypeRecType

Line 1446: L_ViolationType ap_lookup_codes.LOOKUP_CODE%TYPE;

1442: L_TabIndex BINARY_INTEGER := 0;
1443: L_EmployeeId ap_expense_report_headers.EMPLOYEE_ID%TYPE;
1444: L_BaseCurrencyCode ap_system_parameters.BASE_CURRENCY_CODE%TYPE;
1445: L_ExchangeRateType ap_system_parameters.DEFAULT_EXCHANGE_RATE_TYPE%TYPE;
1446: L_ViolationType ap_lookup_codes.LOOKUP_CODE%TYPE;
1447: L_ViolationLineAmount NUMBER;
1448: L_ViolationAmount NUMBER;
1449: L_AllowableAmount NUMBER;
1450: L_Convert BOOLEAN := FALSE;

Line 1466: FROM ap_lookup_codes

1462: --
1463: CURSOR C_ViolationTypes ( P_ViolationType VARCHAR2 )IS
1464: SELECT lookup_code,
1465: displayed_field
1466: FROM ap_lookup_codes
1467: WHERE lookup_type = 'OIE_POL_VIOLATION_TYPES'
1468: AND lookup_code = decode (P_ViolationType, 'ALL', lookup_code, P_ViolationType);
1469:
1470: --