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.PAYUSUNB_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 162: G_asgn_action_id pay_assignment_actions.assignment_action_id%TYPE := NULL;

158: --c_fixed_futa_rt CONSTANT NUMBER(10,4) := 6.2;
159: l_gfuta_rt NUMBER;
160: l_futa_change_count NUMBER;
161: -- define some global variables for temporary storage
162: G_asgn_action_id pay_assignment_actions.assignment_action_id%TYPE := NULL;
163: G_payroll_id pay_payroll_actions.payroll_id%TYPE := NULL;
164: G_got_fed_rate BOOLEAN := FALSE;
165: G_ss_ee_rate NUMBER := NULL;
166: G_ss_er_rate NUMBER := NULL;

Line 264: IN_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE) IS

260: G_futa_override_rt NUMBER := 0;
261:
262: -- Cursor fetches the futa override rate based on the tax unit id passed.
263: CURSOR c_get_futa_override_rt(
264: IN_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE) IS
265: SELECT NVL(org_information7,0)/100
266: FROM hr_organization_information
267: WHERE organization_id = IN_tax_unit_id
268: AND org_information_context = 'Federal Tax Rules';

Line 346: INDEX (act PAY_ASSIGNMENT_ACTIONS_N50)

342: lv_sqlstr :=
343: 'SELECT /*+ ORDERED
344: INDEX (ppa PAY_PAYROLL_ACTIONS_PK)
345: INDEX (pa1 PAY_PAYROLL_ACTIONS_N5)
346: INDEX (act PAY_ASSIGNMENT_ACTIONS_N50)
347: INDEX (paf PER_ASSIGNMENTS_F_PK) */
348: DISTINCT paf.person_id
349: FROM pay_payroll_actions ppa,
350: pay_payroll_actions pa1,

Line 351: pay_assignment_actions act,

347: INDEX (paf PER_ASSIGNMENTS_F_PK) */
348: DISTINCT paf.person_id
349: FROM pay_payroll_actions ppa,
350: pay_payroll_actions pa1,
351: pay_assignment_actions act,
352: per_assignments_f paf
353: WHERE ppa.payroll_action_id = :payroll_action_id
354: AND pa1.effective_date >= fnd_date.canonical_to_date('''|| lv_cur_date ||''')
355: AND pa1.effective_date <= ppa.effective_date

Line 499: (select /*+ INDEX(paa PAY_ASSIGNMENT_ACTIONS_N51)

495: paf.person_id person_id
496: FROM per_all_assignments_f paf,
497: pay_all_payrolls_f PPY
498: WHERE exists
499: (select /*+ INDEX(paa PAY_ASSIGNMENT_ACTIONS_N51)
500: INDEX(ppa PAY_PAYROLL_ACTIONS_PK) */
501: 'x'
502: from pay_payroll_actions ppa,
503: pay_assignment_actions paa

Line 503: pay_assignment_actions paa

499: (select /*+ INDEX(paa PAY_ASSIGNMENT_ACTIONS_N51)
500: INDEX(ppa PAY_PAYROLL_ACTIONS_PK) */
501: 'x'
502: from pay_payroll_actions ppa,
503: pay_assignment_actions paa
504: where ppa.effective_date between cp_period_start
505: and cp_period_end
506: and ppa.action_type in ('R','Q','V','B','I')
507: and ppa.action_status = 'C'

Line 548: pay_assignment_actions paa,

544: SELECT /*+ ORDERED */
545: to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) assignment_action_id
546: FROM per_all_assignments_f paf,
547: pay_payroll_actions ppa,
548: pay_assignment_actions paa,
549: pay_action_classifications pac
550: WHERE paf.person_id = cp_person_id
551: AND paf.payroll_id = ppa.payroll_id
552: AND (paf.organization_id = IN_org_id

Line 584: FROM pay_assignment_actions paa,

580: SELECT paa.assignment_id ,
581: paf.location_id,
582: paf.organization_id,
583: paf.assignment_number
584: FROM pay_assignment_actions paa,
585: pay_payroll_actions ppa,
586: per_all_assignments_f paf
587: WHERE paa.assignment_action_id = cp_asg_act_id
588: AND paa.tax_unit_id = cp_tax_unit_id

Line 611: L_gre_id pay_assignment_actions.tax_unit_id%TYPE;

607: L_greid NUMBER;
608: L_as_of_date DATE := NULL;
609: L_start_date DATE;
610: L_leg_param pay_payroll_actions.legislative_parameters%TYPE;
611: L_gre_id pay_assignment_actions.tax_unit_id%TYPE;
612: L_org_id per_all_assignments_f.organization_id%TYPE;
613: L_location_id per_all_assignments_f.location_id%TYPE;
614: L_business_id per_all_assignments_f.business_group_id%TYPE;
615: L_dimension VARCHAR2(20) := NULL;

Line 726: SELECT pay_assignment_actions_s.NEXTVAL

722: hr_utility.trace('L_assignid ' || L_assignid);
723: hr_utility.trace('L_assignment_number ' || L_assignment_number);
724: hr_utility.set_location('procpyr',3);
725:
726: SELECT pay_assignment_actions_s.NEXTVAL
727: INTO L_lockingactid
728: FROM dual;
729: /*Added for Bug#9872952*/
730: /*When the Profile value of 'PAY:Use Direct Balances for US Federal Taxes' is set as Yes,

Line 825: pay_assignment_actions paa1, /* PYUGEN assignment action */

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
828: AND paa1.payroll_action_id = ppa1.payroll_action_id
829: AND paa1.assignment_id = paf.assignment_id

Line 1066: FROM pay_assignment_actions

1062: ORDER BY effective_start_date;
1063:
1064: CURSOR c_get_assignment_id(p_assignment_action_id NUMBER) is
1065: SELECT assignment_id
1066: FROM pay_assignment_actions
1067: WHERE assignment_action_id = p_assignment_action_id;
1068:
1069: CURSOR c_get_all_assignment_id(p_assignment_id NUMBER,p1_as_of_date DATE,p1_dimension VARCHAR2) is --#Bug 13434213 Added cursor c_get_all_assignment_id
1070: SELECT distinct assignment_id

Line 1447: FUNCTION fnc_sui_sdi_override ( IN_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE

1443:
1444: -- New function to cache the sui and sdi override rates
1445: -- Caches for the first time and returns the value later on
1446:
1447: FUNCTION fnc_sui_sdi_override ( IN_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE
1448: ,IN_state_code IN VARCHAR2
1449: ,IN_ret_flag IN VARCHAR2) RETURN NUMBER IS
1450:
1451: L_return_val NUMBER;

Line 1453: CURSOR c_get_sui_sdi_overide_rt (IN_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE) IS

1449: ,IN_ret_flag IN VARCHAR2) RETURN NUMBER IS
1450:
1451: L_return_val NUMBER;
1452:
1453: CURSOR c_get_sui_sdi_overide_rt (IN_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE) IS
1454: SELECT pus.state_code,org_information6/100, org_information7/100 , org_information14/100
1455: FROM hr_organization_information org, pay_us_states pus
1456: WHERE org.org_information1 = pus.state_abbrev
1457: AND pus.state_code between 00 and 99

Line 1522: TAX_UNIT_ID := tax_unit_id (from pay_assignment_actions)

1518: PAY_US_RPT_TOTALS table. There are two types of records, 1 is
1519: header record and the other is detail record.
1520: column mapping specs for header record:
1521: SESSION_ID := payroll_action_id (PYUGEN Payroll Action)
1522: TAX_UNIT_ID := tax_unit_id (from pay_assignment_actions)
1523: ORGANIZATION_ID := organization_id (from per_assignments_f)
1524: LOCATION_ID := location_id (from per_assignments_f)
1525: BUSINESS_GROUP_ID := chunk number from PYUGEN process
1526: VALUE1 := person_id

Line 1835: IN_prc_lockingactid IN pay_assignment_actions.assignment_action_id%TYPE,

1831: **************************************************************************/
1832: PROCEDURE prc_process_data(IN_pact_id IN pay_payroll_actions.payroll_action_id%TYPE,
1833: IN_chunk_no IN NUMBER,
1834: IN_commit_count IN NUMBER DEFAULT 1000,
1835: IN_prc_lockingactid IN pay_assignment_actions.assignment_action_id%TYPE,
1836: IN_prc_lockedactid IN pay_assignment_actions.assignment_action_id%TYPE,
1837: IN_prc_assignment_id IN pay_assignment_actions.assignment_id%TYPE,
1838: IN_prc_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE,
1839: IN_prc_person_id IN per_all_assignments_f.person_id%TYPE,

Line 1836: IN_prc_lockedactid IN pay_assignment_actions.assignment_action_id%TYPE,

1832: PROCEDURE prc_process_data(IN_pact_id IN pay_payroll_actions.payroll_action_id%TYPE,
1833: IN_chunk_no IN NUMBER,
1834: IN_commit_count IN NUMBER DEFAULT 1000,
1835: IN_prc_lockingactid IN pay_assignment_actions.assignment_action_id%TYPE,
1836: IN_prc_lockedactid IN pay_assignment_actions.assignment_action_id%TYPE,
1837: IN_prc_assignment_id IN pay_assignment_actions.assignment_id%TYPE,
1838: IN_prc_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE,
1839: IN_prc_person_id IN per_all_assignments_f.person_id%TYPE,
1840: IN_prc_location_id IN per_all_assignments_f.location_id%TYPE,

Line 1837: IN_prc_assignment_id IN pay_assignment_actions.assignment_id%TYPE,

1833: IN_chunk_no IN NUMBER,
1834: IN_commit_count IN NUMBER DEFAULT 1000,
1835: IN_prc_lockingactid IN pay_assignment_actions.assignment_action_id%TYPE,
1836: IN_prc_lockedactid IN pay_assignment_actions.assignment_action_id%TYPE,
1837: IN_prc_assignment_id IN pay_assignment_actions.assignment_id%TYPE,
1838: IN_prc_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE,
1839: IN_prc_person_id IN per_all_assignments_f.person_id%TYPE,
1840: IN_prc_location_id IN per_all_assignments_f.location_id%TYPE,
1841: IN_prc_organization_id IN per_all_assignments_f.organization_id%TYPE,

Line 1838: IN_prc_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE,

1834: IN_commit_count IN NUMBER DEFAULT 1000,
1835: IN_prc_lockingactid IN pay_assignment_actions.assignment_action_id%TYPE,
1836: IN_prc_lockedactid IN pay_assignment_actions.assignment_action_id%TYPE,
1837: IN_prc_assignment_id IN pay_assignment_actions.assignment_id%TYPE,
1838: IN_prc_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE,
1839: IN_prc_person_id IN per_all_assignments_f.person_id%TYPE,
1840: IN_prc_location_id IN per_all_assignments_f.location_id%TYPE,
1841: IN_prc_organization_id IN per_all_assignments_f.organization_id%TYPE,
1842: IN_prc_assignment_number IN per_all_assignments_f.assignment_number%TYPE ) IS

Line 1930: IN_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE,

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
1933: SELECT DISTINCT
1934: prb.jurisdiction_code,

Line 2016: pay_assignment_actions paa,

2012: -- AND pus.state_code = NVL(IN_state_code, pus.state_code)
2013: AND EXISTS (
2014: SELECT 'X'
2015: FROM pay_payroll_actions ppa,
2016: pay_assignment_actions paa,
2017: pay_run_results prr
2018: WHERE action_type IN ('B','I','R','Q','V')
2019: AND ppa.action_status = 'C'
2020: AND ppa.effective_date BETWEEN IN_start_date

Line 2061: pay_assignment_actions paa,

2057: --AND pus.state_code = NVL(IN_state_code, pus.state_code)
2058: AND EXISTS (
2059: SELECT 'X'
2060: FROM pay_payroll_actions ppa,
2061: pay_assignment_actions paa,
2062: pay_run_results prr
2063: WHERE action_type IN ('B','I','R','Q','V')
2064: AND ppa.action_status = 'C'
2065: AND ppa.effective_date BETWEEN IN_start_date

Line 2108: pay_assignment_actions paa,

2104: -- AND pus.state_code = NVL(IN_state_code, pus.state_code)
2105: AND EXISTS (
2106: SELECT 'X'
2107: FROM pay_payroll_actions ppa,
2108: pay_assignment_actions paa,
2109: pay_run_results prr
2110: WHERE action_type IN ('B','I','R','Q','V')
2111: AND ppa.action_status = 'C'
2112: AND ppa.effective_date BETWEEN IN_start_date

Line 2124: IN_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE,

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
2127: SELECT DISTINCT
2128: pes.state_code||'-'||pes.school_district_code jurisdiction_code,

Line 2158: pay_assignment_actions paa,

2154: OR IN_state_code IS NULL)
2155: AND EXISTS (
2156: SELECT 'X'
2157: FROM pay_payroll_actions ppa,
2158: pay_assignment_actions paa,
2159: pay_run_results prr
2160: WHERE action_type IN ('B','I','R','Q','V')
2161: AND ppa.action_status = 'C'
2162: AND ppa.effective_date BETWEEN IN_start_date

Line 2200: pay_assignment_actions paa,

2196: OR IN_state_code IS NULL)
2197: AND EXISTS (
2198: SELECT 'X'
2199: FROM pay_payroll_actions ppa,
2200: pay_assignment_actions paa,
2201: pay_run_results prr
2202: WHERE action_type IN ('B','I','R','Q','V')
2203: AND ppa.action_status = 'C'
2204: AND ppa.effective_date BETWEEN IN_start_date

Line 2228: L_gre_id pay_assignment_actions.tax_unit_id%TYPE;

2224:
2225: L_as_of_date DATE := NULL;
2226: L_start_date DATE ;
2227: L_leg_param pay_payroll_actions.legislative_parameters%TYPE;
2228: L_gre_id pay_assignment_actions.tax_unit_id%TYPE;
2229: L_org_id per_all_assignments_f.organization_id%TYPE;
2230: L_location_id per_all_assignments_f.location_id%TYPE;
2231: L_business_id per_all_assignments_f.business_group_id%TYPE;
2232: L_dimension VARCHAR2(20) := NULL;

Line 2363: FUNCTION f_check_medi_exempt(f_assignment_id IN pay_assignment_actions.assignment_id%TYPE,

2359: -----------------------------------------------
2360: --
2361: -- changes made be tmehra
2362: --
2363: FUNCTION f_check_medi_exempt(f_assignment_id IN pay_assignment_actions.assignment_id%TYPE,
2364: f_start_date IN DATE,
2365: f_as_of_date IN DATE) RETURN VARCHAR2 IS
2366:
2367: CURSOR c_chk_medi_exempt(IN_assignment_id IN pay_assignment_actions.assignment_id%TYPE,

Line 2367: CURSOR c_chk_medi_exempt(IN_assignment_id IN pay_assignment_actions.assignment_id%TYPE,

2363: FUNCTION f_check_medi_exempt(f_assignment_id IN pay_assignment_actions.assignment_id%TYPE,
2364: f_start_date IN DATE,
2365: f_as_of_date IN DATE) RETURN VARCHAR2 IS
2366:
2367: CURSOR c_chk_medi_exempt(IN_assignment_id IN pay_assignment_actions.assignment_id%TYPE,
2368: IN_start_date IN DATE,
2369: IN_as_of_date IN DATE) IS
2370: SELECT medicare_tax_exempt
2371: FROM pay_us_emp_fed_tax_rules_v

Line 3678: from pay_assignment_actions where assignment_action_id = L_asg_action_id; /* BUG# 10350917 */

3674:
3675: -- get ee balance for first 6 months
3676: BEGIN
3677: select assignment_id into l_assignment_id
3678: from pay_assignment_actions where assignment_action_id = L_asg_action_id; /* BUG# 10350917 */
3679: L_sui_ee_bal_first := pay_us_tax_bals_pkg.us_tax_balance
3680: ('TAXABLE',
3681: 'SUI',
3682: 'EE',

Line 3753: from pay_assignment_actions where assignment_action_id = L_asg_action_id; /* Bug 10350917 */

3749:
3750: -- get er balance for first 6 months
3751: BEGIN
3752: select assignment_id into l_assignment_id
3753: from pay_assignment_actions where assignment_action_id = L_asg_action_id; /* Bug 10350917 */
3754: L_sui_er_bal_first := pay_us_tax_bals_pkg.us_tax_balance
3755: ('TAXABLE',
3756: 'SUI',
3757: 'ER',