APPS.PAY_PL_POST_TERMINATION_PKG dependencies on PAY_PL_PAYE_DETAILS_F

Line 37: from pay_pl_paye_details_f

33: income_reduction,
34: income_reduction_amount,
35: rate_of_tax,
36: object_version_number
37: from pay_pl_paye_details_f
38: where contract_category=r_contract_category
39: and per_or_asg_id =r_per_or_asg_id
40: and ( r_effective_date is null or
41: r_effective_date between effective_start_date and effective_end_date

Line 77: l_temp_effective_start_date pay_pl_paye_details_f.effective_start_date%type;

73:
74: l_temp_ovn number;
75: l_temp_details_id number;
76: l_temp_effective_date_warning boolean;
77: l_temp_effective_start_date pay_pl_paye_details_f.effective_start_date%type;
78: l_temp_effective_end_date pay_pl_paye_details_f.effective_end_date%type;
79:
80: l_proc varchar2(55);
81: BEGIN

Line 78: l_temp_effective_end_date pay_pl_paye_details_f.effective_end_date%type;

74: l_temp_ovn number;
75: l_temp_details_id number;
76: l_temp_effective_date_warning boolean;
77: l_temp_effective_start_date pay_pl_paye_details_f.effective_start_date%type;
78: l_temp_effective_end_date pay_pl_paye_details_f.effective_end_date%type;
79:
80: l_proc varchar2(55);
81: BEGIN
82: --