APPS.PAY_ASSIGNMENT_ACTIONS_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 53: g_asg_id per_all_assignments_f.assignment_id%type := null;

49: in above.
50: */
51: --
52: g_action_status_enabled varchar2(1) := 'Y';
53: g_asg_id per_all_assignments_f.assignment_id%type := null;
54: g_asg_eff_date date := null;
55: g_asg_date date := null;
56: g_per_id per_all_people_f.person_id%type := null;
57: g_per_eff_date date := null;

Line 477: from per_all_assignments_f asg

473: else
474:
475: select max(asg.effective_start_date)
476: into l_date
477: from per_all_assignments_f asg
478: where asg.assignment_id = p_assignment_id
479: and asg.effective_start_date <= p_effective_date;
480:
481: if l_date is null then

Line 485: from per_all_assignments_f asg

481: if l_date is null then
482:
483: select max(asg.effective_start_date)
484: into l_date
485: from per_all_assignments_f asg
486: where asg.assignment_id = p_assignment_id
487: and asg.effective_start_date >= p_effective_date;
488: end if;
489: