DBA Data[Home] [Help]

APPS.PAY_IN_PROF_TAX_PKG dependencies on HR_SOFT_CODING_KEYFLEX

Line 870: ,hr_soft_coding_keyflex hsc

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
874: AND paf.soft_coding_keyflex_id = hsc.soft_coding_keyflex_id

Line 948: ,hr_soft_coding_keyflex hsc

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
952: AND pay_in_prof_tax_pkg.get_state(hsc.segment3) = p_state ;