APPS.HR_PROCESS_ASSIGNMENT_SS dependencies on HR_SOFT_CODING_KEYFLEX

Line 2432: select * from hr_soft_coding_keyflex

2428: select * from pay_people_groups
2429: where people_group_id = p_people_group_id;
2430:
2431: cursor csr_scl_segments(p_soft_coding_keyflex_id in number) is
2432: select * from hr_soft_coding_keyflex
2433: where soft_coding_keyflex_id = p_soft_coding_keyflex_id;
2434:
2435: l_people_groups csr_pgp_segments%rowtype;
2436: l_soft_coding_keyflex csr_scl_segments%rowtype;

Line 6700: from hr_soft_coding_keyflex

6696: where people_group_id = p_people_group_id;
6697:
6698: cursor csr_scl_segments is
6699: select *
6700: from hr_soft_coding_keyflex
6701: where soft_coding_keyflex_id = p_soft_coding_keyflex_id;
6702:
6703: cursor csr_cag_segments is
6704: select *

Line 6737: from hr_soft_coding_keyflex scl,

6733: and puc.user_column_id = segment4;*/
6734:
6735: cursor csr_default_gre is
6736: select scl.segment1
6737: from hr_soft_coding_keyflex scl,
6738: per_all_assignments_f asg
6739: where asg.person_id = p_login_person_id
6740: and asg.business_group_id = p_business_group_id --the new hire business group
6741: and asg.primary_flag = 'Y'

Line 6818: l_old_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;

6814: l_entries_changed varchar2(250);
6815:
6816: l_asg_future_changes_warning boolean;
6817: l_pay_proposal_warning boolean;
6818: l_old_conc_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
6819:
6820: begin
6821:
6822: hr_utility.set_location('Entering:'||l_proc, 5);