APPS.PAYUSUNB_PKG dependencies on PER_PEOPLE_F

Line 592: per_people_f ppf,

588: created by PYUGEN */
589: FROM hr_organization_units hou,
590: hr_organization_units hou1,
591: hr_locations loc,
592: per_people_f ppf,
593: per_all_assignments_f paf,
594: pay_assignment_actions paa1, /* PYUGEN assignment action */
595: pay_payroll_actions ppa1 /* PYUGEN payroll action id */
596: WHERE ppa1.payroll_action_id = :pactid

Line 1365: CURSOR c_state_jurisdictions_valid(IN_person_id IN per_people_f.person_id%TYPE,

1361:
1362: /*************************** 3005756 start **********************************************/
1363: -- Run Balance cursors
1364: -- get all state level jurisdiction codes for specified person
1365: CURSOR c_state_jurisdictions_valid(IN_person_id IN per_people_f.person_id%TYPE,
1366: IN_state_code IN VARCHAR2,
1367: IN_start_date IN DATE,
1368: IN_as_of_date IN DATE) IS
1369: SELECT DISTINCT

Line 1387: CURSOR c_county_jurisdictions_valid(IN_person_id IN per_people_f.person_id%TYPE,

1383: OR IN_state_code IS NULL);
1384:
1385:
1386: -- get all county level jurisdiction codes for specified person
1387: CURSOR c_county_jurisdictions_valid(IN_person_id IN per_people_f.person_id%TYPE,
1388: IN_state_code IN VARCHAR2,
1389: IN_start_date IN DATE,
1390: IN_as_of_date IN DATE) IS
1391: SELECT DISTINCT

Line 1413: CURSOR c_city_jurisdictions_valid(IN_person_id IN per_people_f.person_id%TYPE,

1409: AND pus.state_code = puc.state_code;
1410:
1411:
1412: -- get all city level jurisdiction codes for specified person
1413: CURSOR c_city_jurisdictions_valid(IN_person_id IN per_people_f.person_id%TYPE,
1414: IN_state_code IN VARCHAR2,
1415: IN_start_date IN DATE,
1416: IN_as_of_date IN DATE) IS
1417: SELECT DISTINCT

Line 1443: CURSOR c_school_jurisdictions_valid(IN_person_id IN per_people_f.person_id%TYPE,

1439: AND pus.state_code = prb.jurisdiction_comp1;
1440:
1441:
1442: -- get all city level jurisdiction codes for specified person
1443: CURSOR c_school_jurisdictions_valid(IN_person_id IN per_people_f.person_id%TYPE,
1444: IN_state_code IN VARCHAR2,
1445: IN_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE,
1446: IN_start_date IN DATE,
1447: IN_as_of_date IN DATE) IS

Line 1499: CURSOR c_state_jurisdictions(IN_person_id IN per_people_f.person_id%TYPE,

1495: -- Original run result cursors
1496:
1497:
1498: -- get all state level jurisdiction codes for specified person
1499: CURSOR c_state_jurisdictions(IN_person_id IN per_people_f.person_id%TYPE,
1500: IN_state_code IN VARCHAR2,
1501: IN_start_date IN DATE,
1502: IN_as_of_date IN DATE) IS
1503: SELECT DISTINCT

Line 1543: CURSOR c_county_jurisdictions(IN_person_id IN per_people_f.person_id%TYPE,

1539:
1540:
1541:
1542: -- get all county level jurisdiction codes for specified person
1543: CURSOR c_county_jurisdictions(IN_person_id IN per_people_f.person_id%TYPE,
1544: IN_state_code IN VARCHAR2,
1545: IN_start_date IN DATE,
1546: IN_as_of_date IN DATE) IS
1547: SELECT DISTINCT pes.jurisdiction_code,

Line 1587: CURSOR c_city_jurisdictions(IN_person_id IN per_people_f.person_id%TYPE,

1583: AND rownum = 1); -- added rownum to improve performance (Bug 3316599)
1584:
1585:
1586: -- get all city level jurisdiction codes for specified person
1587: CURSOR c_city_jurisdictions(IN_person_id IN per_people_f.person_id%TYPE,
1588: IN_state_code IN VARCHAR2,
1589: IN_start_date IN DATE,
1590: IN_as_of_date IN DATE) IS
1591: SELECT DISTINCT

Line 1634: CURSOR c_school_jurisdictions(IN_person_id IN per_people_f.person_id%TYPE,

1630: AND rownum = 1); -- added rownum to improve performance (Bug 3316599)
1631:
1632:
1633: -- get all city level jurisdiction codes for specified person
1634: CURSOR c_school_jurisdictions(IN_person_id IN per_people_f.person_id%TYPE,
1635: IN_state_code IN VARCHAR2,
1636: IN_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE,
1637: IN_start_date IN DATE,
1638: IN_as_of_date IN DATE) IS