DBA Data[Home] [Help]

APPS.PAY_BATCH_BALANCEADJ_WRAPPER dependencies on HR_SOFT_CODING_KEYFLEX

Line 678: hr_soft_coding_keyflex hsck

674:
675: cursor get_gre IS
676: select segment1
677: from per_all_assignments_f paf,
678: hr_soft_coding_keyflex hsck
679: where paf.business_group_id = p_business_group_id
680: and sysdate between paf.effective_start_date and paf.effective_end_date
681: and paf.assignment_number = p_assignment_id
682: and hsck.soft_coding_keyflex_id = paf.soft_coding_keyflex_id;

Line 697: hr_soft_coding_keyflex hsck

693: cursor get_gre_ca IS
694: select segment1, segment11, segment12,
695: nvl(segment1,nvl(segment11,segment12))
696: from per_all_assignments_f paf,
697: hr_soft_coding_keyflex hsck
698: where paf.business_group_id = p_business_group_id
699: and sysdate between paf.effective_start_date and paf.effective_end_date
700: and paf.assignment_number = p_assignment_id
701: and hsck.soft_coding_keyflex_id = paf.soft_coding_keyflex_id;