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 1119: ap_expense_report_params erp

1115: ap_exp_report_dists dist,
1116: ap_system_parameters s,
1117: fnd_currencies_vl c,
1118: gl_sets_of_books sob,
1119: ap_expense_report_params erp
1120: WHERE c.currency_code = s.base_currency_code
1121: AND sob.set_of_books_id = s.set_of_books_id
1122: AND erp.parameter_id = p_exp_type_parameter_id
1123: AND dist.report_distribution_id = p_report_distribution_id

Line 1491: ap_expense_report_params_all erp

1487: ap_expense_report_lines_all aerl,
1488: ap_system_parameters_all s,
1489: fnd_currencies_vl c,
1490: gl_sets_of_books sob,
1491: ap_expense_report_params_all erp
1492: WHERE c.currency_code = s.base_currency_code
1493: AND sob.set_of_books_id = s.set_of_books_id
1494: AND erp.parameter_id = p_web_parameter_id
1495: AND aerh.report_header_id = aerl.report_header_id