APPS.PFT_PROFITAGG_PUB dependencies on DUAL

Line 2393: FROM dual;

2389: END IF;
2390:
2391: SELECT REPLACE(l_select_stmt,'TO_NUMBER(''-987654321'')','COUNT(1)')
2392: INTO l_select_stmt
2393: FROM dual;
2394:
2395: -- add mapped columns
2396:
2397: RETURN l_insert_head_stmt || ' ' || l_select_stmt || ' ' || l_from_stmt

Line 2766: FROM DUAL;

2762:
2763: SELECT REPLACE(p_select_col,'{{{CUSTOMER_ID}}}',
2764: 'cust_hier_dump.customer_id' )
2765: INTO p_select_col
2766: FROM DUAL;
2767:
2768: p_from_clause := p_from_clause ||
2769: ' , ( (SELECT child_id, parent_id customer_id ' ||
2770: ' FROM fem_customers_hier a ' ||

Line 3008: FROM DUAL;

3004:
3005: SELECT REPLACE(p_select_col,'{{{CUSTOMER_ID}}}',
3006: p_src_alias||'.customer_id')
3007: INTO p_select_col
3008: FROM DUAL;
3009:
3010: p_where_clause := p_where_clause || ' AND ' ||
3011: p_src_alias || '.data_aggregation_type_code = ' ||
3012: '''ACCOUNT_RELATIONSHIP''';