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_GB_RTI dependencies on PER_ALL_PEOPLE_F

Line 89: to use per_all_people_f instead of per_people_f

85: 29-Nov-2012 rajganga 115.64 15914459 Fixed Rti sent for other asgs of PAYE Agg.
86: 03-Jan-2013 ssarap 115.65 15959015 Employees not pickup up. Modified the cursor to
87: fix the issue.
88: 09-Jan-2013 achandwa 115.66 15989627 Employees not pickup up. Modified the range cursor to
89: to use per_all_people_f instead of per_people_f
90: 10-Jan-2013 achandwa 115.70 Modified date_of_leaving validation.
91: 28-Jan-2013 ssarap 115.71 16221548 Changed the csr_asg cursor.
92: 08-Mar-2013 ssarap 115.72 16456256 Added Date track check to sql statement in procedure person_addr_validations_nino
93: 25-Mar-2013 ssarap 115.74 16536044 Modified csr_asg

Line 326: per_all_people_f pap,

322:
323: cursor c_get_employee_flag(asg_id number) is
324: select distinct pap.effective_start_date , pap.effective_end_date , pap.current_employee_flag current_employee_flag
325: from per_all_assignments_f paa,
326: per_all_people_f pap,
327: per_periods_of_service serv
328: where paa.assignment_id = asg_id
329: and pap.person_id = paa.person_id
330: and paa.period_of_service_id = serv.period_of_service_id and

Line 353: per_all_people_f pap,

349: pap.effective_start_date effective_start_date,
350: serv.actual_termination_date actual_termination_date
351: FROM pay_assignment_actions act,
352: per_all_assignments_f paa,
353: per_all_people_f pap,
354: per_periods_of_service serv,
355: per_assignment_status_types past
356: where act.assignment_action_id = p_assactid
357: and act.assignment_id = paa.assignment_id

Line 386: per_all_people_f pap,

382: pap.effective_start_date effective_start_date,
383: serv.actual_termination_date actual_termination_date
384: FROM pay_assignment_actions act,
385: per_all_assignments_f paa,
386: per_all_people_f pap,
387: per_periods_of_service serv,
388: per_assignment_status_types past
389: where act.assignment_action_id = p_assactid
390: and act.assignment_id = paa.assignment_id

Line 524: per_all_people_f peo,

520:
521: cursor csr_check_cont_emp(p_person_id number,p_tax_ref varchar2) is
522: select min(paaf.EFFECTIVE_START_DATE) , max(paaf1.EFFECTIVE_END_DATE) , max(paaf.assignment_id) l_prev_asg_id
523: from
524: per_all_people_f peo,
525: per_all_people_f peo1,
526: per_all_assignments_f paaf,
527: per_all_assignments_f paaf1,
528: per_assignment_status_types past,

Line 525: per_all_people_f peo1,

521: cursor csr_check_cont_emp(p_person_id number,p_tax_ref varchar2) is
522: select min(paaf.EFFECTIVE_START_DATE) , max(paaf1.EFFECTIVE_END_DATE) , max(paaf.assignment_id) l_prev_asg_id
523: from
524: per_all_people_f peo,
525: per_all_people_f peo1,
526: per_all_assignments_f paaf,
527: per_all_assignments_f paaf1,
528: per_assignment_status_types past,
529: per_assignment_status_types past1,

Line 1073: l_employee_number per_all_people_f.employee_number%TYPE;

1069:
1070: l_proc CONSTANT VARCHAR2(50):= g_package||'person_addr_validations';
1071: l_ovn number;
1072: l_action_id number;
1073: l_employee_number per_all_people_f.employee_number%TYPE;
1074:
1075:
1076: l_assignment_number per_assignments_f.assignment_number%TYPE;
1077:

Line 1135: SELECT DISTINCT employee_number into l_employee_number from per_all_people_f where EMPLOYEE_NUMBER IS NOT NULL AND person_id=p_tab_rec_data(0).person_id

1131: l_year2 := to_number(to_char(l_date_of_birth,'YYYY'));
1132: l_year1 := l_year1- l_year2;
1133:
1134: --address validation
1135: SELECT DISTINCT employee_number into l_employee_number from per_all_people_f where EMPLOYEE_NUMBER IS NOT NULL AND person_id=p_tab_rec_data(0).person_id
1136: and p_effective_date between effective_start_date and effective_end_date; -- added for bug fix# 16456256
1137:
1138:
1139: IF l_address_line1 = ' ' OR l_address_line1 IS NULL THEN

Line 1633: 'from per_all_people_f ppf, '||

1629:
1630: IF l_report_type = 'RTI_EAS_REP' THEN
1631:
1632: sqlstr := 'select distinct person_id '||
1633: 'from per_all_people_f ppf, '||
1634: 'pay_payroll_actions ppa '||
1635: 'where ppa.payroll_action_id = :payroll_action_id '||
1636: 'and ppa.business_group_id = ppf.business_group_id '||
1637: 'order by ppf.person_id';

Line 1669: 'from per_all_people_f ppf, '||

1665: hr_utility.trace(' Employee ID : '||l_employee_number);
1666:
1667: IF (l_payroll_id is null) THEN
1668: sqlstr := 'select distinct person_id '||
1669: 'from per_all_people_f ppf, '||
1670: 'pay_payroll_actions ppa '||
1671: 'where ppa.payroll_action_id = :payroll_action_id '||
1672: 'and ppa.business_group_id = ppf.business_group_id '||
1673: 'order by ppf.person_id';

Line 1691: 'from per_all_people_f ppf, '||

