DBA Data[Home] [Help]

APPS.PAY_PL_PAYE_API dependencies on PAY_PL_PAYE_DETAILS_F

Line 701: l_rate_of_tax pay_pl_paye_details_f.rate_of_tax%TYPE;

697: and paaf.assignment_id = p_assignment_id
698: and p_effective_date between paaf.effective_start_date and paaf.effective_end_date;
699:
700: l_contract_type hr_soft_coding_keyflex.segment4%TYPE;
701: l_rate_of_tax pay_pl_paye_details_f.rate_of_tax%TYPE;
702:
703: begin
704: hr_utility.set_location('Entering:'|| l_proc, 10);
705:

Line 737: -- in the table pay_pl_paye_details_f

733: fetch csr_contract_type into l_contract_type;
734: close csr_contract_type;
735:
736: -- For Contract types L01, L02, L03, L04, L09, L10, L11 we will not store the Rate of Tax
737: -- in the table pay_pl_paye_details_f
738: if l_contract_type in ('L01','L02','L03','L04','L09','L10','L11') then
739: l_rate_of_tax := NULL;
740: else
741: l_rate_of_tax := p_rate_of_tax;