APPS.PO_EDA_DATATEMPLATE_PKG dependencies on PON_FORMS_SECTIONS

Line 2626: (SELECT FORM_ID FROM PON_FORMS_SECTIONS WHERE FORM_CODE = 'FED_PRESOL' AND STATUS = 'ACTIVE')

2622: INTO l_col_name
2623: FROM pon_form_section_compiled
2624:
2625: WHERE form_id =
2626: (SELECT FORM_ID FROM PON_FORMS_SECTIONS WHERE FORM_CODE = 'FED_PRESOL' AND STATUS = 'ACTIVE')
2627: AND field_code = 'FED_DESC';
2628:
2629: l_sql_query :='SELECT '|| l_col_name ||
2630: ' FROM pon_form_field_values WHERE OWNING_ENTITY_CODE = ''PON_AUCTION_HEADERS_ALL'' AND ENTITY_PK1 IN (SELECT DISTINCT AUCTION_HEADER_ID FROM po_lines_merge_v WHERE po_header_id = '

Line 2632: DRAFTID ||') AND FORM_ID = (SELECT FORM_ID FROM PON_FORMS_SECTIONS WHERE FORM_CODE = ''FED_PRESOL'' AND STATUS = ''ACTIVE'') ';

2628:
2629: l_sql_query :='SELECT '|| l_col_name ||
2630: ' FROM pon_form_field_values WHERE OWNING_ENTITY_CODE = ''PON_AUCTION_HEADERS_ALL'' AND ENTITY_PK1 IN (SELECT DISTINCT AUCTION_HEADER_ID FROM po_lines_merge_v WHERE po_header_id = '
2631: || DOCUMENTID ||'AND draft_id = '||
2632: DRAFTID ||') AND FORM_ID = (SELECT FORM_ID FROM PON_FORMS_SECTIONS WHERE FORM_CODE = ''FED_PRESOL'' AND STATUS = ''ACTIVE'') ';
2633:
2634: open c_addr for l_sql_query;
2635: loop
2636: fetch c_addr into l_return_val;