DBA Data[Home] [Help]

APPS.PAY_SA_GOSI_REPORTS dependencies on HR_ASSIGNMENT_SET_AMENDMENTS

Line 2686: from hr_assignment_set_amendments has

2682: and trunc(pos.actual_termination_date) <= trunc(l_effective_date)));
2683: /*Cursor to select assignments for a given assignment set*/
2684: cursor csr_get_assignment(l_assignment_set_id number, l_form_type varchar2) is
2685: select distinct has.assignment_id
2686: from hr_assignment_set_amendments has
2687: ,per_all_assignments_f paa
2688: ,per_periods_of_service pos
2689: ,hr_soft_coding_keyflex hsck
2690: where assignment_set_id = l_assignment_set_id

Line 2947: from hr_assignment_set_amendments haa

2943: If p_assignment_id is not null then
2944: if p_assignment_set_id is not null then
2945: begin
2946: select 1 into i
2947: from hr_assignment_set_amendments haa
2948: ,per_all_assignments_f paa
2949: ,hr_soft_coding_keyflex hscl
2950: ,per_periods_of_service pos
2951: where assignment_set_id = p_assignment_set_id