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 195: G_business_id per_all_assignments_f.business_group_id%TYPE;

191: city_tax_info city_tax_info_table;
192:
193: -- Global variables to hold vales fetched by c_get_payroll_stuff cursor
194: G_as_of_date DATE := NULL;
195: G_business_id per_all_assignments_f.business_group_id%TYPE;
196: G_leg_param pay_payroll_actions.legislative_parameters%TYPE;
197:
198: -- Cursor and global variable to store the futa_override rate
199: G_futa_override_rt NUMBER := 0;

Line 326: FROM per_all_assignments_f paf,

322: ,cp_period_start in date
323: ,cp_period_end in date) is
324: SELECT DISTINCT
325: paf.person_id person_id
326: FROM per_all_assignments_f paf,
327: pay_all_payrolls_f PPY
328: WHERE exists
329: (select /*+ INDEX(paa PAY_ASSIGNMENT_ACTIONS_N51)
330: INDEX(ppa PAY_PAYROLL_ACTIONS_PK) */

Line 376: FROM per_all_assignments_f paf,

372: ) IS
373: /* Change for Performance Bug 6360505 */
374: SELECT /*+ ORDERED */
375: to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) assignment_action_id
376: FROM per_all_assignments_f paf,
377: pay_payroll_actions ppa,
378: pay_assignment_actions paa,
379: pay_action_classifications pac
380: WHERE paf.person_id = cp_person_id

Line 416: per_all_assignments_f paf

412: paf.organization_id,
413: paf.assignment_number
414: FROM pay_assignment_actions paa,
415: pay_payroll_actions ppa,
416: per_all_assignments_f paf
417: WHERE paa.assignment_action_id = cp_asg_act_id
418: AND paa.tax_unit_id = cp_tax_unit_id
419: AND ppa.payroll_action_id = paa.payroll_action_id
420: AND ppa.effective_date BETWEEN cp_start_date AND cp_as_of_date

Line 435: L_org_id per_all_assignments_f.organization_id%TYPE;

431: L_as_of_date DATE := NULL;
432: L_start_date DATE;
433: L_leg_param pay_payroll_actions.legislative_parameters%TYPE;
434: L_gre_id pay_assignment_actions.tax_unit_id%TYPE;
435: L_org_id per_all_assignments_f.organization_id%TYPE;
436: L_location_id per_all_assignments_f.location_id%TYPE;
437: L_business_id per_all_assignments_f.business_group_id%TYPE;
438: L_dimension VARCHAR2(20) := NULL;
439:

Line 436: L_location_id per_all_assignments_f.location_id%TYPE;

432: L_start_date DATE;
433: L_leg_param pay_payroll_actions.legislative_parameters%TYPE;
434: L_gre_id pay_assignment_actions.tax_unit_id%TYPE;
435: L_org_id per_all_assignments_f.organization_id%TYPE;
436: L_location_id per_all_assignments_f.location_id%TYPE;
437: L_business_id per_all_assignments_f.business_group_id%TYPE;
438: L_dimension VARCHAR2(20) := NULL;
439:
440: L_person_id per_all_assignments_f.person_id%TYPE;

Line 437: L_business_id per_all_assignments_f.business_group_id%TYPE;

433: L_leg_param pay_payroll_actions.legislative_parameters%TYPE;
434: L_gre_id pay_assignment_actions.tax_unit_id%TYPE;
435: L_org_id per_all_assignments_f.organization_id%TYPE;
436: L_location_id per_all_assignments_f.location_id%TYPE;
437: L_business_id per_all_assignments_f.business_group_id%TYPE;
438: L_dimension VARCHAR2(20) := NULL;
439:
440: L_person_id per_all_assignments_f.person_id%TYPE;
441: L_loc_id per_all_assignments_f.location_id%TYPE;

Line 440: L_person_id per_all_assignments_f.person_id%TYPE;

