APPS.PAY_PL_PAYE_API dependencies on HR_SOFT_CODING_KEYFLEX

Line 44: hr_soft_coding_keyflex scl,

40:
41: cursor cur_asg is select nvl(assignment_eff_start_date,term_eff_start_date) effective_start_date from
42: (select min(paaf.effective_start_date) assignment_eff_start_date
43: from per_all_assignments_f paaf,
44: hr_soft_coding_keyflex scl,
45: per_assignment_status_types past
46: where paaf.ASSIGNMENT_STATUS_TYPE_ID = past.ASSIGNMENT_STATUS_TYPE_ID
47: and paaf.SOFT_CODING_KEYFLEX_ID = scl.SOFT_CODING_KEYFLEX_ID
48: and paaf.assignment_id = p_per_or_asg_id

Line 695: from hr_soft_coding_keyflex soft, per_all_assignments_f paaf

691: and bus.business_group_id = paf.business_group_id;
692:
693: cursor csr_contract_type is
694: select segment4
695: from hr_soft_coding_keyflex soft, per_all_assignments_f paaf
696: where soft.soft_coding_keyflex_id = paaf.soft_coding_keyflex_id
697: and paaf.assignment_id = p_assignment_id
698: and p_effective_date between paaf.effective_start_date and paaf.effective_end_date;
699:

Line 700: l_contract_type hr_soft_coding_keyflex.segment4%TYPE;

696: where soft.soft_coding_keyflex_id = paaf.soft_coding_keyflex_id
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);