3349:
3350:
3351: CURSOR cur_get_account_segment (cn_coa_id NUMBER)IS
3352: SELECT APPLICATION_COLUMN_NAME SEGMENT_NAME
3353: FROM FND_ID_FLEX_SEGMENTS
3354: WHERE ID_FLEX_CODE ='GL#'
3355: AND ID_FLEX_NUM = cn_coa_id
3356: AND FLEX_VALUE_SET_ID = (SELECT FLEX_VALUE_SET_ID
3357: FROM FND_ID_FLEX_SEGMENTS SEG , FND_SEGMENT_ATTRIBUTE_VALUES AT
3353: FROM FND_ID_FLEX_SEGMENTS
3354: WHERE ID_FLEX_CODE ='GL#'
3355: AND ID_FLEX_NUM = cn_coa_id
3356: AND FLEX_VALUE_SET_ID = (SELECT FLEX_VALUE_SET_ID
3357: FROM FND_ID_FLEX_SEGMENTS SEG , FND_SEGMENT_ATTRIBUTE_VALUES AT
3358: WHERE SEG.APPLICATION_ID = 101
3359: AND SEG.ID_FLEX_CODE = 'GL#'
3360: AND SEG.ID_FLEX_NUM = cn_coa_id
3361: AND AT.APPLICATION_ID = SEG.APPLICATION_ID
3368: -----------------------------------------------------------------
3369: --Variables Declare
3370: -----------------------------------------------------------------
3371: ln_coa_id NUMBER;
3372: lv_segment_name FND_ID_FLEX_SEGMENTS.APPLICATION_COLUMN_NAME%TYPE;
3373: lv_dynamic_sql VARCHAR2(240);
3374: lv_natual_account_segment JAI_DTC_SCTN_ACCOUNT_MAPPING.NATURAL_ACCOUNT_VALUE%TYPE ;
3375: ln_dist_ccid NUMBER;
3376: ln_invoice_id NUMBER;