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.PER_ASG_AGGR dependencies on PER_ALL_PEOPLE_F

Line 46: from per_all_people_f

42: -- Changed the cursor to fecth PAYE agg flag effective end date
43: cursor cur_get_aggr_flag(c_person_id in number,
44: c_effective_date in date) is
45: select per_information10,effective_end_date
46: from per_all_people_f
47: where person_id = c_person_id
48: and c_effective_date between effective_start_date and effective_end_date;
49: -- End of Bug 5671777-9
50:

Line 55: per_all_people_f ppf

51: cursor cur_person_type (c_person_id in number,
52: c_effective_date in date) is
53: select typ.system_person_type
54: from per_person_types typ,
55: per_all_people_f ppf
56: where ppf.person_id = c_person_id
57: and ppf.person_type_id = typ.person_type_id
58: and c_effective_date between
59: ppf.effective_start_date and ppf.effective_end_date;

Line 415: from per_all_people_f

411:
412: --Cursor to find out the NI flag status in previous date track record
413: CURSOR csr_prev_ni_flag IS
414: SELECT per_information9
415: from per_all_people_f
416: WHERE person_id = p_person_id
417: AND effective_end_date=p_cur_effective_start_date-1;
418:
419: --Cursor to find out the future NI aggregations after the current date range

Line 422: FROM per_all_people_f

418:
419: --Cursor to find out the future NI aggregations after the current date range
420: CURSOR csr_fut_ni_flag IS
421: SELECT count(*)
422: FROM per_all_people_f
423: WHERE person_id = p_person_id
424: AND effective_start_date > p_effective_date
425: AND nvl(per_information9,'N')='N';
426:

Line 526: l_cur_paye_agg_flag per_all_people_f.per_information10%type;

522:
523: -- Start of bug#8370225
524: l_effective_date date;
525: l_cur_agg_paye_flag per_assignment_status_types.per_system_status%type;
526: l_cur_paye_agg_flag per_all_people_f.per_information10%type;
527: l_curr_ni_agg_flag per_all_people_f.per_information9%type;
528: l_cur_effective_start_date date;
529: l_cur_effective_end_date date;
530: l_earliest_tax_year date;

Line 527: l_curr_ni_agg_flag per_all_people_f.per_information9%type;

523: -- Start of bug#8370225
524: l_effective_date date;
525: l_cur_agg_paye_flag per_assignment_status_types.per_system_status%type;
526: l_cur_paye_agg_flag per_all_people_f.per_information10%type;
527: l_curr_ni_agg_flag per_all_people_f.per_information9%type;
528: l_cur_effective_start_date date;
529: l_cur_effective_end_date date;
530: l_earliest_tax_year date;
531: l_latest_tax_year date;

Line 541: l_prev_agg_paye_flag per_all_people_f.per_information10%type;

537: l_tax_pay_per_td_cpe_ytd_dfbid number;
538: l_paye_asg_td_ytd_dfbid number;
539: l_paye_per_td_cpe_ytd_dfbid number;
540: l_term_asg_found number;
541: l_prev_agg_paye_flag per_all_people_f.per_information10%type;
542: l_prev_effective_start_date date;
543: l_profile_value varchar2(30);
544: L_LOCAL_DATE_TRACE_MODE varchar2(30);
545:

Line 551: from per_all_people_f a

547: -- Cursor to fetch PAYE agg flag details
548: --
549: cursor cur_person_details(c_person_id number, c_effective_date date) IS
550: select a.per_information10, a.per_information9, a.effective_start_date,a.effective_end_date
551: from per_all_people_f a
552: where a.person_id = c_person_id
553: and c_effective_date between a.effective_start_date and a.effective_end_date;
554:
555: --

Line 640: from per_all_people_f a

636: -- to fetch the agg paye flag from person details
637: --
638: cursor cur_person_dtls(c_person_id number, c_effective_date date) IS
639: select a.per_information10, a.effective_start_date
640: from per_all_people_f a
641: where a.person_id = c_person_id
642: and c_effective_date between a.effective_start_date and a.effective_end_date;
643:
644: --

Line 955: from per_all_people_f

951: /* Cursor to identify if PAYE flag is set or not */
952: cursor cur_get_aggr_flag(c_person_id in number,
953: c_effective_date in date) is
954: select per_information10, object_version_number, employee_number
955: from per_all_people_f
956: where person_id = c_person_id
957: and c_effective_date between effective_start_date and effective_end_date;
958:
959: /* Cursor to identify if NI flag is set or not */

Line 963: from per_all_people_f

959: /* Cursor to identify if NI flag is set or not */
960: cursor cur_get_ni_aggr_flag(c_person_id in number,
961: c_effective_date in date) is
962: select per_information9
963: from per_all_people_f
964: where person_id = c_person_id
965: and c_effective_date between effective_start_date and effective_end_date;
966:
967: /* Get date track records from per_all_people_f, including and after effective date*/

