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 68: 'from per_people_f ppf, ' ||

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

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

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

Line 447: per_people_f pap

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

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

591: -- better performance
592: -- Do not include Obsoleted balances
593: ---------------------------------------------------------------------------------------
594: procedure a8a_balances_value
595: ( p_person_id in per_people_f.person_id%type,
596: p_assct_id in pay_assignment_actions.assignment_action_id%type,
597: p_tax_uid in pay_assignment_actions.tax_unit_id%type,
598: p_person_counter in number )
599: is

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

1792:
1793: ---------------------------------------------------------------------------
1794: -- Bug# 2833530
1795: -- Added check_termination and get_max_assactid cursors
1796: -- Bug# 2920732 - Modified the cursor to use secured views per_people_f, per_assignments_f
1797: ---------------------------------------------------------------------------
1798: cursor check_termination( c_person_id per_all_people_f.person_id%TYPE,
1799: c_basis_year varchar2 )
1800: is

Line 1804: from per_people_f pap,

1800: is
1801: select 'Y',
1802: oldpaaf.assignment_id,
1803: newpaaf.assignment_id
1804: from per_people_f pap,
1805: per_assignments_f oldpaaf,
1806: per_assignments_f newpaaf
1807: where pap.person_id = c_person_id
1808: and pap.person_id = oldpaaf.person_id

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

2830: v_national_identifier per_all_people_f.national_identifier%type;
2831: v_sex hr_lookups.meaning%type;
2832: v_date_of_birth varchar2(30);
2833: ---------------------------------------------------------------------------
2834: -- Bug# 2920732 - Modified the cursor to use secured view per_people_f
2835: -- Bug 2645599
2836: ---------------------------------------------------------------------------
2837: cursor person_details
2838: ( c_person_id per_all_people_f.person_id%type,

Line 2845: from per_people_f people,

2841: is
2842: select people.national_identifier,
2843: h.meaning,
2844: fnd_date.date_to_canonical(people.date_of_birth)
2845: from per_people_f people,
2846: hr_lookups h
2847: where people.person_id = c_person_id
2848: and people.effective_start_date = (
2849: select max(people1.effective_start_date)

Line 2850: from per_people_f people1

2846: hr_lookups h
2847: where people.person_id = c_person_id
2848: and people.effective_start_date = (
2849: select max(people1.effective_start_date)
2850: from per_people_f people1
2851: where people1.person_id = people.person_id
2852: and people1.effective_start_date <= c_basis_end
2853: and people1.effective_end_date >= c_basis_start
2854: )

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

3185: v_payee_id_type per_all_people_f.per_information23%type;
3186: l_payee_id_check char(1);
3187: l_nationality_code varchar2(3);
3188: ---------------------------------------------------------------------------
3189: -- Bug# 2920732 - Modified the cursor to use secured view per_people_f
3190: -- Bug 2645599
3191: -- Bug 5435088, Added Payee ID Type and permit date
3192: ---------------------------------------------------------------------------
3193: cursor emp_details

Line 3205: from per_people_f people

3201: 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
3202: -- fnd_date.canonical_to_date(people.per_information9), -- Bug 5435088
3203: people.per_information12,
3204: people.per_information23
3205: from per_people_f people
3206: where people.person_id = c_person_id
3207: and people.effective_start_date = (
3208: select max(people1.effective_start_date)
3209: from per_people_f people1

Line 3209: from per_people_f people1

3205: from per_people_f people
3206: where people.person_id = c_person_id
3207: and people.effective_start_date = (
3208: select max(people1.effective_start_date)
3209: from per_people_f people1
3210: where people1.person_id = people.person_id
3211: and people1.effective_start_date <= c_basis_end
3212: and people1.effective_end_date >= c_basis_start);
3213: --

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

3293: -- Added for bug 5435088
3294: v_name_of_bank per_people_extra_info.pei_information6%type;
3295: v_additional_information per_people_extra_info.pei_information1%type;
3296: ---------------------------------------------------------------------------
3297: -- Bug# 2920732 - Modified the cursor to use the secured view per_people_f
3298: -- Bug 5435088, Removed archiving gratuity_or_comp_info, gains_or_profit_from
3299: -- _shares, remarks
3300: -- Bug 6349937, removed hr_lookups which is not being used
3301: ---------------------------------------------------------------------------

Line 3320: per_people_f people

3316: info.pei_information1
3317: from per_people_extra_info indicators,
3318: per_people_extra_info info,
3319: per_people_extra_info details,
3320: per_people_f people
3321: where people.person_id = c_person_id
3322: and people.effective_start_date = (
3323: select max(people1.effective_start_date)
3324: from per_people_f people1

Line 3324: from per_people_f people1

3320: per_people_f people
3321: where people.person_id = c_person_id
3322: and people.effective_start_date = (
3323: select max(people1.effective_start_date)
3324: from per_people_f people1
3325: where people1.person_id = people.person_id
3326: and people1.effective_start_date <= c_basis_end
3327: and people1.effective_end_date >= c_basis_start)/*Bug 2645599*/
3328: and people.person_id = indicators.person_id(+)