APPS.PAY_FR_DADS_EMP_PKG dependencies on PER_ALL_PEOPLE_F

Line 75: From per_all_people_f ppf

71: , ppf.person_id person_id-- used to send as a parameter to s41 structure.
72: , paf.location_id location_id--used to send as a parameter in s41 Structure
73: , paf.assignment_id assignment_id -- assignment_id , p_id
74: , ppf.employee_number employee_number -- this will be the id2 column
75: From per_all_people_f ppf
76: , per_all_assignments_f paf
77: , pay_assignment_actions paa
78: , per_addresses pa
79: , fnd_territories ft

Line 107: l_person_id per_all_people_f.person_id%type;

103: And ft1_tl.language (+) = userenv('LANG');
104: --
105: l_emp_rec cur_emp_data%rowtype;
106: l_name VARCHAR2(250);
107: l_person_id per_all_people_f.person_id%type;
108: l_address_id per_addresses.address_id%type;
109: l_location_id per_all_assignments_f.location_id%type;
110:
111: p_id Number;

Line 112: l_id2 per_all_people_f.employee_number%type;

108: l_address_id per_addresses.address_id%type;
109: l_location_id per_all_assignments_f.location_id%type;
110:
111: p_id Number;
112: l_id2 per_all_people_f.employee_number%type;
113: l_pactid pay_payroll_actions.payroll_action_id%type;
114:
115: -- Local Variable Declaration for Exceptions
116: l_value fnd_new_messages.message_text%type;

Line 120: l_ss_number per_all_people_f.NATIONAL_IDENTIFIER%type;

116: l_value fnd_new_messages.message_text%type;
117: l_error_type hr_lookups.meaning%type;
118: l_error hr_lookups.meaning%type;
119: l_warning hr_lookups.meaning%type;
120: l_ss_number per_all_people_f.NATIONAL_IDENTIFIER%type;
121: l_mandatory varchar2(1);
122: l_conditional varchar2(1);
123: l_optional varchar2(1);
124: l_nationality fnd_lookup_values.meaning%type;

Line 1002: , per_all_people_f paf

998: /* DECODE(SEX, 'F', DECODE(NVL(PER_INFORMATION1, PREVIOUS_LAST_NAME), LAST_NAME, NULL,LAST_NAME) , 'M', DECODE( PREVIOUS_LAST_NAME, LAST_NAME, NULL, LAST_NAME)) Name --Getting the employee full name*/
999: From per_all_assignments_f asg
1000: ,pay_assignment_actions paa
1001: , per_jobs pj
1002: , per_all_people_f paf
1003: , per_contracts_f pc
1004: , HR_SOFT_CODING_KEYFLEX sck
1005: , hr_organization_information org_est
1006: , per_collective_agreements pca

Line 1286: l_person_number per_all_people_f.employee_number%type;

1282: l_act_type per_contracts_f.type%type;
1283: l_norm_hours NUMBER;
1284: l_frequency per_all_assignments_f.frequency%type;
1285: l_employment_cat per_all_assignments_f.employment_category%type;
1286: l_person_number per_all_people_f.employee_number%type;
1287: l_act_typ_val pay_user_column_instances_f.value%type;
1288: l_act_typ_code VARCHAR2(10);
1289: l_pension_info pay_element_entries_f.entry_information1%type;
1290: l_pen_agirc_val pay_user_column_instances_f.value%type;

Line 1318: l_emp_full_name per_all_people_f.full_name%type;

1314: l_per_id Number;
1315: l_cipdz_value varchar2(250);
1316: --Names
1317: l_issue_estab_name hr_all_organization_units_tl.name%type;
1318: l_emp_full_name per_all_people_f.full_name%type;
1319: l_country_code Varchar2(30);
1320: l_location_name hr_locations_all_tl.location_code%type;
1321:
1322: --Variable to hold the last payroll run date, which has been executed just before the dads period