APPS.PA_EXPENDITURE_INQUIRY dependencies on PA_COST_DIST_LINES_ALL_BAS

Line 81: PA_COST_DIST_LINES_ALL_BAS cdl

77: vend.vendor_name,
78: vend.segment1,
79: cdl.burden_sum_rejection_code
80: from po_vendors vend,
81: PA_COST_DIST_LINES_ALL_BAS cdl
82: where cdl.expenditure_item_id = p_expenditure_item_id
83: and cdl.line_num (+) = 1
84: /* Added the getNumericString wrapper over systeem_reference1 for bug3158748 */
85: and pa_utils4.getNumericString(cdl.system_reference1) = vend.vendor_id (+) ;

Line 89: l_system_reference2 pa_cost_dist_lines_all_bas.system_reference2%type;

85: and pa_utils4.getNumericString(cdl.system_reference1) = vend.vendor_id (+) ;
86: /* Start: Added temp variables for bug 7283824 */
87: l_exp_id pa_expenditure_items_all.expenditure_id%type;
88: l_vendor_id po_vendors.vendor_id%type;
89: l_system_reference2 pa_cost_dist_lines_all_bas.system_reference2%type;
90: l_vendor_name po_vendors.vendor_name%type;
91: l_vendor_number po_vendors.segment1%type;
92: l_burden_sum_rej_code pa_cost_dist_lines_all_bas.burden_sum_rejection_code%type;
93: /* End: Added temp variables for bug 7283824 */

Line 92: l_burden_sum_rej_code pa_cost_dist_lines_all_bas.burden_sum_rejection_code%type;

88: l_vendor_id po_vendors.vendor_id%type;
89: l_system_reference2 pa_cost_dist_lines_all_bas.system_reference2%type;
90: l_vendor_name po_vendors.vendor_name%type;
91: l_vendor_number po_vendors.segment1%type;
92: l_burden_sum_rej_code pa_cost_dist_lines_all_bas.burden_sum_rejection_code%type;
93: /* End: Added temp variables for bug 7283824 */
94:
95: BEGIN
96: