DBA Data[Home] [Help]

APPS.PAY_IN_PROF_TAX_PKG dependencies on PER_ASSIGNMENTS_F

Line 869: FROM per_assignments_f paf

865: ,p_prorate_end_date DATE
866: ,p_period_end_date DATE
867: ,p_state VARCHAR2) IS
868: SELECT '1'
869: FROM per_assignments_f paf
870: ,hr_soft_coding_keyflex hsc
871: WHERE ((paf.effective_start_date BETWEEN (p_prorate_end_date+1) AND p_period_end_date)
872: OR (paf.effective_end_date BETWEEN (p_prorate_end_date+1) AND p_period_end_date))
873: AND paf.assignment_id = p_assignment_id

Line 947: FROM per_assignments_f paf

943: ,p_date DATE
944: ,p_state VARCHAR2)
945: IS
946: SELECT 1
947: FROM per_assignments_f paf
948: ,hr_soft_coding_keyflex hsc
949: WHERE (p_date + 1) between paf.effective_start_date and paf.effective_end_date
950: AND paf.assignment_id = p_assignment_id
951: AND paf.soft_coding_keyflex_id = hsc.soft_coding_keyflex_id