436: L_location_id per_all_assignments_f.location_id%TYPE;
437: L_business_id per_all_assignments_f.business_group_id%TYPE;
438: L_dimension VARCHAR2(20) := NULL;
439:
440: L_person_id per_all_assignments_f.person_id%TYPE;
441: L_loc_id per_all_assignments_f.location_id%TYPE;
442: L_organization_id per_all_assignments_f.organization_id%TYPE;
443: L_assignment_number per_all_assignments_f.assignment_number%TYPE;
444:

Line 441: L_loc_id per_all_assignments_f.location_id%TYPE;

437: L_business_id per_all_assignments_f.business_group_id%TYPE;
438: L_dimension VARCHAR2(20) := NULL;
439:
440: L_person_id per_all_assignments_f.person_id%TYPE;
441: L_loc_id per_all_assignments_f.location_id%TYPE;
442: L_organization_id per_all_assignments_f.organization_id%TYPE;
443: L_assignment_number per_all_assignments_f.assignment_number%TYPE;
444:
445: l_range_person BOOLEAN;

Line 442: L_organization_id per_all_assignments_f.organization_id%TYPE;

438: L_dimension VARCHAR2(20) := NULL;
439:
440: L_person_id per_all_assignments_f.person_id%TYPE;
441: L_loc_id per_all_assignments_f.location_id%TYPE;
442: L_organization_id per_all_assignments_f.organization_id%TYPE;
443: L_assignment_number per_all_assignments_f.assignment_number%TYPE;
444:
445: l_range_person BOOLEAN;
446: BEGIN

Line 443: L_assignment_number per_all_assignments_f.assignment_number%TYPE;

439:
440: L_person_id per_all_assignments_f.person_id%TYPE;
441: L_loc_id per_all_assignments_f.location_id%TYPE;
442: L_organization_id per_all_assignments_f.organization_id%TYPE;
443: L_assignment_number per_all_assignments_f.assignment_number%TYPE;
444:
445: l_range_person BOOLEAN;
446: BEGIN
447:

Line 593: per_all_assignments_f paf,

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

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

884:
885: -- New function to cache the futa credit rates in pl/sql tables .
886: -- Used in place of the cursor c_get_futa_credit_rt
887:
888: FUNCTION fnc_get_futa_credit_rate(IN_organization_id IN per_all_assignments_f.organization_id%TYPE,
889: IN_sui_state_code IN VARCHAR2 ) RETURN NUMBER IS
890: L_return_val NUMBER;
891:
892: CURSOR c_get_futa_credit_rt (IN_organization_id IN per_all_assignments_f.organization_id%TYPE) IS

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

888: FUNCTION fnc_get_futa_credit_rate(IN_organization_id IN per_all_assignments_f.organization_id%TYPE,
889: IN_sui_state_code IN VARCHAR2 ) RETURN NUMBER IS
890: L_return_val NUMBER;
891:
892: CURSOR c_get_futa_credit_rt (IN_organization_id IN per_all_assignments_f.organization_id%TYPE) IS
893: SELECT org_information1,org_information15
894: FROM hr_organization_information
895: WHERE organization_id = IN_organization_id
896: AND org_information_context = 'State Tax Rules';

Line 1354: IN_prc_person_id IN per_all_assignments_f.person_id%TYPE,

1350: IN_prc_lockingactid IN pay_assignment_actions.assignment_action_id%TYPE,
1351: IN_prc_lockedactid IN pay_assignment_actions.assignment_action_id%TYPE,
1352: IN_prc_assignment_id IN pay_assignment_actions.assignment_id%TYPE,
1353: IN_prc_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE,
1354: IN_prc_person_id IN per_all_assignments_f.person_id%TYPE,
1355: IN_prc_location_id IN per_all_assignments_f.location_id%TYPE,
1356: IN_prc_organization_id IN per_all_assignments_f.organization_id%TYPE,
1357: IN_prc_assignment_number IN per_all_assignments_f.assignment_number%TYPE ) IS
1358:

Line 1355: IN_prc_location_id IN per_all_assignments_f.location_id%TYPE,

