APPS.PAY_NL_NWR_XML_EXTRACT_PKG dependencies on FND_DESCR_FLEX_COL_USAGE_VL

Line 306: FROM fnd_descr_flex_col_usage_vl

302: ,p_application_column_name VARCHAR2) RETURN BOOLEAN AS
303: --
304: CURSOR csr_seg_enabled IS
305: SELECT 'Y'
306: FROM fnd_descr_flex_col_usage_vl
307: WHERE application_id = 801
308: AND descriptive_flexfield_name LIKE 'Action Information DF'
309: AND descriptive_flex_context_code = p_context_code
310: AND application_column_name LIKE p_application_column_name

Line 395: build_sql(sqlstr, l_cntr_sql, 'DECLARE l_col_tag fnd_descr_flex_col_usage_vl.description%TYPE; BEGIN ');

391: ,p_report_type VARCHAR2) AS
392: --
393: BEGIN
394: --
395: build_sql(sqlstr, l_cntr_sql, 'DECLARE l_col_tag fnd_descr_flex_col_usage_vl.description%TYPE; BEGIN ');
396:
397: --
398: build_sql(sqlstr, l_cntr_sql, 'FOR csr_collective_info_rec IN pay_nl_nwr_xml_extract_pkg.csr_collective_info ('||p_act_context_id||',''NL_WR_COLLECTIVE_REPORT'','''|| p_type ||''','||p_start_date||','||p_end_date||') LOOP ');
399: --

Line 541: build_sql(sqlstr, l_cntr_sql, 'DECLARE l_tag fnd_descr_flex_col_usage_vl.description%TYPE; BEGIN ');

537: build_sql(sqlstr, l_cntr_sql, 'pay_nl_nwr_xml_extract_pkg.load_xml(''CE'', NULL, ''SectorRisicogroep'', NULL);');
538: --
539: build_sql(sqlstr, l_cntr_sql, 'END LOOP;');
540: --
541: build_sql(sqlstr, l_cntr_sql, 'DECLARE l_tag fnd_descr_flex_col_usage_vl.description%TYPE; BEGIN ');
542: --
543: -- Nominative Report
544: --build_sql(sqlstr, l_cntr_sql, 'pay_nl_nwr_xml_extract_pkg.load_xml(''CS'', NULL, ''NominatieveAangifte'', NULL);');
545: --