Line 967: /* Get date track records from per_all_people_f, including and after effective date*/

963: from per_all_people_f
964: where person_id = c_person_id
965: and c_effective_date between effective_start_date and effective_end_date;
966:
967: /* Get date track records from per_all_people_f, including and after effective date*/
968: cursor people_dt_records(c_person_id in number,
969: c_effective_date in date) is
970: select person_id, effective_start_date, effective_end_date,
971: per_information9, per_information10, full_name, object_version_number

Line 972: from per_all_people_f

968: cursor people_dt_records(c_person_id in number,
969: c_effective_date in date) is
970: select person_id, effective_start_date, effective_end_date,
971: per_information9, per_information10, full_name, object_version_number
972: from per_all_people_f
973: where person_id=c_person_id
974: and effective_end_date >= c_effective_date
975: order by effective_start_date;
976:

Line 1119: /* Get date track records from per_all_people_f, including and after effective date*/

1115: AND ppa.action_status='C'
1116: AND paact.source_action_id IS NOT NULL
1117: AND ppa.effective_date BETWEEN p_effective_start_date AND p_effective_end_date;
1118:
1119: /* Get date track records from per_all_people_f, including and after effective date*/
1120: --Modified the Cursor to fetch Employee_number for the Bug 13323723
1121: CURSOR people_dt_records_desc(c_person_id IN NUMBER, c_effective_date IN DATE)
1122: IS
1123: SELECT person_id,

Line 1131: FROM per_all_people_f

1127: per_information9,
1128: per_information10,
1129: full_name,
1130: object_version_number
1131: FROM per_all_people_f
1132: WHERE person_id =c_person_id
1133: AND effective_end_date >= c_effective_date
1134: ORDER BY effective_start_date desc;
1135:

Line 1156: l_full_name per_all_people_f.full_name%type;

1152:
1153: l_pers_dt_mode varchar2(30);
1154: l_effective_start_date date;
1155: l_effective_end_date date;
1156: l_full_name per_all_people_f.full_name%type;
1157: l_comment_id per_all_people_f.comment_id%type;
1158: l_name_combination_warning boolean;
1159: l_assign_payroll_warning boolean;
1160: l_orig_hire_warning boolean;

Line 1157: l_comment_id per_all_people_f.comment_id%type;

1153: l_pers_dt_mode varchar2(30);
1154: l_effective_start_date date;
1155: l_effective_end_date date;
1156: l_full_name per_all_people_f.full_name%type;
1157: l_comment_id per_all_people_f.comment_id%type;
1158: l_name_combination_warning boolean;
1159: l_assign_payroll_warning boolean;
1160: l_orig_hire_warning boolean;
1161:

Line 1228: END LOOP; -- Records in per_all_people_f which need to be updated.

1224: ,p_comment_id => l_comment_id
1225: ,p_name_combination_warning => l_name_combination_warning
1226: ,p_assign_payroll_warning => l_assign_payroll_warning
1227: ,p_orig_hire_warning => l_orig_hire_warning );
1228: END LOOP; -- Records in per_all_people_f which need to be updated.
1229: hr_utility.set_location(l_proc, 90);
1230: ELSE
1231: hr_utility.set_location(l_proc, 95);
1232: G_VALIDATION_FAILURE := true;

Line 1396: end loop; -- Records in per_all_people_f which need to be updated.

1392:
1393: /* Reset/change the variable */
1394: l_person_effective_date := rec.effective_start_date;
1395:
1396: end loop; -- Records in per_all_people_f which need to be updated.
1397:
1398: hr_utility.set_location(l_proc, 90);
1399: end if; -- If secondary assignment
1400: end if; -- PAYE Agg not set already

Line 1451: (p_person_id IN per_all_people_f.person_id%TYPE

1447:
1448:
1449: /*Code changes for RTI Payroll Id Population Post DML Calls*/
1450: FUNCTION check_for_active_emp
1451: (p_person_id IN per_all_people_f.person_id%TYPE
1452: ,p_effective_date IN date) RETURN number IS
1453: var number;
1454: BEGIN
1455: SELECT 1

Line 1457: FROM per_all_people_f pap

1453: var number;
1454: BEGIN
1455: SELECT 1
1456: INTO var
1457: FROM per_all_people_f pap
1458: ,per_person_types ppt
1459: WHERE p_effective_date BETWEEN pap.effective_start_date
1460: AND pap.effective_end_date
1461: AND pap.person_id = p_person_id

Line 1579: per_all_people_f pap,

1575:
1576: cursor csr_primary_exists is
1577: select paf.assignment_id
1578: from
1579: per_all_people_f pap,
1580: per_all_assignments_f paf
1581: where paf.person_id = pap.person_id
1582: and paf.person_id = p_person_id
1583: and p_effective_date between paf.effective_start_date and paf.effective_end_date

Line 1590: per_all_people_f pap,

1586:
1587: cursor csr_primary_in_curr_paye is
1588: select paf.assignment_id
1589: from
1590: per_all_people_f pap,
1591: per_all_assignments_f paf,
1592: pay_all_payrolls_f pay,
1593: hr_soft_coding_keyflex hsc
1594: where paf.person_id = pap.person_id

Line 1627: FROM per_all_people_f pap

1623: ,'N') primary_flag
1624: INTO v_per_agg_flag
1625: ,v_per_ni_flag
1626: ,v_primary_flag
1627: FROM per_all_people_f pap
1628: ,per_all_assignments_f paf
1629: WHERE paf.person_id = pap.person_id
1630: AND paf.assignment_id = p_assignment_id
1631: AND p_effective_date BETWEEN paf.effective_start_date

