APPS.GMF_COPY_ITEM_COST dependencies on DUAL

Line 308: FROM dual ;

304: BEGIN
305: g_effid_copy := FND_PROFILE.VALUE('GMF_CPIC_EFF') ;
306: SELECT decode(g_effid_copy, 'Y', 'YES', 'N', 'NO', '')
307: INTO l_effid_copy
308: FROM dual ;
309: gmf_util.msg_log('GMF_CPIC_EFFID', l_effid_copy ) ; --niyadav
310:
311: EXCEPTION
312: WHEN OTHERS THEN

Line 701: l_sql_org := 'SELECT :pi_organization_id_to '||' FROM dual ' ;

697: IF (pi_organization_id_to IS NOT NULL) THEN
698:
699: l_sql_org := '' ;
700:
701: l_sql_org := 'SELECT :pi_organization_id_to '||' FROM dual ' ;
702:
703: ELSE
704:
705: -- 'All Warehouse' option selected

Line 746: l_sql_periods := 'SELECT :pi_period_id_to FROM dual ' ;

742: -- Build SQL to get target periods when From/To Periods are not null.
743:
744: IF (pi_period_id_to IS NOT NULL) THEN -- copy to one period.
745:
746: l_sql_periods := 'SELECT :pi_period_id_to FROM dual ' ;
747:
748: ELSE
749: l_sql_periods := '' ;
750: if(pi_organization_id_to is not null) then

Line 2072: l_sql_org_b := 'SELECT :pi_organization_id_to FROM dual ' ;

2068:
2069: IF (pi_organization_id_to IS NOT NULL) THEN -- copying to one organization
2070:
2071: l_sql_org_b := '' ;
2072: l_sql_org_b := 'SELECT :pi_organization_id_to FROM dual ' ;
2073:
2074: ELSE
2075:
2076: -- 'All organizations' option selected

Line 2115: l_sql_periods_b := 'SELECT :pi_period_id_to FROM dual ' ;

2111:
2112:
2113: -- Build SQL to get target periods when From/To Periods are not null.
2114: IF (pi_period_code_to IS NOT NULL) THEN -- copy to one period.
2115: l_sql_periods_b := 'SELECT :pi_period_id_to FROM dual ' ;
2116: ELSE
2117: l_sql_periods_b := '' ;
2118: if(pi_organization_id_to is not null) then
2119: l_sql_periods_b := 'SELECT ' ||