APPS.PAY_SG_IRAS_AMEND_ARCHIVE dependencies on PER_PEOPLE_F

Line 60: 'from per_people_f ppf, ' ||

56: hr_utility.set_location('pysgiraa: Start of range_code',1);
57: end if;
58: --
59: p_sql := 'select distinct person_id ' ||
60: 'from per_people_f ppf, ' ||
61: 'pay_payroll_actions ppa ' ||
62: 'where ppa.payroll_action_id = :payroll_action_id ' ||
63: 'and ppa.business_group_id = ppf.business_group_id ' ||
64: 'order by ppf.person_id';

Line 288: -- Bug 2920732 - Modified the cursor to use secured views per_people_f, per_assignments_f

284: l_person_id per_all_people_f.person_id%type;
285: l_archived_person_id binary_integer;
286:
287: ------------------------------------------------------------------------
288: -- Bug 2920732 - Modified the cursor to use secured views per_people_f, per_assignments_f
289: -- Bug 3260855 - Modified the cusor to fetch only person_id, asg_id instead of
290: -- legislative parameters as global values can be used, which are initialized in Init_code.
291: ------------------------------------------------------------------------
292: cursor get_details( c_assignment_action_id pay_assignment_actions.assignment_action_id%type ) is

Line 298: per_people_f pap

294: nvl(pap.national_identifier,pap.per_information12),
295: pac.assignment_id
296: from pay_assignment_actions pac,
297: per_assignments_f paa,
298: per_people_f pap
299: where pac.assignment_action_id = c_assignment_action_id
300: and paa.assignment_id = pac.assignment_id
301: and paa.person_id = pap.person_id ;
302:

Line 393: ( p_person_id in per_people_f.person_id%type,

389: -- better performance
390: -- Do not include Obsoleted balances
391: ---------------------------------------------------------------------------------------
392: procedure a8a_balances_value
393: ( p_person_id in per_people_f.person_id%type,
394: p_assct_id in pay_assignment_actions.assignment_action_id%type,
395: p_tax_uid in pay_assignment_actions.tax_unit_id%type,
396: p_person_counter in number )
397: is

Line 2343: c_person_id per_people_f.person_id%type,

2339:
2340: cursor shares_removed
2341: (c_user_entity_id ff_user_entities.user_entity_id%type,
2342: c_assignment_id per_assignment_extra_info.assignment_id%type,
2343: c_person_id per_people_f.person_id%type,
2344: c_tax_unit_id ff_archive_item_contexts.context%type) is
2345:
2346: select distinct con2.context person_extra_info_id
2347: from ff_archive_items arch,