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 PER_ALL_ASSIGNMENTS_F

Line 256: G_business_id per_all_assignments_f.business_group_id%TYPE;

252: city_tax_info city_tax_info_table;
253:
254: -- Global variables to hold vales fetched by c_get_payroll_stuff cursor
255: G_as_of_date DATE := NULL;
256: G_business_id per_all_assignments_f.business_group_id%TYPE;
257: G_leg_param pay_payroll_actions.legislative_parameters%TYPE;
258:
259: -- Cursor and global variable to store the futa_override rate
260: G_futa_override_rt NUMBER := 0;

Line 496: FROM per_all_assignments_f paf,

492: ,cp_period_start in date
493: ,cp_period_end in date) is
494: SELECT DISTINCT
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) */

Line 546: FROM per_all_assignments_f paf,

542: ) IS
543: /* Change for Performance Bug 6360505 */
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

Line 586: per_all_assignments_f paf

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
589: AND ppa.payroll_action_id = paa.payroll_action_id
590: AND ppa.effective_date BETWEEN cp_start_date AND cp_as_of_date

Line 612: L_org_id per_all_assignments_f.organization_id%TYPE;

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;
616:

Line 613: L_location_id per_all_assignments_f.location_id%TYPE;

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;
616:
617: L_person_id per_all_assignments_f.person_id%TYPE;

Line 614: L_business_id per_all_assignments_f.business_group_id%TYPE;

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;
616:
617: L_person_id per_all_assignments_f.person_id%TYPE;
618: L_loc_id per_all_assignments_f.location_id%TYPE;

Line 617: L_person_id per_all_assignments_f.person_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;
616:
617: L_person_id per_all_assignments_f.person_id%TYPE;
618: L_loc_id per_all_assignments_f.location_id%TYPE;
619: L_organization_id per_all_assignments_f.organization_id%TYPE;
620: L_assignment_number per_all_assignments_f.assignment_number%TYPE;
621:

Line 618: L_loc_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;
616:
617: L_person_id per_all_assignments_f.person_id%TYPE;
618: L_loc_id per_all_assignments_f.location_id%TYPE;
619: L_organization_id per_all_assignments_f.organization_id%TYPE;
620: L_assignment_number per_all_assignments_f.assignment_number%TYPE;
621:
622: l_range_person BOOLEAN;

Line 619: L_organization_id per_all_assignments_f.organization_id%TYPE;

615: L_dimension VARCHAR2(20) := NULL;
616:
617: L_person_id per_all_assignments_f.person_id%TYPE;
618: L_loc_id per_all_assignments_f.location_id%TYPE;
619: L_organization_id per_all_assignments_f.organization_id%TYPE;
620: L_assignment_number per_all_assignments_f.assignment_number%TYPE;
621:
622: l_range_person BOOLEAN;
623: /*Added for Bug#9872952*/

Line 620: L_assignment_number per_all_assignments_f.assignment_number%TYPE;

616:
617: L_person_id per_all_assignments_f.person_id%TYPE;
618: L_loc_id per_all_assignments_f.location_id%TYPE;
619: L_organization_id per_all_assignments_f.organization_id%TYPE;
620: L_assignment_number per_all_assignments_f.assignment_number%TYPE;
621:
622: l_range_person BOOLEAN;
623: /*Added for Bug#9872952*/
624: L_asg_count NUMBER := 0;

Line 744: FROM per_all_assignments_f paf,

740:
741: IF L_wage_accumulation = 'Y' THEN
742: /*Query to see if the Person has any assignments with FIT Exempt from Wage Accumulation selected */
743: SELECT count(0) INTO L_asg_count
744: FROM per_all_assignments_f paf,
745: pay_us_emp_fed_tax_rules_f peft
746: WHERE paf.person_id = L_person_id
747: AND paf.effective_end_date >= L_start_date
748: AND paf.effective_start_date <= L_as_of_date

Line 824: per_all_assignments_f paf,

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

Line 1071: FROM per_all_assignments_f

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
1071: FROM per_all_assignments_f
1072: WHERE person_id = (SELECT person_id
1073: FROM per_all_assignments_f
1074: WHERE assignment_id = p_assignment_id
1075: AND ROWNUM < 2)

