APPS.PAY_1099R_PKG dependencies on PER_PEOPLE_F

Line 192: l_ssn per_people_f.national_identifier%type;

188: l_gre_id pay_assignment_actions.tax_unit_id%type;
189: l_org_id per_assignments_f.organization_id%type;
190: l_loc_id per_assignments_f.location_id%type;
191: l_per_id per_assignments_f.person_id%type;
192: l_ssn per_people_f.national_identifier%type;
193: l_state_code pay_us_states.state_code%type;
194: l_asg_set_id number;
195: l_eoy_payroll_action_id pay_payroll_actions.payroll_action_id%type;
196: l_eoy_start_date date;

Line 683: from per_people_f ppf

679: /* when person or SSN is entered */
680:
681: if (l_ssn is not null and l_per_id is null ) then
682: select person_id into l_per_id
683: from per_people_f ppf
684: where national_identifier = l_ssn
685: and l_effective_date between effective_start_date
686: and effective_end_date;
687: end if;

Line 1213: l_person_id per_people_f.person_id%type;

1209: l_region_2 per_addresses.region_2%TYPE;
1210: l_postal_code per_addresses.postal_code%TYPE;
1211: l_country per_addresses.country%TYPE;
1212: l_country_name varchar2(240);
1213: l_person_id per_people_f.person_id%type;
1214: l_validate varchar2(1) := 'Y';
1215:
1216: BEGIN
1217: