DBA Data[Home] [Help]

APPS.PAY_AU_FOREIGN_WORKERS dependencies on DUAL

Line 224: FROM DUAL

220: ,c_tax_unit_id NUMBER
221: ,c_status_id NUMBER)
222: IS
223: SELECT 'Y'
224: FROM DUAL
225: WHERE EXISTS
226: ( SELECT 1
227: FROM per_assignments_f paf
228: ,hr_soft_coding_keyflex hsc

Line 775: FROM DUAL

771: ,c_payroll_id per_time_periods.payroll_id%TYPE
772: ,c_time_period_id per_time_periods.time_period_id%TYPE)
773: IS
774: SELECT 'Y'
775: FROM DUAL
776: WHERE EXISTS
777: ( SELECT '1'
778: FROM per_assignments_f paf
779: ,hr_soft_coding_keyflex hsc

Line 859: FROM DUAL

855: ,c_payroll_id per_time_periods.payroll_id%TYPE
856: ,c_time_period_id per_time_periods.time_period_id%TYPE)
857: IS
858: SELECT 'Y'
859: FROM DUAL
860: WHERE EXISTS
861: ( SELECT '1'
862: FROM per_assignments_f paf
863: ,hr_soft_coding_keyflex hsc