eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_SG_IRAS_ARCHIVE dependencies on PER_PEOPLE_F

Line 65: 'from per_people_f ppf, ' ||

61: hr_utility.set_location(' Start of range_code',1);
62: end if;
63: --
64: p_sql := 'select distinct person_id ' ||
65: 'from per_people_f ppf, ' ||
66: 'pay_payroll_actions ppa ' ||
67: 'where ppa.payroll_action_id = :payroll_action_id ' ||
68: 'and ppa.business_group_id = ppf.business_group_id ' ||
69: 'order by ppf.person_id';

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

430: l_person_id per_all_people_f.person_id%type;
431: l_archived_person_id binary_integer;
432:
433: ------------------------------------------------------------------------
434: -- Bug 2920732 - Modified the cursor to use secured views per_people_f, per_assignments_f
435: -- Bug 3260855 - Modified the cusor to fetch only person_id, asg_id instead of
436: -- legislative parameters as global values can be used, which are initialized in Init_code.
437: ------------------------------------------------------------------------
438: cursor get_details( c_assignment_action_id pay_assignment_actions.assignment_action_id%type ) is

Line 444: per_people_f pap

440: nvl(pap.national_identifier,pap.per_information12),
441: pac.assignment_id
442: from pay_assignment_actions pac,
443: per_assignments_f paa,
444: per_people_f pap
445: where pac.assignment_action_id = c_assignment_action_id
446: and paa.assignment_id = pac.assignment_id
447: and paa.person_id = pap.person_id ;
448:

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

584: -- better performance
585: -- Do not include Obsoleted balances
586: ---------------------------------------------------------------------------------------
587: procedure a8a_balances_value
588: ( p_person_id in per_people_f.person_id%type,
589: p_assct_id in pay_assignment_actions.assignment_action_id%type,
590: p_tax_uid in pay_assignment_actions.tax_unit_id%type,
591: p_person_counter in number )
592: is

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

1781:
1782: ---------------------------------------------------------------------------
1783: -- Bug# 2833530
1784: -- Added check_termination and get_max_assactid cursors
1785: -- Bug# 2920732 - Modified the cursor to use secured views per_people_f, per_assignments_f
1786: ---------------------------------------------------------------------------
1787: cursor check_termination( c_person_id per_all_people_f.person_id%TYPE,
1788: c_basis_year varchar2 )
1789: is

Line 1793: from per_people_f pap,

1789: is
1790: select 'Y',
1791: oldpaaf.assignment_id,
1792: newpaaf.assignment_id
1793: from per_people_f pap,
1794: per_assignments_f oldpaaf,
1795: per_assignments_f newpaaf
1796: where pap.person_id = c_person_id
1797: and pap.person_id = oldpaaf.person_id

Line 2782: -- Bug# 2920732 - Modified the cursor to use secured view per_people_f

2778: v_national_identifier per_all_people_f.national_identifier%type;
2779: v_sex hr_lookups.meaning%type;
2780: v_date_of_birth varchar2(30);
2781: ---------------------------------------------------------------------------
2782: -- Bug# 2920732 - Modified the cursor to use secured view per_people_f
2783: -- Bug 2645599
2784: ---------------------------------------------------------------------------
2785: cursor person_details
2786: ( c_person_id per_all_people_f.person_id%type,

Line 2793: from per_people_f people,

2789: is
2790: select people.national_identifier,
2791: h.meaning,
2792: fnd_date.date_to_canonical(people.date_of_birth)
2793: from per_people_f people,
2794: hr_lookups h
2795: where people.person_id = c_person_id
2796: and people.effective_start_date = (
2797: select max(people1.effective_start_date)

Line 2798: from per_people_f people1

2794: hr_lookups h
2795: where people.person_id = c_person_id
2796: and people.effective_start_date = (
2797: select max(people1.effective_start_date)
2798: from per_people_f people1
2799: where people1.person_id = people.person_id
2800: and people1.effective_start_date <= c_basis_end
2801: and people1.effective_end_date >= c_basis_start
2802: )

Line 3060: -- Bug# 2920732 - Modified the cursor to use secured view per_people_f

3056: v_payee_id_type per_all_people_f.per_information23%type;
3057: l_payee_id_check char(1);
3058: l_nationality_code varchar2(3);
3059: ---------------------------------------------------------------------------
3060: -- Bug# 2920732 - Modified the cursor to use secured view per_people_f
3061: -- Bug 2645599
3062: -- Bug 5435088, Added Payee ID Type and permit date
3063: ---------------------------------------------------------------------------
3064: cursor emp_details

Line 3076: from per_people_f people

3072: to_char(fnd_date.canonical_to_date(people.per_information9),'YYYY')||'/'||to_char(fnd_date.canonical_to_date(people.per_information9),'MM')||'/'||to_char(fnd_date.canonical_to_date(people.per_information9),'DD'), -- Bug 5435088
3073: -- fnd_date.canonical_to_date(people.per_information9), -- Bug 5435088
3074: people.per_information12,
3075: people.per_information23
3076: from per_people_f people
3077: where people.person_id = c_person_id
3078: and people.effective_start_date = (
3079: select max(people1.effective_start_date)
3080: from per_people_f people1

Line 3080: from per_people_f people1

3076: from per_people_f people
3077: where people.person_id = c_person_id
3078: and people.effective_start_date = (
3079: select max(people1.effective_start_date)
3080: from per_people_f people1
3081: where people1.person_id = people.person_id
3082: and people1.effective_start_date <= c_basis_end
3083: and people1.effective_end_date >= c_basis_start);
3084: --

Line 3165: -- Bug# 2920732 - Modified the cursor to use the secured view per_people_f

3161: -- Added for bug 5435088
3162: v_name_of_bank per_people_extra_info.pei_information6%type;
3163: v_additional_information per_people_extra_info.pei_information1%type;
3164: ---------------------------------------------------------------------------
3165: -- Bug# 2920732 - Modified the cursor to use the secured view per_people_f
3166: -- Bug 5435088, Removed archiving gratuity_or_comp_info, gains_or_profit_from
3167: -- _shares, remarks
3168: -- Bug 6349937, removed hr_lookups which is not being used
3169: ---------------------------------------------------------------------------

Line 3188: per_people_f people

3184: info.pei_information1
3185: from per_people_extra_info indicators,
3186: per_people_extra_info info,
3187: per_people_extra_info details,
3188: per_people_f people
3189: where people.person_id = c_person_id
3190: and people.effective_start_date = (
3191: select max(people1.effective_start_date)
3192: from per_people_f people1

Line 3192: from per_people_f people1

3188: per_people_f people
3189: where people.person_id = c_person_id
3190: and people.effective_start_date = (
3191: select max(people1.effective_start_date)
3192: from per_people_f people1
3193: where people1.person_id = people.person_id
3194: and people1.effective_start_date <= c_basis_end
3195: and people1.effective_end_date >= c_basis_start)/*Bug 2645599*/
3196: and people.person_id = indicators.person_id(+)