APPS.PAY_PPD_BUS dependencies on PER_ALL_ASSIGNMENTS_F

Line 197: from hr_soft_coding_keyflex soft, per_all_assignments_f paaf

193:
194: cursor csr_contract_type(p_per_or_asg_id number,
195: p_effective_date date) is
196: select segment4
197: from hr_soft_coding_keyflex soft, per_all_assignments_f paaf
198: where soft.soft_coding_keyflex_id = paaf.soft_coding_keyflex_id
199: and paaf.assignment_id = p_per_or_asg_id
200: and p_effective_date between paaf.effective_start_date and paaf.effective_end_date;
201:

Line 772: from per_all_assignments_f paaf, hr_soft_coding_keyflex hrsoft

768: and system_person_type in ('EMP','EMP_APL'));
769:
770: cursor csr_asg_id is
771: select null
772: from per_all_assignments_f paaf, hr_soft_coding_keyflex hrsoft
773: where paaf.assignment_id = p_per_or_asg_id and
774: paaf.business_group_id = p_business_group_id and
775: p_effective_date between paaf.effective_start_date and
776: paaf.effective_end_date and

Line 786: from per_all_assignments_f paaf, hr_soft_coding_keyflex hrsoft

782:
783:
784: cursor csr_normal_term_id is
785: select null
786: from per_all_assignments_f paaf, hr_soft_coding_keyflex hrsoft
787: where paaf.assignment_id = p_per_or_asg_id and
788: paaf.business_group_id = p_business_group_id and
789: p_effective_date between paaf.effective_start_date and
790: paaf.effective_end_date and

Line 957: from hr_soft_coding_keyflex soft, per_all_assignments_f paaf

953:
954: cursor csr_contract_type(p_per_or_asg_id number,
955: p_effective_date date) is
956: select segment4
957: from hr_soft_coding_keyflex soft, per_all_assignments_f paaf
958: where soft.soft_coding_keyflex_id = paaf.soft_coding_keyflex_id
959: and paaf.assignment_id = p_per_or_asg_id
960: and p_effective_date between paaf.effective_start_date and paaf.effective_end_date;
961: