APPS.PAY_AU_FOREIGN_WORKERS dependencies on HR_SOFT_CODING_KEYFLEX

Line 228: ,hr_soft_coding_keyflex hsc

224: FROM DUAL
225: WHERE EXISTS
226: ( SELECT 1
227: FROM per_assignments_f paf
228: ,hr_soft_coding_keyflex hsc
229: WHERE paf.assignment_id = c_assignment_id
230: AND paf.soft_coding_keyflex_id = hsc.soft_coding_keyflex_id
231: AND hsc.segment1 = c_tax_unit_id
232: AND paf.assignment_status_type_id = c_status_id

Line 398: ,hr_soft_coding_keyflex hsc

394: ,c_status_id per_assignments_f.assignment_status_type_id%TYPE)
395: IS
396: SELECT pps.actual_termination_date
397: FROM per_assignments_f paf
398: ,hr_soft_coding_keyflex hsc
399: ,per_periods_of_service pps
400: WHERE paf.assignment_id = c_assignment_id
401: AND paf.soft_coding_keyflex_id = hsc.soft_coding_keyflex_id
402: AND hsc.segment1 LIKE c_tax_unit_id

Line 502: ,hr_soft_coding_keyflex hsc

498: ,paf.effective_end_date
499: ,paf.payroll_id
500: ,hsc.segment1 tax_unit_id
501: FROM per_assignments_f paf
502: ,hr_soft_coding_keyflex hsc
503: WHERE paf.assignment_id = c_assignment_id
504: AND paf.soft_coding_keyflex_id = hsc.soft_coding_keyflex_id
505: AND hsc.segment1 LIKE c_tax_unit_id
506: AND to_char(paf.assignment_status_type_id) like c_status_id

Line 779: ,hr_soft_coding_keyflex hsc

775: FROM DUAL
776: WHERE EXISTS
777: ( SELECT '1'
778: FROM per_assignments_f paf
779: ,hr_soft_coding_keyflex hsc
780: ,per_time_periods ptp
781: WHERE ptp.payroll_id = c_payroll_id
782: AND ptp.time_period_id = c_time_period_id
783: AND paf.assignment_id = c_assignment_id

Line 863: ,hr_soft_coding_keyflex hsc

859: FROM DUAL
860: WHERE EXISTS
861: ( SELECT '1'
862: FROM per_assignments_f paf
863: ,hr_soft_coding_keyflex hsc
864: ,per_time_periods ptp
865: WHERE ptp.payroll_id = c_payroll_id
866: AND ptp.time_period_id = c_time_period_id
867: AND paf.assignment_id = c_assignment_id