DBA Data[Home] [Help]

APPS.PAY_PSD_BUS dependencies on PER_ALL_ASSIGNMENTS_F

Line 395: from per_all_assignments_f paaf, hr_soft_coding_keyflex hrsoft

391: and system_person_type in ('EMP','EMP_APL'));
392:
393: cursor csr_asg_id is
394: select null
395: from per_all_assignments_f paaf, hr_soft_coding_keyflex hrsoft
396: where paaf.assignment_id = p_per_or_asg_id and
397: paaf.business_group_id = p_business_group_id and
398: p_effective_date between paaf.effective_start_date and
399: paaf.effective_end_date and

Line 409: from per_all_assignments_f paaf, hr_soft_coding_keyflex hrsoft

405:
406:
407: cursor csr_normal_term_id is
408: select null
409: from per_all_assignments_f paaf, hr_soft_coding_keyflex hrsoft
410: where paaf.assignment_id = p_per_or_asg_id and
411: paaf.business_group_id = p_business_group_id and
412: p_effective_date between paaf.effective_start_date and
413: paaf.effective_end_date and