APPS.PO_EDA_DATATEMPLATE_PKG dependencies on PO_EDA_MAPPING

Line 1051: SELECT NVL((select eda from po_eda_mapping where GROUPING = 'LOA' and attribute = 'ComponentTitle' and

1047: OR modi.ACRN <> base.ACRN
1048: OR modi.AMOUNT_FUNDED <> base.AMOUNT_FUNDED);
1049:
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

Line 2002: l_sql := 'SELECT EDA FROM PO_EDA_MAPPING WHERE Grouping = ''Common'' AND ATTRIBUTE=''TimeZone'' AND EBS = '''|| l_date ||'''';

1998: EXCEPTION WHEN OTHERS THEN
1999: NULL;
2000: END;
2001:
2002: l_sql := 'SELECT EDA FROM PO_EDA_MAPPING WHERE Grouping = ''Common'' AND ATTRIBUTE=''TimeZone'' AND EBS = '''|| l_date ||'''';
2003: OPEN c_zone FOR l_sql;
2004: FETCH c_zone INTO l_res;
2005: IF l_res IS NULL THEN
2006: l_res := 'Non-US Local Time';