APPS.PAY_NL_NWR_XML_EXTRACT_PKG dependencies on FND_DESCR_FLEX_COL_USAGE_VL

Line 360: FROM fnd_descr_flex_col_usage_vl

356: ,p_application_column_name VARCHAR2) RETURN BOOLEAN AS
357: --
358: CURSOR csr_seg_enabled IS
359: SELECT 'Y'
360: FROM fnd_descr_flex_col_usage_vl
361: WHERE application_id = 801
362: AND descriptive_flexfield_name LIKE 'Action Information DF'
363: AND descriptive_flex_context_code = p_context_code
364: AND application_column_name LIKE p_application_column_name

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

445: ,p_report_type VARCHAR2) AS
446: --
447: BEGIN
448: --
449: build_sql(sqlstr, l_cntr_sql, 'DECLARE l_col_tag fnd_descr_flex_col_usage_vl.description%TYPE; BEGIN ');
450:
451: --
452: 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 ');
453: --

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

798: build_sql(sqlstr, l_cntr_sql, 'pay_nl_nwr_xml_extract_pkg.load_xml(''CE'', NULL, ''SectorRisicogroep'', NULL);');
799: --
800: build_sql(sqlstr, l_cntr_sql, 'END LOOP;');
801: --
802: build_sql(sqlstr, l_cntr_sql, 'DECLARE l_tag fnd_descr_flex_col_usage_vl.description%TYPE; BEGIN ');
803: --
804: -- Nominative Report
805: --build_sql(sqlstr, l_cntr_sql, 'pay_nl_nwr_xml_extract_pkg.load_xml(''CS'', NULL, ''NominatieveAangifte'', NULL);');
806: --