DBA Data[Home] [Help]

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;