APPS.PER_GB_TAX_BEN_PKG dependencies on PER_PERIODS_OF_SERVICE

Line 422: l_start_date per_periods_of_service.date_start%TYPE := NULL;

418: l_field_number NUMBER := 0;
419: l_line VARCHAR2 (4000) := p_line;
420: l_id_type VARCHAR2 (30) := NULL;
421: l_id VARCHAR2 (30) := NULL;
422: l_start_date per_periods_of_service.date_start%TYPE := NULL;
423: l_final_process_date per_periods_of_service.final_process_date%TYPE
424: := NULL;
425: BEGIN
426: hr_utility.set_location ( 'Entering:'

Line 423: l_final_process_date per_periods_of_service.final_process_date%TYPE

419: l_line VARCHAR2 (4000) := p_line;
420: l_id_type VARCHAR2 (30) := NULL;
421: l_id VARCHAR2 (30) := NULL;
422: l_start_date per_periods_of_service.date_start%TYPE := NULL;
423: l_final_process_date per_periods_of_service.final_process_date%TYPE
424: := NULL;
425: BEGIN
426: hr_utility.set_location ( 'Entering:'
427: || l_proc, 10);

Line 1432: p_start_date OUT NOCOPY per_periods_of_service.date_start%TYPE,

1428: p_id IN VARCHAR2,
1429: p_effective_date IN DATE,
1430: p_assg_id OUT NOCOPY per_all_assignments_f.assignment_id%TYPE,
1431: p_assg_nr OUT NOCOPY per_all_assignments_f.assignment_number%TYPE,
1432: p_start_date OUT NOCOPY per_periods_of_service.date_start%TYPE,
1433: p_final_process_date OUT NOCOPY per_periods_of_service.final_process_date%TYPE
1434: )
1435: IS
1436: -- Procedure name

Line 1433: p_final_process_date OUT NOCOPY per_periods_of_service.final_process_date%TYPE

1429: p_effective_date IN DATE,
1430: p_assg_id OUT NOCOPY per_all_assignments_f.assignment_id%TYPE,
1431: p_assg_nr OUT NOCOPY per_all_assignments_f.assignment_number%TYPE,
1432: p_start_date OUT NOCOPY per_periods_of_service.date_start%TYPE,
1433: p_final_process_date OUT NOCOPY per_periods_of_service.final_process_date%TYPE
1434: )
1435: IS
1436: -- Procedure name
1437: l_proc CONSTANT VARCHAR2 (72) := g_package

Line 1446: FROM per_all_assignments_f paa, per_periods_of_service pos

1442: v_effective_date DATE
1443: )
1444: IS
1445: SELECT paa.assignment_number, pos.date_start, pos.final_process_date
1446: FROM per_all_assignments_f paa, per_periods_of_service pos
1447: WHERE paa.assignment_id = v_assg_id
1448: AND paa.period_of_service_id = pos.period_of_service_id
1449: AND v_effective_date BETWEEN paa.effective_start_date
1450: AND paa.effective_end_date;

Line 1460: FROM per_all_assignments_f paa, per_periods_of_service pos

1456: v_effective_date DATE
1457: )
1458: IS
1459: SELECT paa.assignment_id, pos.date_start, pos.final_process_date
1460: FROM per_all_assignments_f paa, per_periods_of_service pos
1461: WHERE paa.assignment_number = v_assg_nr
1462: AND paa.period_of_service_id = pos.period_of_service_id
1463: AND v_effective_date BETWEEN paa.effective_start_date
1464: AND paa.effective_end_date

Line 1475: FROM per_all_assignments_f paa, per_periods_of_service pos

1471: )
1472: IS
1473: SELECT paa.assignment_number, paa.assignment_id, pos.date_start,
1474: pos.final_process_date
1475: FROM per_all_assignments_f paa, per_periods_of_service pos
1476: WHERE paa.person_id = v_person_id
1477: AND paa.period_of_service_id = pos.period_of_service_id
1478: AND v_effective_date BETWEEN paa.effective_start_date
1479: AND paa.effective_end_date

Line 1493: per_periods_of_service pos

1489: SELECT paa.assignment_number, paa.assignment_id, pos.date_start,
1490: pos.final_process_date
1491: FROM per_all_assignments_f paa,
1492: per_all_people_f pap,
1493: per_periods_of_service pos
1494: WHERE pap.employee_number = v_empl_nr
1495: AND pap.person_id = paa.person_id
1496: AND paa.period_of_service_id = pos.period_of_service_id
1497: AND v_effective_date BETWEEN paa.effective_start_date

Line 1515: per_periods_of_service pos

1511: paa.assignment_number, paa.assignment_id, pos.date_start,
1512: pos.final_process_date
1513: FROM per_all_people_f pap,
1514: per_all_assignments_f paa,
1515: per_periods_of_service pos
1516: WHERE pap.national_identifier = v_ni_nr
1517: AND pap.business_group_id = v_bg_id
1518: AND pap.person_id = paa.person_id
1519: AND paa.period_of_service_id = pos.period_of_service_id

Line 1529: l_dt_start per_periods_of_service.date_start%TYPE := NULL;

1525: AND paa.primary_flag = 'Y';
1526:
1527: l_assg_nr per_all_assignments_f.assignment_number%TYPE := NULL;
1528: l_assg_id per_all_assignments_f.assignment_id%TYPE := NULL;
1529: l_dt_start per_periods_of_service.date_start%TYPE := NULL;
1530: l_finproc_dt per_periods_of_service.final_process_date%TYPE
1531: := NULL;
1532: BEGIN
1533: hr_utility.set_location ( 'Entering:'

Line 1530: l_finproc_dt per_periods_of_service.final_process_date%TYPE

1526:
1527: l_assg_nr per_all_assignments_f.assignment_number%TYPE := NULL;
1528: l_assg_id per_all_assignments_f.assignment_id%TYPE := NULL;
1529: l_dt_start per_periods_of_service.date_start%TYPE := NULL;
1530: l_finproc_dt per_periods_of_service.final_process_date%TYPE
1531: := NULL;
1532: BEGIN
1533: hr_utility.set_location ( 'Entering:'
1534: || l_proc, 10);