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.PER_GB_TAX_BEN_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 1425: p_bus_group_id IN per_all_assignments_f.business_group_id%TYPE

1421: RETURN l_tax_ben_el;
1422: END validate_tax_ben_element;
1423:
1424: PROCEDURE get_assignment_info (
1425: p_bus_group_id IN per_all_assignments_f.business_group_id%TYPE
1426: DEFAULT NULL,
1427: p_id_type IN VARCHAR2,
1428: p_id IN VARCHAR2,
1429: p_effective_date IN DATE,

Line 1430: p_assg_id OUT NOCOPY per_all_assignments_f.assignment_id%TYPE,

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

Line 1431: p_assg_nr OUT NOCOPY per_all_assignments_f.assignment_number%TYPE,

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

Line 1441: v_assg_id per_all_assignments_f.assignment_id%TYPE,

1437: l_proc CONSTANT VARCHAR2 (72) := g_package
1438: || 'get_assignment_info';
1439:
1440: CURSOR csr_assg_id (
1441: v_assg_id per_all_assignments_f.assignment_id%TYPE,
1442: v_effective_date DATE
1443: )
1444: IS
1445: SELECT paa.assignment_number, pos.date_start, pos.final_process_date

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 1454: v_assg_nr per_all_assignments_f.assignment_number%TYPE,

1450: AND paa.effective_end_date;
1451:
1452:
1453: /* CURSOR csr_assg_nr (
1454: v_assg_nr per_all_assignments_f.assignment_number%TYPE,
1455: v_bg_id per_all_assignments_f.business_group_id%TYPE,
1456: v_effective_date DATE
1457: )
1458: IS

Line 1455: v_bg_id per_all_assignments_f.business_group_id%TYPE,

1451:
1452:
1453: /* CURSOR csr_assg_nr (
1454: v_assg_nr per_all_assignments_f.assignment_number%TYPE,
1455: v_bg_id per_all_assignments_f.business_group_id%TYPE,
1456: v_effective_date DATE
1457: )
1458: IS
1459: SELECT paa.assignment_id, pos.date_start, pos.final_process_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 1468: v_person_id per_all_assignments_f.person_id%TYPE,

1464: AND paa.effective_end_date
1465: AND paa.business_group_id = v_bg_id;
1466: */
1467: CURSOR csr_person_id (
1468: v_person_id per_all_assignments_f.person_id%TYPE,
1469: v_bg_id per_all_assignments_f.business_group_id%TYPE,
1470: v_effective_date DATE
1471: )
1472: IS

Line 1469: v_bg_id per_all_assignments_f.business_group_id%TYPE,

1465: AND paa.business_group_id = v_bg_id;
1466: */
1467: CURSOR csr_person_id (
1468: v_person_id per_all_assignments_f.person_id%TYPE,
1469: v_bg_id per_all_assignments_f.business_group_id%TYPE,
1470: v_effective_date DATE
1471: )
1472: IS
1473: SELECT paa.assignment_number, paa.assignment_id, pos.date_start,

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 1485: v_bg_id per_all_assignments_f.business_group_id%TYPE,

1481: AND paa.primary_flag = 'Y';
1482:
1483: CURSOR csr_empl_nr (
1484: v_empl_nr per_all_people_f.employee_number%TYPE,
1485: v_bg_id per_all_assignments_f.business_group_id%TYPE,
1486: v_effective_date DATE
1487: )
1488: IS
1489: SELECT paa.assignment_number, paa.assignment_id, pos.date_start,

Line 1491: FROM per_all_assignments_f paa,

1487: )
1488: IS
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

Line 1506: v_bg_id per_all_assignments_f.business_group_id%TYPE,

1502: AND paa.primary_flag = 'Y';
1503:
1504: CURSOR csr_ni_nr (
1505: v_ni_nr per_all_people_f.national_identifier%TYPE,
1506: v_bg_id per_all_assignments_f.business_group_id%TYPE,
1507: v_effective_date DATE
1508: )
1509: IS
1510: SELECT /*+ ORDERED use_nl(pap paa pos) */

Line 1514: per_all_assignments_f paa,

1510: SELECT /*+ ORDERED use_nl(pap paa 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

Line 1527: l_assg_nr per_all_assignments_f.assignment_number%TYPE := NULL;

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

Line 1528: l_assg_id per_all_assignments_f.assignment_id%TYPE := NULL;

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