APPS.PAY_ASSIGNMENT_ACTIONS_PKG dependencies on PER_ALL_PEOPLE_F

Line 56: g_per_id per_all_people_f.person_id%type := null;

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;
58: g_per_date date := null;
59: --
60: procedure update_row(p_rowid in varchar2,

Line 513: from per_all_people_f pep

509: l_date := g_per_date;
510: else
511: select max(pep.effective_start_date)
512: into l_date
513: from per_all_people_f pep
514: where pep.person_id = p_person_id
515: and pep.effective_start_date <= p_effective_date;
516:
517: if l_date is null then

Line 521: from per_all_people_f pep

517: if l_date is null then
518:
519: select max(pep.effective_start_date)
520: into l_date
521: from per_all_people_f pep
522: where pep.person_id = p_person_id
523: and pep.effective_start_date >= p_effective_date;
524: end if;
525: