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.

[Home] [Help]

APPS.PAYUSUNB_PKG dependencies on PER_PEOPLE_F

Line 823: per_people_f ppf,

819: created by PYUGEN */
820: FROM hr_organization_units hou,
821: hr_organization_units hou1,
822: hr_locations loc,
823: per_people_f ppf,
824: per_all_assignments_f paf,
825: pay_assignment_actions paa1, /* PYUGEN assignment action */
826: pay_payroll_actions ppa1 /* PYUGEN payroll action id */
827: WHERE ppa1.payroll_action_id = :pactid

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

1846:
1847: /*************************** 3005756 start **********************************************/
1848: -- Run Balance cursors
1849: -- get all state level jurisdiction codes for specified person
1850: CURSOR c_state_jurisdictions_valid(IN_person_id IN per_people_f.person_id%TYPE,
1851: IN_state_code IN VARCHAR2,
1852: IN_start_date IN DATE,
1853: IN_as_of_date IN DATE) IS
1854: SELECT DISTINCT

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

1868: OR IN_state_code IS NULL);
1869:
1870:
1871: -- get all county level jurisdiction codes for specified person
1872: CURSOR c_county_jurisdictions_valid(IN_person_id IN per_people_f.person_id%TYPE,
1873: IN_state_code IN VARCHAR2,
1874: IN_start_date IN DATE,
1875: IN_as_of_date IN DATE) IS
1876: SELECT DISTINCT

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

1894: AND pus.state_code = puc.state_code;
1895:
1896:
1897: -- get all city level jurisdiction codes for specified person
1898: CURSOR c_city_jurisdictions_valid(IN_person_id IN per_people_f.person_id%TYPE,
1899: IN_state_code IN VARCHAR2,
1900: IN_start_date IN DATE,
1901: IN_as_of_date IN DATE) IS
1902: SELECT DISTINCT

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

1924: AND pus.state_code = prb.jurisdiction_comp1;
1925:
1926:
1927: -- get all city level jurisdiction codes for specified person
1928: CURSOR c_school_jurisdictions_valid(IN_person_id IN per_people_f.person_id%TYPE,
1929: IN_state_code IN VARCHAR2,
1930: IN_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE,
1931: IN_start_date IN DATE,
1932: IN_as_of_date IN DATE) IS

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

1980: -- Original run result cursors
1981:
1982:
1983: -- get all state level jurisdiction codes for specified person
1984: CURSOR c_state_jurisdictions(IN_person_id IN per_people_f.person_id%TYPE,
1985: IN_state_code IN VARCHAR2,
1986: IN_start_date IN DATE,
1987: IN_as_of_date IN DATE) IS
1988: SELECT DISTINCT

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

2027:
2028:
2029:
2030: -- get all county level jurisdiction codes for specified person
2031: CURSOR c_county_jurisdictions(IN_person_id IN per_people_f.person_id%TYPE,
2032: IN_state_code IN VARCHAR2,
2033: IN_start_date IN DATE,
2034: IN_as_of_date IN DATE) IS
2035: SELECT DISTINCT pes.jurisdiction_code,

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

2071: AND rownum = 1); -- added rownum to improve performance (Bug 3316599)
2072:
2073:
2074: -- get all city level jurisdiction codes for specified person
2075: CURSOR c_city_jurisdictions(IN_person_id IN per_people_f.person_id%TYPE,
2076: IN_state_code IN VARCHAR2,
2077: IN_start_date IN DATE,
2078: IN_as_of_date IN DATE) IS
2079: SELECT DISTINCT

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

2118: AND rownum = 1); -- added rownum to improve performance (Bug 3316599)
2119:
2120:
2121: -- get all city level jurisdiction codes for specified person
2122: CURSOR c_school_jurisdictions(IN_person_id IN per_people_f.person_id%TYPE,
2123: IN_state_code IN VARCHAR2,
2124: IN_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE,
2125: IN_start_date IN DATE,
2126: IN_as_of_date IN DATE) IS