APPS.POR_APPRV_WF_UTIL_GRP dependencies on FND_ID_FLEX_SEGMENTS

Line 79: l_segment_num fnd_id_flex_segments.segment_num%TYPE;

75: CHANGE HISTORY: 17-SEP-2003 sbgeorge Created
76: ===========================================================================*/
77: FUNCTION get_cost_center(p_req_line_id IN NUMBER) RETURN VARCHAR2
78: IS
79: l_segment_num fnd_id_flex_segments.segment_num%TYPE;
80: l_cost_center VARCHAR2(200);
81: l_account_id gl_sets_of_books.chart_of_accounts_id%TYPE;
82: cost_center_1 VARCHAR2(200);
83: cc_Id po_req_distributions_all.code_combination_id%TYPE;

Line 99: FROM FND_ID_FLEX_SEGMENTS fs,

95:
96: BEGIN
97: SELECT fs.segment_num, gls.chart_of_accounts_id
98: INTO l_segment_num, l_account_id
99: FROM FND_ID_FLEX_SEGMENTS fs,
100: fnd_segment_attribute_values fsav,
101: financials_system_params_all fsp,
102: gl_sets_of_books gls,
103: po_requisition_lines_all prl