1687: END IF;
1688:
1689: IF (l_employee_number is not null ) THEN
1690: sqlstr := 'select distinct ppf.person_id '||
1691: 'from per_all_people_f ppf, '||
1692: 'per_all_assignments_f paaf, '||
1693: 'pay_payroll_actions ppa '||
1694: 'where ppa.payroll_action_id = :payroll_action_id '||
1695: ' and paaf.person_id=ppf.person_id '||

Line 1705: 'from per_all_people_f ppf, '||

1701:
1702: IF (l_assignment_set is not null)THEN
1703:
1704: sqlstr := 'select distinct person_id '||
1705: 'from per_all_people_f ppf, '||
1706: 'pay_payroll_actions ppa '||
1707: 'where ppa.payroll_action_id = :payroll_action_id '||
1708: 'and ppa.business_group_id = ppf.business_group_id '||
1709: 'order by ppf.person_id';

Line 1775: from per_all_people_f pap,

1771: -- Cursor to fetch Active Assignments
1772: cursor csr_asg_active is
1773: select distinct asg.assignment_id assignment_id,trim(asg.primary_flag) asg_primary_flag,trim(pap.per_information10) per_agg_flag,
1774: pap.person_id person_id,past.per_system_status status
1775: from per_all_people_f pap,
1776: per_all_assignments_f asg,
1777: per_assignment_status_types past,
1778: per_periods_of_service serv,
1779: pay_all_payrolls_f pay,

Line 1807: from per_all_people_f pap,

1803: --Cursor to fetch Terminated Employees
1804: cursor csr_asg_terminated is
1805: select distinct asg.assignment_id assignment_id,trim(asg.primary_flag) asg_primary_flag,
1806: pap.person_id person_id, serv.actual_termination_date actual_termination_date
1807: from per_all_people_f pap,
1808: per_all_assignments_f asg,
1809: per_periods_of_service serv,
1810: pay_all_payrolls_f pay,
1811: hr_soft_coding_keyflex sck

Line 1823: per_all_people_f pap2

1819: and pay.soft_coding_keyflex_id = sck.soft_coding_keyflex_id
1820: and upper(l_tax_ref) = upper(sck.segment1)
1821: and pap.effective_start_date =
1822: ( select max(pap2.effective_start_date) from
1823: per_all_people_f pap2
1824: where pap2.person_id = pap.person_id
1825: and pap2.effective_start_date <= l_effective_date
1826: )
1827: and asg.effective_start_date =

Line 1842: select per_information10 per_agg_flag from per_all_people_f

1838: order by person_id,assignment_id;
1839:
1840: -- Cursor to fetch Agg Flag for a Person
1841: cursor csr_get_agg_flag (p_person_id number) is
1842: select per_information10 per_agg_flag from per_all_people_f
1843: where PERSON_ID = p_person_id
1844: and l_effective_date between effective_start_date and effective_end_date;
1845:
1846: cursor csr_find_next_asg(p_person_id number,p_assignment_id number) is

Line 1848: from per_all_people_f peo,

1844: and l_effective_date between effective_start_date and effective_end_date;
1845:
1846: cursor csr_find_next_asg(p_person_id number,p_assignment_id number) is
1847: select paaf.assignment_id
1848: from per_all_people_f peo,
1849: per_all_assignments_f paaf,
1850: per_all_assignments_f paaf1,
1851: per_assignment_status_types past,
1852: per_assignment_status_types past1,

Line 2063: from per_all_people_f pap,

2059:
2060: cursor csr_asg is
2061: select distinct asg.assignment_id assignment_id,trim(asg.primary_flag) asg_primary_flag,trim(pap.per_information10) per_agg_flag,
2062: pap.person_id person_id,asg.effective_start_date effective_start_date
2063: from per_all_people_f pap,
2064: per_all_assignments_f asg,
2065: per_periods_of_service serv,
2066: pay_all_payrolls_f pay,
2067: hr_soft_coding_keyflex sck,

Line 2881: per_all_people_f pap

2877: paa.EFFECTIVE_END_DATE end_date, --to_char(paa.EFFECTIVE_END_DATE,'DD-MON-RRRR') end_date
2878: pap.person_id
2879: from per_all_assignments_f paa,
2880: per_assignment_status_types past,
2881: per_all_people_f pap
2882: where paa.person_id = pap.person_id
2883: and paa.assignment_id = c_assignment_id
2884: and past.ASSIGNMENT_STATUS_TYPE_ID = paa.ASSIGNMENT_STATUS_TYPE_ID
2885: and past.per_system_status in ('ACTIVE_ASSIGN', 'SUSP_ASSIGN') -- Added for Bug#13626488

Line 2901: per_all_people_f pap

2897: paa.EFFECTIVE_END_DATE end_date, --to_char(paa.EFFECTIVE_END_DATE,'DD-MON-RRRR') end_date
2898: pap.person_id
2899: from per_all_assignments_f paa,
2900: per_assignment_status_types past,
2901: per_all_people_f pap
2902: ,pay_payroll_actions ppa
2903: where paa.person_id = pap.person_id
2904: and paa.assignment_id = c_assignment_id
2905: and past.ASSIGNMENT_STATUS_TYPE_ID = paa.ASSIGNMENT_STATUS_TYPE_ID

Line 2932: per_all_people_f pap

2928: paa.EFFECTIVE_END_DATE end_date, --to_char(paa.EFFECTIVE_END_DATE,'DD-MON-RRRR') end_date
2929: pap.person_id
2930: from per_all_assignments_f paa,
2931: per_assignment_status_types past,
2932: per_all_people_f pap
2933: where paa.person_id = pap.person_id
2934: and paa.assignment_id = c_assignment_id
2935: and past.ASSIGNMENT_STATUS_TYPE_ID = paa.ASSIGNMENT_STATUS_TYPE_ID
2936: and past.per_system_status in ('ACTIVE_ASSIGN', 'SUSP_ASSIGN')