APPS.PO_EDA_DATATEMPLATE_PKG dependencies on GL_CODE_COMBINATIONS

Line 1054: FROM fnd_id_flex_segments_vl flv, gl_code_combinations glc, po_distributions_merge_v pda

1050: CURSOR c_obligatedAmountcomponents(p_dist_id number,p_draft_id NUMBER) IS
1051: SELECT NVL((select eda from po_eda_mapping where GROUPING = 'LOA' and attribute = 'ComponentTitle' and
1052: ebs = flv.SEGMENT_NAME),flv.SEGMENT_NAME) ComponentTitle,
1053: PO_EDA_DATATEMPLATE_PKG.get_charge_acc_comp_val(flv.APPLICATION_COLUMN_NAME,pda.CODE_COMBINATION_ID) ComponentValue
1054: FROM fnd_id_flex_segments_vl flv, gl_code_combinations glc, po_distributions_merge_v pda
1055: WHERE po_distribution_id = p_dist_id and draft_id = p_draft_id
1056: AND glc.CODE_COMBINATION_ID = pda.CODE_COMBINATION_ID
1057: AND flv.ID_FLEX_CODE = 'GL#' AND flv.ID_FLEX_NUM = glc.CHART_OF_ACCOUNTS_ID ;
1058:

Line 2677: l_sql := 'SELECT '|| p_col_name ||' FROM gl_code_combinations glc WHERE glc.CODE_COMBINATION_ID = ' || p_code_comb_id;

2673: FUNCTION get_charge_acc_comp_val(p_col_name VARCHAR2, p_code_comb_id NUMBER) RETURN VARCHAR2 AS
2674: l_output VARCHAR2(1000);
2675: l_sql VARCHAR2(1000);
2676: BEGIN
2677: l_sql := 'SELECT '|| p_col_name ||' FROM gl_code_combinations glc WHERE glc.CODE_COMBINATION_ID = ' || p_code_comb_id;
2678: execute immediate l_sql into l_output;
2679: RETURN(l_output);
2680: END get_charge_acc_comp_val;
2681: