APPS.PAY_AU_PAYSUM_ALLOWANCE dependencies on PER_ALL_PEOPLE_F

Line 705: cursor csr_get_person (c_person_id per_all_people_f.person_id%type,

701: and pad.primary_flag = 'Y'
702: order by person_id, date_from
703: ;
704:
705: cursor csr_get_person (c_person_id per_all_people_f.person_id%type,
706: c_date date) is
707: select distinct full_name, employee_number
708: from per_all_people_f
709: where person_id = c_person_id

Line 708: from per_all_people_f

704:
705: cursor csr_get_person (c_person_id per_all_people_f.person_id%type,
706: c_date date) is
707: select distinct full_name, employee_number
708: from per_all_people_f
709: where person_id = c_person_id
710: and c_date between effective_start_date and effective_end_date;
711:
712: e_bad_address exception;