APPS.PAY_ISB_BUS dependencies on PAY_IE_PAYE_DETAILS_F
Line 137: from pay_ie_paye_details_f ipd
133: procedure chk_paye_details( p_effective_date in date,
134: p_rec in pay_isb_shd.g_rec_type) is
135: cursor c_paye_details is
136: select paye_details_id 137: from pay_ie_paye_details_f ipd 138: where ipd.assignment_id = p_rec.assignment_id
139: and (ipd.tax_basis = 'IE_CUMULATIVE'
140: or ipd.tax_basis = 'IE_WEEK1_MONTH1')
141: and p_effective_date between effective_start_date and effective_end_date;