1351: IN_prc_lockedactid IN pay_assignment_actions.assignment_action_id%TYPE,
1352: IN_prc_assignment_id IN pay_assignment_actions.assignment_id%TYPE,
1353: IN_prc_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE,
1354: IN_prc_person_id IN per_all_assignments_f.person_id%TYPE,
1355: IN_prc_location_id IN per_all_assignments_f.location_id%TYPE,
1356: IN_prc_organization_id IN per_all_assignments_f.organization_id%TYPE,
1357: IN_prc_assignment_number IN per_all_assignments_f.assignment_number%TYPE ) IS
1358:
1359: /****************************** END ***************************************************/

Line 1356: IN_prc_organization_id IN per_all_assignments_f.organization_id%TYPE,

1352: IN_prc_assignment_id IN pay_assignment_actions.assignment_id%TYPE,
1353: IN_prc_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE,
1354: IN_prc_person_id IN per_all_assignments_f.person_id%TYPE,
1355: IN_prc_location_id IN per_all_assignments_f.location_id%TYPE,
1356: IN_prc_organization_id IN per_all_assignments_f.organization_id%TYPE,
1357: IN_prc_assignment_number IN per_all_assignments_f.assignment_number%TYPE ) IS
1358:
1359: /****************************** END ***************************************************/
1360:

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

1353: IN_prc_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE,
1354: IN_prc_person_id IN per_all_assignments_f.person_id%TYPE,
1355: IN_prc_location_id IN per_all_assignments_f.location_id%TYPE,
1356: IN_prc_organization_id IN per_all_assignments_f.organization_id%TYPE,
1357: IN_prc_assignment_number IN per_all_assignments_f.assignment_number%TYPE ) IS
1358:
1359: /****************************** END ***************************************************/
1360:
1361:

Line 1727: IN_assignment_id IN per_all_assignments_f.assignment_id%TYPE,

1723:
1724: /*************************************** 3005756 end ****************************************************/
1725:
1726: CURSOR c_get_sui_state_code (IN_business_id IN NUMBER,
1727: IN_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
1728: IN_start_date IN DATE,
1729: IN_as_of_date IN DATE) IS
1730: SELECT NVL(sui_state_code,'00')
1731: FROM pay_us_emp_fed_tax_rules_f

Line 1741: L_org_id per_all_assignments_f.organization_id%TYPE;

1737: L_as_of_date DATE := NULL;
1738: L_start_date DATE ;
1739: L_leg_param pay_payroll_actions.legislative_parameters%TYPE;
1740: L_gre_id pay_assignment_actions.tax_unit_id%TYPE;
1741: L_org_id per_all_assignments_f.organization_id%TYPE;
1742: L_location_id per_all_assignments_f.location_id%TYPE;
1743: L_business_id per_all_assignments_f.business_group_id%TYPE;
1744: L_dimension VARCHAR2(20) := NULL;
1745: L_tax_type VARCHAR2(20) := NULL;

Line 1742: L_location_id per_all_assignments_f.location_id%TYPE;

1738: L_start_date DATE ;
1739: L_leg_param pay_payroll_actions.legislative_parameters%TYPE;
1740: L_gre_id pay_assignment_actions.tax_unit_id%TYPE;
1741: L_org_id per_all_assignments_f.organization_id%TYPE;
1742: L_location_id per_all_assignments_f.location_id%TYPE;
1743: L_business_id per_all_assignments_f.business_group_id%TYPE;
1744: L_dimension VARCHAR2(20) := NULL;
1745: L_tax_type VARCHAR2(20) := NULL;
1746: L_tax_type_state VARCHAR2(20) := NULL;

Line 1743: L_business_id per_all_assignments_f.business_group_id%TYPE;

1739: L_leg_param pay_payroll_actions.legislative_parameters%TYPE;
1740: L_gre_id pay_assignment_actions.tax_unit_id%TYPE;
1741: L_org_id per_all_assignments_f.organization_id%TYPE;
1742: L_location_id per_all_assignments_f.location_id%TYPE;
1743: L_business_id per_all_assignments_f.business_group_id%TYPE;
1744: L_dimension VARCHAR2(20) := NULL;
1745: L_tax_type VARCHAR2(20) := NULL;
1746: L_tax_type_state VARCHAR2(20) := NULL;
1747: L_usr_SDI_ER_rate NUMBER := NULL;