DBA Data[Home] [Help]

APPS.HR_PROCESS_ASSIGNMENT_SS dependencies on HR_SOFT_CODING_KEYFLEX

Line 6370: from hr_soft_coding_keyflex

6366: where people_group_id = p_people_group_id;
6367:
6368: cursor csr_scl_segments is
6369: select *
6370: from hr_soft_coding_keyflex
6371: where soft_coding_keyflex_id = p_soft_coding_keyflex_id;
6372:
6373: cursor csr_cag_segments is
6374: select *

Line 6407: from hr_soft_coding_keyflex scl,

6403: and puc.user_column_id = segment4;*/
6404:
6405: cursor csr_default_gre is
6406: select scl.segment1
6407: from hr_soft_coding_keyflex scl,
6408: per_all_assignments_f asg
6409: where asg.person_id = p_login_person_id
6410: and asg.business_group_id = p_business_group_id --the new hire business group
6411: and asg.primary_flag = 'Y'