APPS.PAY_KR_BEE_UPLOAD dependencies on PER_PERIODS_OF_SERVICE

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

616: l_field_number NUMBER := 0;
617: l_line VARCHAR2 (4000) := p_line;
618: l_id_type VARCHAR2 (30) := NULL;
619: l_id VARCHAR2 (30) := NULL;
620: l_start_date per_periods_of_service.date_start%TYPE := NULL;
621: l_final_process_date per_periods_of_service.final_process_date%TYPE := NULL;
622:
623:
624: BEGIN

Line 621: l_final_process_date per_periods_of_service.final_process_date%TYPE := NULL;

617: l_line VARCHAR2 (4000) := p_line;
618: l_id_type VARCHAR2 (30) := NULL;
619: l_id VARCHAR2 (30) := NULL;
620: l_start_date per_periods_of_service.date_start%TYPE := NULL;
621: l_final_process_date per_periods_of_service.final_process_date%TYPE := NULL;
622:
623:
624: BEGIN
625: hr_utility.set_location ( 'Entering:'|| l_proc, 10);

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

1569: p_id IN VARCHAR2,
1570: p_effective_date IN DATE,
1571: p_assg_id OUT NOCOPY per_assignments_f.assignment_id%TYPE,
1572: p_assg_nr OUT NOCOPY per_assignments_f.assignment_number%TYPE,
1573: p_start_date OUT NOCOPY per_periods_of_service.date_start%TYPE,
1574: p_final_process_date OUT NOCOPY per_periods_of_service.final_process_date%TYPE
1575: )
1576: IS
1577: -- Procedure name

Line 1574: p_final_process_date OUT NOCOPY per_periods_of_service.final_process_date%TYPE

1570: p_effective_date IN DATE,
1571: p_assg_id OUT NOCOPY per_assignments_f.assignment_id%TYPE,
1572: p_assg_nr OUT NOCOPY per_assignments_f.assignment_number%TYPE,
1573: p_start_date OUT NOCOPY per_periods_of_service.date_start%TYPE,
1574: p_final_process_date OUT NOCOPY per_periods_of_service.final_process_date%TYPE
1575: )
1576: IS
1577: -- Procedure name
1578: l_proc CONSTANT VARCHAR2 (72) := g_package|| 'get_assignment_info';

Line 1589: per_periods_of_service pos

1585: SELECT paa.assignment_number,
1586: pos.date_start,
1587: pos.final_process_date
1588: FROM per_assignments_f paa,
1589: per_periods_of_service pos
1590: WHERE paa.assignment_id = v_assg_id
1591: AND paa.period_of_service_id = pos.period_of_service_id
1592: AND v_effective_date BETWEEN paa.effective_start_date
1593: AND paa.effective_end_date;

Line 1608: per_periods_of_service pos

1604: paa.assignment_id,
1605: pos.date_start,
1606: pos.final_process_date
1607: FROM per_assignments_f paa,
1608: per_periods_of_service pos
1609: WHERE paa.person_id = v_person_id
1610: AND paa.period_of_service_id = pos.period_of_service_id
1611: AND v_effective_date BETWEEN paa.effective_start_date
1612: AND paa.effective_end_date

Line 1628: per_periods_of_service pos

1624: pos.date_start,
1625: pos.final_process_date
1626: FROM per_assignments_f paa,
1627: per_people_f pap,
1628: per_periods_of_service pos
1629: WHERE pap.employee_number = v_empl_nr
1630: AND pap.person_id = paa.person_id
1631: AND paa.period_of_service_id = pos.period_of_service_id
1632: AND v_effective_date BETWEEN paa.effective_start_date

Line 1651: per_periods_of_service pos

1647: pos.date_start,
1648: pos.final_process_date
1649: FROM per_assignments_f paa,
1650: per_people_f pap,
1651: per_periods_of_service pos
1652: WHERE pap.national_identifier = v_ni_nr
1653: AND pap.person_id = paa.person_id
1654: AND paa.period_of_service_id = pos.period_of_service_id
1655: AND v_effective_date BETWEEN paa.effective_start_date

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

1660: AND paa.primary_flag = 'Y';
1661:
1662: l_assg_nr per_assignments_f.assignment_number%TYPE := NULL;
1663: l_assg_id per_assignments_f.assignment_id%TYPE := NULL;
1664: l_dt_start per_periods_of_service.date_start%TYPE := NULL;
1665: l_finproc_dt per_periods_of_service.final_process_date%TYPE
1666: := NULL;
1667: BEGIN
1668: hr_utility.set_location ( 'Entering:'

Line 1665: l_finproc_dt per_periods_of_service.final_process_date%TYPE

1661:
1662: l_assg_nr per_assignments_f.assignment_number%TYPE := NULL;
1663: l_assg_id per_assignments_f.assignment_id%TYPE := NULL;
1664: l_dt_start per_periods_of_service.date_start%TYPE := NULL;
1665: l_finproc_dt per_periods_of_service.final_process_date%TYPE
1666: := NULL;
1667: BEGIN
1668: hr_utility.set_location ( 'Entering:'
1669: || l_proc, 10);