DBA Data[Home] [Help]

APPS.PQP_NL_ABP_FUNCTIONS dependencies on DUAL

Line 492: FROM dual

488: SELECT effective_date
489: FROM fnd_sessions
490: WHERE session_id IN
491: (SELECT userenv('sessionid')
492: FROM dual
493: );
494:
495: --
496: --Cursor to find all rows which have dates overlapping the current record dates

Line 1141: FROM dual

1137: SELECT effective_date
1138: FROM fnd_sessions
1139: WHERE session_id IN
1140: (SELECT userenv('sessionid')
1141: FROM dual
1142: );
1143:
1144: l_eff_date DATE;
1145: l_min_start_date DATE := NULL;

Line 5300: FROM dual;

5296: --
5297: hr_utility.set_location('...EE Asg Contribution is a PE or FA ',80);
5298: SELECT DECODE(l_ee_contrib_type,'PE',0,'FA',1)
5299: INTO p_ee_contrib_type
5300: FROM dual;
5301: p_ee_contrib_value := l_ee_contrib_value;
5302: l_ee_return_value := 0;
5303:
5304: END IF;

Line 5345: FROM dual;

5341: ELSE
5342:
5343: SELECT DECODE(l_er_contrib_type,'PE',0,'FA',1)
5344: INTO p_er_contrib_type
5345: FROM dual;
5346: hr_utility.set_location('...ER Asg Contribution is a PE or FA ',100);
5347: p_er_contrib_value := l_er_contrib_value;
5348: l_er_return_value := 0;
5349: