APPS.HR_GENERAL2 dependencies on DUAL

Line 300: FROM dual

296: /* if p_leg_code = 'JP' then
297: BEGIN
298: SELECT null
299: INTO l_dummy
300: FROM dual
301: WHERE EXISTS
302: (SELECT 1
303: FROM per_all_people_f per
304: WHERE l_session_date BETWEEN per.effective_start_date

Line 343: FROM dual

339: ELSE */
340: BEGIN
341: SELECT null
342: INTO l_dummy
343: FROM dual
344: WHERE EXISTS
345: (SELECT 1
346: FROM per_all_people_f per
347: WHERE l_session_date BETWEEN per.effective_start_date

Line 415: FROM dual

411: --
412: BEGIN
413: SELECT null
414: INTO l_dummy
415: FROM dual
416: WHERE EXISTS
417: (SELECT 1
418: FROM per_all_people_f per
419: WHERE l_session_date BETWEEN per.effective_start_date

Line 530: FROM dual

526: ELSE
527: BEGIN
528: SELECT 1
529: INTO dummy_value
530: FROM dual
531: WHERE EXISTS (SELECT 1
532: FROM PER_ALL_PEOPLE_F per
533: WHERE per.party_id=p_party_id
534: AND per.business_group_id=Hr_General.get_business_Group_id);

Line 1178: select 'TRUE' from sys.dual where

1174: return varchar2 is
1175: --
1176: l_efc_flag VARCHAR2(10);
1177: cursor efc_col(table_name IN VARCHAR2, column_name IN VARCHAR2) is
1178: select 'TRUE' from sys.dual where
1179: (column_name like '%AMOUNT%' or column_name like '%AMT%' or
1180: column_name like '%VAL%' or column_name like '%COST%' or
1181: column_name like '%PRICE%' or column_name like '%FEE%' or
1182: column_name like '%MIN%' or column_name like '%MAX%' or

Line 1220: select 'TRUE' from sys.dual where

1216: ((instr(column_name,'CODE')>0 and column_name like '%CURRENCY%CODE') or
1217: (instr(column_name,'CODE')=0));
1218:
1219: cursor efc_col_ben(table_name IN VARCHAR2, column_name IN VARCHAR2) is
1220: select 'TRUE' from sys.dual where
1221: (column_name like '%AMOUNT%' or column_name like '%AMT%' or
1222: column_name like '%VAL%' or column_name like '%COST%' or
1223: column_name like '%PRICE%' or column_name like '%FEE%' or
1224: column_name like '%MIN%' or column_name like '%MAX%' or