APPS.PAY_IE_P45_ARCHIVE dependencies on PAY_IE_PAYE_DETAILS_F

Line 893: from pay_ie_paye_details_f pipd

889: select nvl(monthly_tax_credit,0)
890: ,nvl(weekly_tax_credit,0)
891: ,nvl(monthly_std_rate_cut_off,0)
892: ,nvl(weekly_std_rate_cut_off,0)
893: from pay_ie_paye_details_f pipd
894: where assignment_id = p_assignment_id
895: and p_date_earned between
896: effective_start_date and effective_end_date
897: and info_source in ('IE_P45','IE_ELECTRONIC','IE_CERT_TAX_CREDITS')

Line 1004: from pay_ie_paye_details_f

1000: ,weekly_tax_credit
1001: ,weekly_std_rate_cut_off
1002: ,monthly_tax_credit
1003: ,monthly_std_rate_cut_off
1004: from pay_ie_paye_details_f
1005: where assignment_id = p_assignment_id
1006: and p_termination_date between effective_start_date and effective_end_date;
1007: -- bug 13359530 13513882
1008: CURSOR csr_get_usc_details is

Line 1016: from pay_ie_paye_details_f

1012: ,usc_yrly_cutoff_2
1013: ,usc_mthly_cutoff_2
1014: ,usc_wkly_cutoff_2
1015: ,usc_tax_basis
1016: from pay_ie_paye_details_f
1017: where assignment_id = p_assignment_id
1018: and p_termination_date between effective_start_date and effective_end_date;
1019:
1020:

Line 2959: from pay_ie_paye_details_f

2955: /*
2956: cursor cur_tax_basis(l_termination_date date)
2957: is
2958: select 'N'
2959: from pay_ie_paye_details_f
2960: where assignment_id=p_assignment_id
2961: and l_termination_date between effective_start_date and effective_end_date
2962: and tax_basis not in ('IE_EMERGENCY','IE_EMERGENCY_NO_PPS');
2963: */