DBA Data[Home] [Help]

APPS.JA_CN_FSG_XML_BANK_PKG dependencies on FND_ID_FLEX_SEGMENTS_VL

Line 732: from FND_ID_FLEX_SEGMENTS_VL

728: Function Get_FSG_Override(P_LEDGER_ID PLS_INTEGER,P_REPORT_ID PLS_INTEGER,P_BSV VARCHAR2) RETURN VARCHAR2
729: IS
730: CURSOR cur_segments is
731: select application_column_name, default_value
732: from FND_ID_FLEX_SEGMENTS_VL
733: where id_flex_code = 'GL#'
734: and id_flex_num = (select chart_of_accounts_id
735: from gl_ledgers
736: where ledger_id =P_LEDGER_ID);

Line 758: FROM FND_ID_FLEX_SEGMENTS_VL fs, fnd_segment_attribute_values av

754: where rp.report_id = P_REPORT_ID;
755:
756: SELECT fs.application_column_name
757: into l_bsv_segment
758: FROM FND_ID_FLEX_SEGMENTS_VL fs, fnd_segment_attribute_values av
759: WHERE fs.application_column_name = av.application_column_name
760: AND av.id_flex_code = 'GL#'
761: AND fs.id_flex_code = av.id_flex_code
762: AND av.id_flex_num = l_coa_id