APPS.POS_WCAPPROVE_PVT dependencies on GL_CODE_COMBINATIONS_KFV

Line 5429: l_segments GL_CODE_COMBINATIONS_KFV.concatenated_segments%type;

5425:
5426: FUNCTION GET_CHARGE_ACCOUNT (p_wc_id IN NUMBER)
5427: RETURN VARCHAR2 IS
5428: l_count number;
5429: l_segments GL_CODE_COMBINATIONS_KFV.concatenated_segments%type;
5430: begin
5431:
5432: select count(*)
5433: into l_count

Line 5434: from gl_code_combinations_kfv glc,

5430: begin
5431:
5432: select count(*)
5433: into l_count
5434: from gl_code_combinations_kfv glc,
5435: po_distributions_all pod
5436: where pod.code_combination_id = glc.code_combination_id and
5437: pod.po_distribution_id = p_wc_id;
5438:

Line 5446: from gl_code_combinations_kfv glc,

5442: else
5443:
5444: select glc.concatenated_segments
5445: into l_segments
5446: from gl_code_combinations_kfv glc,
5447: po_distributions_all pod
5448: where pod.code_combination_id = glc.code_combination_id and
5449: pod.po_distribution_id = p_wc_id;
5450: