APPS.PER_ASSIGNMENTS_F_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 140: l_asg_rec per_all_assignments_f%rowtype;

136: l_labour_union_member_flag varchar2(1); -- bug fix 7698212
137: --
138: /*
139: --WWBUG 2130950 Begin hrwf synchronization --tpapired
140: l_asg_rec per_all_assignments_f%rowtype;
141: cursor l_asg_cur is
142: select *
143: from per_all_assignments_f
144: where assignment_id = P_ASSIGNMENT_ID

Line 143: from per_all_assignments_f

139: --WWBUG 2130950 Begin hrwf synchronization --tpapired
140: l_asg_rec per_all_assignments_f%rowtype;
141: cursor l_asg_cur is
142: select *
143: from per_all_assignments_f
144: where assignment_id = P_ASSIGNMENT_ID
145: and effective_start_date = P_EFFECTIVE_START_DATE
146: and effective_end_date = P_EFFECTIVE_END_DATE;
147: --WWBUG 2130950 End hrwf synchronization -tpapired

Line 1298: l_asg_rec per_all_assignments_f%rowtype;

1294:
1295: --
1296: /*
1297: --WWBUG 2130950 Begin hrwf synchronization --tpapired
1298: l_asg_rec per_all_assignments_f%rowtype;
1299: cursor l_asg_cur is
1300: select *
1301: from per_all_assignments_f
1302: where assignment_id = P_ASSIGNMENT_ID

Line 1301: from per_all_assignments_f

1297: --WWBUG 2130950 Begin hrwf synchronization --tpapired
1298: l_asg_rec per_all_assignments_f%rowtype;
1299: cursor l_asg_cur is
1300: select *
1301: from per_all_assignments_f
1302: where assignment_id = P_ASSIGNMENT_ID
1303: and effective_start_date = P_EFFECTIVE_START_DATE
1304: and effective_end_date = P_EFFECTIVE_END_DATE;
1305: --WWBUG 2130950 End hrwf synchronization -tpapired

Line 1351: from per_all_assignments_f

1347: /* Cursor csr_get_assign added for bug#8232830 */
1348:
1349: cursor csr_get_assign(csr_person_id number) is
1350: select assignment_id
1351: from per_all_assignments_f
1352: where person_id=csr_person_id
1353: and business_group_id=p_business_group_id
1354: and trunc(sysdate) between effective_start_date and effective_end_date
1355: and assignment_type not in ('B','O');

Line 1363: from per_all_assignments_f

1359: /* Cursor csr_get_assign1 added for bug#12972634 */
1360:
1361: cursor csr_get_assign1(csr_person_id number) is
1362: select assignment_id
1363: from per_all_assignments_f
1364: where person_id=csr_person_id
1365: and business_group_id=p_business_group_id
1366: and p_effective_start_date between effective_start_date and effective_end_date
1367: and assignment_type not in ('B','O');

Line 1380: per_all_assignments_f paf

1376: l_vendor_site_id number default null;
1377:
1378: cursor po_cwk is
1379: select vendor_id,vendor_site_id from
1380: per_all_assignments_f paf
1381: where paf.assignment_id = p_assignment_id
1382: and nvl(p_session_date,sysdate) between paf.effective_start_date
1383: and paf.effective_end_date;
1384: --end code for bug 6961562

Line 1390: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

1386: --
1387: l_status VARCHAR2(50);
1388: l_change_date DATE;
1389: /* variable added for bug#8232830 */
1390: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
1391: --
1392:
1393: --- Fix For Bug # 8860141 Starts ---
1394: cursor csr_defaulting_date(p_assignment_id number) is

Line 1402: from per_all_assignments_f paa,

1398:
1399: cursor csr_defaultpayrollremoved(p_assignment_id number,
1400: p_effective_date date) is
1401: select null
1402: from per_all_assignments_f paa,
1403: pay_element_entries_f pee,
1404: pay_element_links_f pel,
1405: pay_element_types_f pet
1406: where paa.assignment_id=p_assignment_id

Line 1809: from per_all_assignments_f

1805: -- if (p_effective_start_date <= trunc(sysdate)) then -- Added for bug#10078890
1806:
1807: /* -- commented the code for fixing Bug#13496901
1808: select count(*) into l_count_get_assign
1809: from per_all_assignments_f
1810: where person_id= p_person_id
1811: and business_group_id=p_business_group_id
1812: and trunc(sysdate) between effective_start_date and effective_end_date
1813: and assignment_type not in ('B','O');