Line 1680: (p_person_id IN per_all_people_f.person_id%TYPE

1676: RETURN l_ni_reporting_flag;
1677: END get_ni_reporting_flag;
1678:
1679: FUNCTION get_rti_payroll_id
1680: (p_person_id IN per_all_people_f.person_id%TYPE
1681: ,p_assignment_id IN per_all_assignments_f.assignment_id%type
1682: ,p_aggregation_flag IN varchar2
1683: ,p_effective_date IN date) RETURN varchar2 IS
1684: v_rti_payroll_id varchar2(30);

Line 1729: (p_person_id IN per_all_people_f.person_id%TYPE

1725:
1726: END update_rti_agg_update_asg;
1727:
1728: PROCEDURE update_rti_agg_new_person
1729: (p_person_id IN per_all_people_f.person_id%TYPE
1730: ,p_hire_date IN date) IS
1731: BEGIN
1732: per_asg_aggr.update_rti_agg_person
1733: (p_person_id => p_person_id

Line 1738: (p_person_id IN per_all_people_f.person_id%TYPE

1734: ,p_effective_date => p_hire_date);
1735: END update_rti_agg_new_person;
1736:
1737: PROCEDURE update_rti_agg_person
1738: (p_person_id IN per_all_people_f.person_id%TYPE
1739: ,p_effective_date IN date) IS
1740: CURSOR csr_ni_paye_flag IS
1741: SELECT trim (pap.per_information10) per_agg_flag
1742: ,trim (pap.per_information9) per_ni_flag

Line 1743: FROM per_all_people_f pap

1739: ,p_effective_date IN date) IS
1740: CURSOR csr_ni_paye_flag IS
1741: SELECT trim (pap.per_information10) per_agg_flag
1742: ,trim (pap.per_information9) per_ni_flag
1743: FROM per_all_people_f pap
1744: WHERE pap.person_id = p_person_id
1745: AND p_effective_date BETWEEN pap.effective_start_date
1746: AND pap.effective_end_date;
1747:

Line 1784: FROM per_all_people_f pap

1780: AND paf.effective_start_date BETWEEN paaf2.effective_start_date
1781: AND paaf2.effective_end_date)
1782: ) primary_assignment_number
1783: ,hsck.segment1 paye_reference
1784: FROM per_all_people_f pap
1785: ,per_all_assignments_f paf
1786: ,pay_all_payrolls_f papf
1787: ,hr_soft_coding_keyflex hsck
1788: WHERE paf.person_id = pap.person_id

Line 1796: FROM per_all_people_f papf2

1792: AND paf.assignment_type = 'E'
1793: AND pap.effective_start_date =
1794: (
1795: SELECT MAX(papf2.effective_start_date)
1796: FROM per_all_people_f papf2
1797: WHERE papf2.person_id = pap.person_id
1798: )
1799: AND paf.effective_start_date =
1800: (

Line 1816: ,per_all_people_f papf

1812: ,paaf.assignment_number
1813: ,paaf.business_group_id
1814: ,trim (papf.per_information9)
1815: from per_all_assignments_f paaf
1816: ,per_all_people_f papf
1817: where paaf.person_id = p_person_id
1818: and papf.person_id = paaf.person_id
1819: AND p_effective_date BETWEEN paaf.effective_start_date
1820: AND paaf.effective_end_date

Line 1989: procedure update_asg_rti_starter_flag(p_person_id IN per_all_people_f.person_id%TYPE,

1985:
1986:
1987: END update_rti_agg_person;
1988: --
1989: procedure update_asg_rti_starter_flag(p_person_id IN per_all_people_f.person_id%TYPE,
1990: p_effective_date IN DATE)
1991: is
1992:
1993: CURSOR csr_get_all_asg(p_business_group_id NUMBER)

Line 2017: from per_all_people_f

2013: CURSOR csr_per_agg_flag
2014: is
2015: select per_information10 per_agg_flag
2016: ,business_group_id business_group_id
2017: from per_all_people_f
2018: where person_id = p_person_id
2019: and p_effective_date between effective_start_date and effective_end_date;
2020:
2021: --Fetches the assignment_id of the person within the same paye_ref