APPS.PAY_1099R_PKG dependencies on PER_PEOPLE_F

Line 176: l_ssn per_people_f.national_identifier%type;

172: l_gre_id pay_assignment_actions.tax_unit_id%type;
173: l_org_id per_assignments_f.organization_id%type;
174: l_loc_id per_assignments_f.location_id%type;
175: l_per_id per_assignments_f.person_id%type;
176: l_ssn per_people_f.national_identifier%type;
177: l_state_code pay_us_states.state_code%type;
178: l_asg_set_id number;
179: l_eoy_payroll_action_id pay_payroll_actions.payroll_action_id%type;
180: l_eoy_start_date date;

Line 667: from per_people_f ppf

663: /* when person or SSN is entered */
664:
665: if (l_ssn is not null and l_per_id is null ) then
666: select person_id into l_per_id
667: from per_people_f ppf
668: where national_identifier = l_ssn
669: and l_effective_date between effective_start_date
670: and effective_end_date;
671: end if;

Line 1197: l_person_id per_people_f.person_id%type;

1193: l_region_2 per_addresses.region_2%TYPE;
1194: l_postal_code per_addresses.postal_code%TYPE;
1195: l_country per_addresses.country%TYPE;
1196: l_country_name varchar2(240);
1197: l_person_id per_people_f.person_id%type;
1198: l_validate varchar2(1) := 'Y';
1199:
1200: BEGIN
1201: