APPS.PER_PEOPLE_V7_PKG dependencies on PER_PERIODS_OF_SERVICE

Line 727: from per_periods_of_service

723:
724: cursor period
725: is
726: select actual_termination_date
727: from per_periods_of_service
728: where period_of_service_id = X_period_of_service_id
729: for update of actual_termination_date;
730: --
731: cursor assignment

Line 777: from per_periods_of_service

773: -- END WWBUG 1390173 fix
774: --
775: cursor c1 is
776: select *
777: from per_periods_of_service
778: where period_of_service_id = x_period_of_service_id;
779: --
780: l_c1 c1%rowtype;
781: --

Line 848: update per_periods_of_service

844: --
845: --END HR/WF Synchronization --tpapired
846: --
847: begin
848: update per_periods_of_service
849: set actual_termination_date = X_termination_date
850: , final_process_date = X_termination_date
851: , last_standard_process_date = X_termination_date
852: where period_of_service_id = X_period_of_service_id;

Line 1041: from per_periods_of_service

1037: ,X_s_hire_date DATE) IS
1038: --
1039: cursor period is
1040: select date_start
1041: from per_periods_of_service
1042: where period_of_service_id = X_period_of_service_id
1043: for update of date_start;
1044: --
1045: cursor assignment is

Line 1071: from per_periods_of_service

1067: -- END WWBUG 1390173 fix
1068: --
1069: cursor c1 is
1070: select *
1071: from per_periods_of_service
1072: where period_of_service_id = x_period_of_service_id
1073: and date_start = x_s_hire_date;
1074: --
1075: -- Fix for WWBUG 1408379

Line 1151: update per_periods_of_service

1147: --
1148: -- END WWBUG 1390173 fix
1149: --
1150: --
1151: update per_periods_of_service
1152: set date_start = X_hire_date
1153: where period_of_service_id = X_period_of_service_id
1154: and date_start = X_s_hire_date;
1155: -- VT 01/29/97 #417906 added exception

Line 1318: from per_periods_of_service

1314: for update of effective_start_date;
1315: --
1316: cursor period is
1317: select date_start, business_group_id
1318: from per_periods_of_service
1319: where Period_of_service_Id = X_Period_of_service_Id
1320: and date_start = X_S_Hire_Date
1321: and actual_termination_date is null
1322: for update of date_start;

Line 1350: from per_periods_of_service

1346: and phone_type = 'W1';
1347: --
1348: cursor csr_latestATD(cp_date_start date) is
1349: select max(actual_termination_date)
1350: from per_periods_of_service
1351: where date_start < cp_date_start
1352: and person_id = X_person_id;
1353: --
1354: cursor csr_person(cp_date DATE, cp_bg_id NUMBER) is

Line 1560: update per_periods_of_service

1556: END IF;
1557:
1558: if l_date_start is not null then
1559: --
1560: update per_periods_of_service
1561: set date_start = X_Hire_Date
1562: where Period_of_service_Id = X_Period_of_service_Id
1563: and date_start = X_S_Hire_Date
1564: and actual_termination_date is null;

Line 1621: from per_periods_of_service

1617: --
1618: --START HR/WF Synchronization --tpapired
1619: cursor l_pds_cur is
1620: select *
1621: from per_periods_of_service
1622: where person_id = x_person_id
1623: and rownum = 1;
1624: l_pds_rec l_pds_cur%rowtype;
1625:

Line 1631: from per_periods_of_service

1627: --
1628: cursor period
1629: is
1630: select actual_termination_date
1631: from per_periods_of_service
1632: where period_of_service_id = X_period_of_service_id
1633: for update of actual_termination_date;
1634: --
1635: l_dummy_date VARCHAR2(30);

Line 1680: update per_periods_of_service

1676: open period;
1677: loop
1678: fetch period into l_dummy_date;
1679: exit when period%NOTFOUND;
1680: update per_periods_of_service
1681: set actual_termination_date = null
1682: , last_standard_process_date = null
1683: , final_process_date = null
1684: where current of period;

Line 1838: from per_periods_of_service

1834: per_all_rec c_all_person%rowtype;
1835: --START HR/WF Synchronization --tpapired
1836: cursor l_pds_cur is
1837: select *
1838: from per_periods_of_service
1839: where person_id = x_person_id
1840: and rownum = 1;
1841: l_pds_rec l_pds_cur%rowtype;
1842:

Line 1911: if (per_periods_of_service_pkg_v2.IsBackToBackContract

1907:
1908: --
1909: -- Start of Fix for Bug 2438403
1910: --
1911: if (per_periods_of_service_pkg_v2.IsBackToBackContract
1912: (p_person_id => X_Person_Id,
1913: p_hire_date_of_current_pds => X_HIRE_DATE)) then
1914:
1915: IF g_debug THEN

Line 2389: , per_periods_of_service pos

2385: cursor check_assignment_changes
2386: is
2387: select assignment_id
2388: from per_assignments_f paf
2389: , per_periods_of_service pos
2390: where paf.person_id = pos.person_id
2391: and paf.period_of_service_id = pos.period_of_service_id
2392: and pos.date_start = p_s_hire_date
2393: and pos.person_id = p_person_id;