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.PAY_KR_BEE_UPLOAD dependencies on PER_ASSIGNMENTS_F

Line 1566: p_bus_group_id IN per_assignments_f.business_group_id%TYPE

1562: RETURN l_correct;
1563: END correct_type_id;
1564:
1565: PROCEDURE get_assignment_info (
1566: p_bus_group_id IN per_assignments_f.business_group_id%TYPE
1567: DEFAULT NULL,
1568: p_id_type IN VARCHAR2,
1569: p_id IN VARCHAR2,
1570: p_effective_date IN DATE,

Line 1571: p_assg_id OUT NOCOPY per_assignments_f.assignment_id%TYPE,

1567: DEFAULT NULL,
1568: p_id_type IN VARCHAR2,
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: )

Line 1572: p_assg_nr OUT NOCOPY per_assignments_f.assignment_number%TYPE,

1568: p_id_type IN VARCHAR2,
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

Line 1581: v_assg_id per_assignments_f.assignment_id%TYPE,

1577: -- Procedure name
1578: l_proc CONSTANT VARCHAR2 (72) := g_package|| 'get_assignment_info';
1579:
1580: CURSOR csr_assg_id (
1581: v_assg_id per_assignments_f.assignment_id%TYPE,
1582: v_effective_date DATE
1583: )
1584: IS
1585: SELECT paa.assignment_number,

Line 1588: FROM per_assignments_f paa,

1584: IS
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

Line 1598: v_person_id per_assignments_f.person_id%TYPE,

1594:
1595:
1596:
1597: CURSOR csr_person_id (
1598: v_person_id per_assignments_f.person_id%TYPE,
1599: v_bg_id per_assignments_f.business_group_id%TYPE,
1600: v_effective_date DATE
1601: )
1602: IS

Line 1599: v_bg_id per_assignments_f.business_group_id%TYPE,

1595:
1596:
1597: CURSOR csr_person_id (
1598: v_person_id per_assignments_f.person_id%TYPE,
1599: v_bg_id per_assignments_f.business_group_id%TYPE,
1600: v_effective_date DATE
1601: )
1602: IS
1603: SELECT paa.assignment_number,

Line 1607: FROM per_assignments_f paa,

1603: SELECT paa.assignment_number,
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

Line 1618: v_bg_id per_assignments_f.business_group_id%TYPE,

1614: AND paa.primary_flag = 'Y';
1615:
1616: CURSOR csr_empl_nr (
1617: v_empl_nr per_people_f.employee_number%TYPE,
1618: v_bg_id per_assignments_f.business_group_id%TYPE,
1619: v_effective_date DATE
1620: )
1621: IS
1622: SELECT paa.assignment_number,

Line 1626: FROM per_assignments_f paa,

1622: SELECT paa.assignment_number,
1623: paa.assignment_id,
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

Line 1641: v_bg_id per_assignments_f.business_group_id%TYPE,

1637: AND paa.primary_flag = 'Y';
1638:
1639: CURSOR csr_ni_nr (
1640: v_ni_nr per_people_f.national_identifier%TYPE,
1641: v_bg_id per_assignments_f.business_group_id%TYPE,
1642: v_effective_date DATE
1643: )
1644: IS
1645: SELECT paa.assignment_number,

Line 1649: FROM per_assignments_f paa,

1645: SELECT paa.assignment_number,
1646: paa.assignment_id,
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

Line 1662: l_assg_nr per_assignments_f.assignment_number%TYPE := NULL;

1658: AND pap.effective_end_date
1659: AND paa.business_group_id = v_bg_id
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;

Line 1663: l_assg_id per_assignments_f.assignment_id%TYPE := NULL;

1659: AND paa.business_group_id = v_bg_id
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