Line 1073: FROM per_all_assignments_f

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
1071: FROM per_all_assignments_f
1072: WHERE person_id = (SELECT person_id
1073: FROM per_all_assignments_f
1074: WHERE assignment_id = p_assignment_id
1075: AND ROWNUM < 2)
1076: AND TRUNC(p1_as_of_date,decode(p1_dimension,'QTD','Q','YTD','Y'))<=effective_end_date;
1077:

Line 1373: FUNCTION fnc_get_futa_credit_rate(IN_organization_id IN per_all_assignments_f.organization_id%TYPE,

1369:
1370: -- New function to cache the futa credit rates in pl/sql tables .
1371: -- Used in place of the cursor c_get_futa_credit_rt
1372:
1373: FUNCTION fnc_get_futa_credit_rate(IN_organization_id IN per_all_assignments_f.organization_id%TYPE,
1374: IN_sui_state_code IN VARCHAR2 ) RETURN NUMBER IS
1375: L_return_val NUMBER;
1376:
1377: CURSOR c_get_futa_credit_rt (IN_organization_id IN per_all_assignments_f.organization_id%TYPE) IS

Line 1377: CURSOR c_get_futa_credit_rt (IN_organization_id IN per_all_assignments_f.organization_id%TYPE) IS

1373: FUNCTION fnc_get_futa_credit_rate(IN_organization_id IN per_all_assignments_f.organization_id%TYPE,
1374: IN_sui_state_code IN VARCHAR2 ) RETURN NUMBER IS
1375: L_return_val NUMBER;
1376:
1377: CURSOR c_get_futa_credit_rt (IN_organization_id IN per_all_assignments_f.organization_id%TYPE) IS
1378: SELECT org_information1,org_information15
1379: FROM hr_organization_information
1380: WHERE organization_id = IN_organization_id
1381: AND org_information_context = 'State Tax Rules';

Line 1839: IN_prc_person_id IN per_all_assignments_f.person_id%TYPE,

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
1843:

Line 1840: IN_prc_location_id IN per_all_assignments_f.location_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
1843:
1844: /****************************** END ***************************************************/

Line 1841: IN_prc_organization_id IN per_all_assignments_f.organization_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
1843:
1844: /****************************** END ***************************************************/
1845:

Line 1842: IN_prc_assignment_number IN per_all_assignments_f.assignment_number%TYPE ) IS

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
1843:
1844: /****************************** END ***************************************************/
1845:
1846:

Line 2215: IN_assignment_id IN per_all_assignments_f.assignment_id%TYPE,

2211:
2212: /*************************************** 3005756 end ****************************************************/
2213:
2214: CURSOR c_get_sui_state_code (IN_business_id IN NUMBER,
2215: IN_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
2216: IN_start_date IN DATE,
2217: IN_as_of_date IN DATE) IS
2218: SELECT NVL(sui_state_code,'00')
2219: FROM pay_us_emp_fed_tax_rules_f

Line 2229: L_org_id per_all_assignments_f.organization_id%TYPE;

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;
2233: L_tax_type VARCHAR2(20) := NULL;

Line 2230: L_location_id per_all_assignments_f.location_id%TYPE;

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;
2233: L_tax_type VARCHAR2(20) := NULL;
2234: L_tax_type_state VARCHAR2(20) := NULL;

Line 2231: L_business_id per_all_assignments_f.business_group_id%TYPE;

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;
2233: L_tax_type VARCHAR2(20) := NULL;
2234: L_tax_type_state VARCHAR2(20) := NULL;
2235: L_usr_SDI_ER_rate NUMBER := NULL;

Line 3135: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

3131: L_use_default_sdi_ee VARCHAR2(2) := 'N';
3132:
3133: /*End of Changes for Bug#13394260*/
3134:
3135: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
3136: BEGIN
3137: hr_utility.trace('prc_state_balances - curr_jurisdiction_code: ' || curr_jurisdiction_code);
3138: hr_utility.trace('prc_state_balances - curr_state_code: ' || curr_state_code);
3139: hr_utility.trace('prc_state_balances - curr_state_abbrev: ' || curr_state_abbrev);