APPS.AP_WEB_ACCTG_PKG dependencies on AP_EXPENSE_REPORT_PARAMS

Line 412: l_FlexConcactenated AP_EXPENSE_REPORT_PARAMS.flex_concactenated%TYPE;

408: l_flex_segment_delimiter varchar2(1);
409: l_cost_center_seg_num number;
410: l_num_segments number;
411: l_exp_type_template_array FND_FLEX_EXT.SEGMENTARRAY;
412: l_FlexConcactenated AP_EXPENSE_REPORT_PARAMS.flex_concactenated%TYPE;
413:
414: BEGIN
415:
416: -----------------------------------------------------

Line 452: FROM ap_expense_report_params_all

448: -----------------------------------------------------
449: l_debug_info := 'Get FLEX_CONCACTENATED';
450: -----------------------------------------------------
451: SELECT FLEX_CONCACTENATED into l_FlexConcactenated
452: FROM ap_expense_report_params_all
453: WHERE parameter_id = p_exp_type_parameter_id;
454: exception
455: when others then
456: return;

Line 775: l_FlexConcactenated AP_EXPENSE_REPORT_PARAMS.FLEX_CONCACTENATED%TYPE;

771: l_chart_of_accounts_id NUMBER;
772: l_cost_center_seg_num NUMBER;
773: l_flex_segment_delimiter VARCHAR2(1);
774: l_default_emp_segments FND_FLEX_EXT.SEGMENTARRAY;
775: l_FlexConcactenated AP_EXPENSE_REPORT_PARAMS.FLEX_CONCACTENATED%TYPE;
776: l_exp_type_template_array FND_FLEX_EXT.SEGMENTARRAY;
777: l_exp_line_acct_segs_array FND_FLEX_EXT.SEGMENTARRAY;
778: l_num_segments NUMBER:=NULL;
779: l_concatenated_segments varchar2(2000);

Line 1124: ap_expense_report_params erp

1120: ap_exp_report_dists dist,
1121: ap_system_parameters s,
1122: fnd_currencies_vl c,
1123: gl_sets_of_books sob,
1124: ap_expense_report_params erp
1125: WHERE c.currency_code = s.base_currency_code
1126: AND sob.set_of_books_id = s.set_of_books_id
1127: AND erp.parameter_id = p_exp_type_parameter_id
1128: AND dist.report_distribution_id = p_report_distribution_id

Line 1498: ap_expense_report_params_all erp

1494: ap_expense_report_lines_all aerl,
1495: ap_system_parameters_all s,
1496: fnd_currencies_vl c,
1497: gl_sets_of_books sob,
1498: ap_expense_report_params_all erp
1499: WHERE c.currency_code = s.base_currency_code
1500: AND sob.set_of_books_id = s.set_of_books_id
1501: AND erp.parameter_id = p_web_parameter_id
1502: AND aerh.report_header_id = aerl.report_header_id