APPS.HR_GENERAL2 dependencies on DUAL

Line 288: FROM dual

284: /* if p_leg_code = 'JP' then
285: BEGIN
286: SELECT null
287: INTO l_dummy
288: FROM dual
289: WHERE EXISTS
290: (SELECT 1
291: FROM per_all_people_f per
292: WHERE l_session_date BETWEEN per.effective_start_date

Line 331: FROM dual

327: ELSE */
328: BEGIN
329: SELECT null
330: INTO l_dummy
331: FROM dual
332: WHERE EXISTS
333: (SELECT 1
334: FROM per_all_people_f per
335: WHERE l_session_date BETWEEN per.effective_start_date

Line 403: FROM dual

399: --
400: BEGIN
401: SELECT null
402: INTO l_dummy
403: FROM dual
404: WHERE EXISTS
405: (SELECT 1
406: FROM per_all_people_f per
407: WHERE l_session_date BETWEEN per.effective_start_date

Line 491: FROM dual

487: BEGIN
488: BEGIN
489: SELECT 1
490: INTO dummy_value
491: FROM dual
492: WHERE EXISTS (SELECT 1
493: FROM PER_ALL_PEOPLE_F per
494: WHERE per.party_id=p_party_id
495: AND per.business_group_id=Hr_General.get_business_Group_id);

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

1120: return varchar2 is
1121: --
1122: l_efc_flag VARCHAR2(10);
1123: cursor efc_col(table_name IN VARCHAR2, column_name IN VARCHAR2) is
1124: select 'TRUE' from sys.dual where
1125: (column_name like '%AMOUNT%' or column_name like '%AMT%' or
1126: column_name like '%VAL%' or column_name like '%COST%' or
1127: column_name like '%PRICE%' or column_name like '%FEE%' or
1128: column_name like '%MIN%' or column_name like '%MAX%' or

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

1162: ((instr(column_name,'CODE')>0 and column_name like '%CURRENCY%CODE') or
1163: (instr(column_name,'CODE')=0));
1164:
1165: cursor efc_col_ben(table_name IN VARCHAR2, column_name IN VARCHAR2) is
1166: select 'TRUE' from sys.dual where
1167: (column_name like '%AMOUNT%' or column_name like '%AMT%' or
1168: column_name like '%VAL%' or column_name like '%COST%' or
1169: column_name like '%PRICE%' or column_name like '%FEE%' or
1170: column_name like '%MIN%' or column_name like '%MAX%' or