DBA Data[Home] [Help]

APPS.HR_COMPLETE_APPRAISAL_SS dependencies on DUAL

Line 1683: 'SELECT ota_lrng_path_util.chk_complete_path_ok(:1) from dual';

1679:
1680: -- try to find out if the LP can be completed at this juncture or not
1681: BEGIN
1682: query_str :=
1683: 'SELECT ota_lrng_path_util.chk_complete_path_ok(:1) from dual';
1684:
1685: OPEN l_status_cursor FOR query_str USING l_lpe_id;
1686: EXCEPTION
1687: WHEN hr_multi_message.error_message_exist

Line 2395: FROM dual

2391:
2392: CURSOR c_main_appr_mandate_quest (c_appraisal_id IN NUMBER)
2393: IS
2394: SELECT 'Y'
2395: FROM dual
2396: WHERE EXISTS
2397: (
2398: SELECT 'x'
2399: FROM per_appraisals pa

Line 2463: FROM dual

2459:
2460: CURSOR c_appraisee_mandate_quest (c_appraisal_id IN NUMBER)
2461: IS
2462: SELECT 'Y'
2463: FROM dual
2464: WHERE EXISTS
2465: (
2466: SELECT 'x'
2467: FROM per_appraisals pa