APPS.PAY_US_OVER_LIMIT_PKG dependencies on PER_PEOPLE_F

Line 17: per_people_f in Action_Creation

13: 08-DEC-2001 irgonzal 115.1 Simplied the sort_action cursor
14: since the sorting is performed in
15: the second stage of the process.
16: Removed reference to pactid and
17: per_people_f in Action_Creation
18: cursor.
19: 11-DEC-2001 irgonzal 115.2 Corrected typo in sort_action
20: procedure and removed reference
21: to per_people_f table in sort_

Line 21: to per_people_f table in sort_

17: per_people_f in Action_Creation
18: cursor.
19: 11-DEC-2001 irgonzal 115.2 Corrected typo in sort_action
20: procedure and removed reference
21: to per_people_f table in sort_
22: action procedure.
23: 20-DEC-2001 meshah 115.3 2157065 changed hr_locations to
24: hr_locations_all in c_actions
25: cursor.

Line 165: l_ssn per_people_f.national_identifier%type;

161: l_bg_id per_assignments_f.business_group_id%type;
162: l_tax_type varchar2(100);
163:
164: l_per_id per_assignments_f.person_id%type;
165: l_ssn per_people_f.national_identifier%type;
166: l_state_code pay_us_states.state_code%type;
167: l_state_abbrev pay_us_states.state_abbrev%type;
168:
169:

Line 178: l_person_id per_people_f.person_id%TYPE;

174: num number;
175:
176: l_aaid pay_assignment_actions.assignment_action_id%TYPE;
177: l_tu_id pay_assignment_actions.tax_unit_id%TYPE;
178: l_person_id per_people_f.person_id%TYPE;
179:
180: p_over_limit_flag varchar2(1);
181: sac_temp number;
182: lv_where_condition varchar2(5000) ;

Line 196: l_prev_person_id per_people_f.person_id%type;

192: pay_us_payroll_utils.get_parameter('TAX_TYPE',ppa.legislative_parameters)
193: from pay_payroll_actions ppa
194: where ppa.payroll_action_id = pactid;
195:
196: l_prev_person_id per_people_f.person_id%type;
197: l_prev_tu_id pay_assignment_actions.tax_unit_id%type;
198:
199: --
200: -- #2453584: split cursors