DBA Data[Home] [Help]

APPS.POR_APPRV_WF_UTIL_GRP dependencies on GL_SETS_OF_BOOKS

Line 82: l_account_id gl_sets_of_books.chart_of_accounts_id%TYPE;

78: FUNCTION get_cost_center(p_req_line_id IN NUMBER) RETURN VARCHAR2
79: IS
80: l_segment_num fnd_id_flex_segments.segment_num%TYPE;
81: l_cost_center VARCHAR2(200);
82: l_account_id gl_sets_of_books.chart_of_accounts_id%TYPE;
83: cost_center_1 VARCHAR2(200);
84: cc_Id po_req_distributions_all.code_combination_id%TYPE;
85: l_segments fnd_flex_ext.SegmentArray;
86: nsegments NUMBER;

Line 103: gl_sets_of_books gls,

99: INTO l_segment_num, l_account_id
100: FROM FND_ID_FLEX_SEGMENTS fs,
101: fnd_segment_attribute_values fsav,
102: financials_system_params_all fsp,
103: gl_sets_of_books gls,
104: po_requisition_lines_all prl
105: WHERE prl.requisition_line_id = p_req_line_id AND
106: --added NVL check for single org, bug#6705513
107: NVL(prl.org_id,-99) = NVL(fsp.org_id,-99) AND