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.PAY_US_TAX_INTERNAL dependencies on PER_ASSIGNMENTS_F

Line 13: assignment_id per_assignments_f.assignment_id%TYPE,

9: NXT constant number := 1;
10: --
11: TYPE location_rec is record
12: (
13: assignment_id per_assignments_f.assignment_id%TYPE,
14: location_id per_assignments_f.location_id%TYPE,
15: start_date per_assignments_f.effective_start_date%TYPE,
16: end_date per_assignments_f.effective_end_date%TYPE
17: );

Line 14: location_id per_assignments_f.location_id%TYPE,

10: --
11: TYPE location_rec is record
12: (
13: assignment_id per_assignments_f.assignment_id%TYPE,
14: location_id per_assignments_f.location_id%TYPE,
15: start_date per_assignments_f.effective_start_date%TYPE,
16: end_date per_assignments_f.effective_end_date%TYPE
17: );
18: --

Line 15: start_date per_assignments_f.effective_start_date%TYPE,

11: TYPE location_rec is record
12: (
13: assignment_id per_assignments_f.assignment_id%TYPE,
14: location_id per_assignments_f.location_id%TYPE,
15: start_date per_assignments_f.effective_start_date%TYPE,
16: end_date per_assignments_f.effective_end_date%TYPE
17: );
18: --
19: TYPE location_tbl is table of location_rec index by

Line 16: end_date per_assignments_f.effective_end_date%TYPE

12: (
13: assignment_id per_assignments_f.assignment_id%TYPE,
14: location_id per_assignments_f.location_id%TYPE,
15: start_date per_assignments_f.effective_start_date%TYPE,
16: end_date per_assignments_f.effective_end_date%TYPE
17: );
18: --
19: TYPE location_tbl is table of location_rec index by
20: binary_integer;

Line 25: PER_ASSIGNMENTS_F paf

21:
22: cursor csr_get_tax_loc(p_assignment number, p_session_dt date) is
23: select hsck.segment18
24: from HR_SOFT_CODING_KEYFLEX hsck,
25: PER_ASSIGNMENTS_F paf
26: where paf.assignment_id = p_assignment
27: and p_session_dt between paf.effective_start_date
28: and paf.effective_end_date
29: and hsck.soft_coding_keyflex_id = paf.soft_coding_keyflex_id

Line 149: from per_assignments_f asg, per_addresses adr

145: -- reimp - moved csr because its used by more than one proc.
146: --
147: cursor csr_defaulting_met(p_asg_id number,p_ef_date date) is
148: select null
149: from per_assignments_f asg, per_addresses adr
150: where asg.assignment_id = p_asg_id
151: and p_ef_date between asg.effective_start_date
152: and asg.effective_end_date
153: and asg.pay_basis_id is not null

Line 309: from per_assignments_f

305: p_def_date date) is
306: select location_id,
307: effective_start_date,
308: effective_end_date
309: from per_assignments_f
310: where assignment_id = p_assignment_id
311: and effective_start_date >= p_def_date
312: order by effective_start_date;
313: --

Line 442: INDEX(PAF PER_ASSIGNMENTS_F_PK)

438: --
439: cursor csr_get_jurisdiction (l_assignment_id number,
440: l_effective_date date) is
441: select /*+ ORDERED
442: INDEX(PAF PER_ASSIGNMENTS_F_PK)
443: USE_NL(PAF, HL, PUS, PUC, PUCN) */
444: pus.state_code ||'-'|| puc.county_code ||'-'|| pucn.city_code
445: from per_assignments_f paf,
446: hr_locations hl,

Line 445: from per_assignments_f paf,

441: select /*+ ORDERED
442: INDEX(PAF PER_ASSIGNMENTS_F_PK)
443: USE_NL(PAF, HL, PUS, PUC, PUCN) */
444: pus.state_code ||'-'|| puc.county_code ||'-'|| pucn.city_code
445: from per_assignments_f paf,
446: hr_locations hl,
447: pay_us_states pus,
448: pay_us_counties puc,
449: pay_us_city_names pucn

Line 485: assignment_id per_assignments_f.assignment_id%TYPE,

481: index by binary_integer;
482: --
483: TYPE location_rec is record
484: (
485: assignment_id per_assignments_f.assignment_id%TYPE,
486: location_id per_assignments_f.location_id%TYPE,
487: start_date per_assignments_f.effective_start_date%TYPE,
488: end_date per_assignments_f.effective_end_date%TYPE
489: );

Line 486: location_id per_assignments_f.location_id%TYPE,

482: --
483: TYPE location_rec is record
484: (
485: assignment_id per_assignments_f.assignment_id%TYPE,
486: location_id per_assignments_f.location_id%TYPE,
487: start_date per_assignments_f.effective_start_date%TYPE,
488: end_date per_assignments_f.effective_end_date%TYPE
489: );
490: --

Line 487: start_date per_assignments_f.effective_start_date%TYPE,

483: TYPE location_rec is record
484: (
485: assignment_id per_assignments_f.assignment_id%TYPE,
486: location_id per_assignments_f.location_id%TYPE,
487: start_date per_assignments_f.effective_start_date%TYPE,
488: end_date per_assignments_f.effective_end_date%TYPE
489: );
490: --
491: TYPE location_tbl is table of location_rec index by

Line 488: end_date per_assignments_f.effective_end_date%TYPE

484: (
485: assignment_id per_assignments_f.assignment_id%TYPE,
486: location_id per_assignments_f.location_id%TYPE,
487: start_date per_assignments_f.effective_start_date%TYPE,
488: end_date per_assignments_f.effective_end_date%TYPE
489: );
490: --
491: TYPE location_tbl is table of location_rec index by
492: binary_integer;

Line 507: l_location_id per_assignments_f.location_id%TYPE;

503: l_county_code pay_us_emp_city_tax_rules_f.county_code%TYPE;
504: l_city_code pay_us_emp_city_tax_rules_f.city_code%TYPE;
505: l_jurisdiction pay_us_emp_city_tax_rules_f.jurisdiction_code%TYPE;
506: l_datetrack_mode varchar2(30);
507: l_location_id per_assignments_f.location_id%TYPE;
508: l_start_date per_assignments_f.effective_start_date%TYPE;
509: l_end_date per_assignments_f.effective_end_date%TYPE;
510: cur_location_id per_assignments_f.location_id%TYPE;
511: cur_start_date per_assignments_f.effective_start_date%TYPE;

Line 508: l_start_date per_assignments_f.effective_start_date%TYPE;

504: l_city_code pay_us_emp_city_tax_rules_f.city_code%TYPE;
505: l_jurisdiction pay_us_emp_city_tax_rules_f.jurisdiction_code%TYPE;
506: l_datetrack_mode varchar2(30);
507: l_location_id per_assignments_f.location_id%TYPE;
508: l_start_date per_assignments_f.effective_start_date%TYPE;
509: l_end_date per_assignments_f.effective_end_date%TYPE;
510: cur_location_id per_assignments_f.location_id%TYPE;
511: cur_start_date per_assignments_f.effective_start_date%TYPE;
512: cur_end_date per_assignments_f.effective_end_date%TYPE;

Line 509: l_end_date per_assignments_f.effective_end_date%TYPE;

505: l_jurisdiction pay_us_emp_city_tax_rules_f.jurisdiction_code%TYPE;
506: l_datetrack_mode varchar2(30);
507: l_location_id per_assignments_f.location_id%TYPE;
508: l_start_date per_assignments_f.effective_start_date%TYPE;
509: l_end_date per_assignments_f.effective_end_date%TYPE;
510: cur_location_id per_assignments_f.location_id%TYPE;
511: cur_start_date per_assignments_f.effective_start_date%TYPE;
512: cur_end_date per_assignments_f.effective_end_date%TYPE;
513: l_effective_start_date pay_us_emp_city_tax_rules_f.effective_start_date%TYPE;

Line 510: cur_location_id per_assignments_f.location_id%TYPE;

506: l_datetrack_mode varchar2(30);
507: l_location_id per_assignments_f.location_id%TYPE;
508: l_start_date per_assignments_f.effective_start_date%TYPE;
509: l_end_date per_assignments_f.effective_end_date%TYPE;
510: cur_location_id per_assignments_f.location_id%TYPE;
511: cur_start_date per_assignments_f.effective_start_date%TYPE;
512: cur_end_date per_assignments_f.effective_end_date%TYPE;
513: l_effective_start_date pay_us_emp_city_tax_rules_f.effective_start_date%TYPE;
514: l_effective_end_date pay_us_emp_city_tax_rules_f.effective_end_date%TYPE;

Line 511: cur_start_date per_assignments_f.effective_start_date%TYPE;

507: l_location_id per_assignments_f.location_id%TYPE;
508: l_start_date per_assignments_f.effective_start_date%TYPE;
509: l_end_date per_assignments_f.effective_end_date%TYPE;
510: cur_location_id per_assignments_f.location_id%TYPE;
511: cur_start_date per_assignments_f.effective_start_date%TYPE;
512: cur_end_date per_assignments_f.effective_end_date%TYPE;
513: l_effective_start_date pay_us_emp_city_tax_rules_f.effective_start_date%TYPE;
514: l_effective_end_date pay_us_emp_city_tax_rules_f.effective_end_date%TYPE;
515: l_assignment_id per_assignments_f.assignment_id%TYPE := null;

Line 512: cur_end_date per_assignments_f.effective_end_date%TYPE;

508: l_start_date per_assignments_f.effective_start_date%TYPE;
509: l_end_date per_assignments_f.effective_end_date%TYPE;
510: cur_location_id per_assignments_f.location_id%TYPE;
511: cur_start_date per_assignments_f.effective_start_date%TYPE;
512: cur_end_date per_assignments_f.effective_end_date%TYPE;
513: l_effective_start_date pay_us_emp_city_tax_rules_f.effective_start_date%TYPE;
514: l_effective_end_date pay_us_emp_city_tax_rules_f.effective_end_date%TYPE;
515: l_assignment_id per_assignments_f.assignment_id%TYPE := null;
516: l_effective_date per_assignments_f.effective_start_date%TYPE := null;

Line 515: l_assignment_id per_assignments_f.assignment_id%TYPE := null;

511: cur_start_date per_assignments_f.effective_start_date%TYPE;
512: cur_end_date per_assignments_f.effective_end_date%TYPE;
513: l_effective_start_date pay_us_emp_city_tax_rules_f.effective_start_date%TYPE;
514: l_effective_end_date pay_us_emp_city_tax_rules_f.effective_end_date%TYPE;
515: l_assignment_id per_assignments_f.assignment_id%TYPE := null;
516: l_effective_date per_assignments_f.effective_start_date%TYPE := null;
517: l_input_value_id pay_input_values_f.input_value_id%TYPE := null;
518: l_input_name pay_input_values_f.name%TYPE := null;
519: l_element_link_id pay_element_links_f.element_link_id%TYPE := null;

Line 516: l_effective_date per_assignments_f.effective_start_date%TYPE := null;

512: cur_end_date per_assignments_f.effective_end_date%TYPE;
513: l_effective_start_date pay_us_emp_city_tax_rules_f.effective_start_date%TYPE;
514: l_effective_end_date pay_us_emp_city_tax_rules_f.effective_end_date%TYPE;
515: l_assignment_id per_assignments_f.assignment_id%TYPE := null;
516: l_effective_date per_assignments_f.effective_start_date%TYPE := null;
517: l_input_value_id pay_input_values_f.input_value_id%TYPE := null;
518: l_input_name pay_input_values_f.name%TYPE := null;
519: l_element_link_id pay_element_links_f.element_link_id%TYPE := null;
520: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE := null;

Line 2560: l_assignment_id per_assignments_f.assignment_id%TYPE;

2556: l_proc varchar2(72) := g_package||'address_change';
2557: l_effective_date date;
2558: l_defaulting_date date;
2559: l_temp_char varchar2(10);
2560: l_assignment_id per_assignments_f.assignment_id%TYPE;
2561: l_person_id per_assignments_f.person_id%TYPE;
2562: l_res_state_code pay_us_states.state_code%TYPE;
2563: l_res_county_code pay_us_counties.county_code%TYPE;
2564: l_res_city_code pay_us_city_names.city_code%TYPE;

Line 2561: l_person_id per_assignments_f.person_id%TYPE;

2557: l_effective_date date;
2558: l_defaulting_date date;
2559: l_temp_char varchar2(10);
2560: l_assignment_id per_assignments_f.assignment_id%TYPE;
2561: l_person_id per_assignments_f.person_id%TYPE;
2562: l_res_state_code pay_us_states.state_code%TYPE;
2563: l_res_county_code pay_us_counties.county_code%TYPE;
2564: l_res_city_code pay_us_city_names.city_code%TYPE;
2565: l_res_ovrd_state_code pay_us_states.state_code%TYPE;

Line 2577: from per_assignments_f asg

2573: where peo.person_id = p_person_id;
2574: --
2575: cursor csr_asg_id is
2576: select asg.person_id
2577: from per_assignments_f asg
2578: where asg.assignment_id = p_assignment_id;
2579: --
2580: cursor csr_per_asg_id is
2581: select asg.assignment_id

Line 2582: from per_assignments_f asg

2578: where asg.assignment_id = p_assignment_id;
2579: --
2580: cursor csr_per_asg_id is
2581: select asg.assignment_id
2582: from per_assignments_f asg
2583: where asg.person_id = p_person_id
2584: and l_effective_date between asg.effective_start_date
2585: and asg.effective_end_date;
2586: --

Line 2800: l_business_group_id per_assignments_f.business_group_id%TYPE;

2796: pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
2797: l_fed_effective_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
2798: l_fed_object_version_number
2799: pay_us_emp_fed_tax_rules_f.object_version_number%TYPE;
2800: l_business_group_id per_assignments_f.business_group_id%TYPE;
2801: l_additional_wa_amount
2802: pay_us_emp_fed_tax_rules_f.additional_wa_amount%TYPE:='0';
2803: l_filing_status_code
2804: pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE:='01';

Line 2834: l_asg_min_start_date per_assignments_f.effective_start_date%TYPE;

2830: l_temp_eff_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
2831: l_temp_ovn pay_us_emp_fed_tax_rules_f.object_version_number%TYPE;
2832: --
2833: l_default_flag varchar2(1) := 'Y';
2834: l_asg_min_start_date per_assignments_f.effective_start_date%TYPE;
2835: l_adr_min_start_date per_addresses.date_from%TYPE;
2836: l_defaulting_date per_assignments_f.effective_start_date%TYPE;
2837:
2838: l_loc_state_code pay_us_states.state_code%TYPE;

Line 2836: l_defaulting_date per_assignments_f.effective_start_date%TYPE;

2832: --
2833: l_default_flag varchar2(1) := 'Y';
2834: l_asg_min_start_date per_assignments_f.effective_start_date%TYPE;
2835: l_adr_min_start_date per_addresses.date_from%TYPE;
2836: l_defaulting_date per_assignments_f.effective_start_date%TYPE;
2837:
2838: l_loc_state_code pay_us_states.state_code%TYPE;
2839: l_loc_ovrd_state_code pay_us_states.state_code%TYPE;
2840: l_loc_county_code pay_us_counties.county_code%TYPE;

Line 2871: from per_assignments_f asg

2867: l_exit_quietly exception;
2868: --
2869: cursor csr_asg_bg_id is
2870: select asg.business_group_id
2871: from per_assignments_f asg
2872: where asg.assignment_id = p_assignment_id
2873: and l_effective_date between asg.effective_start_date
2874: and asg.effective_end_date;
2875: --

Line 2878: from per_assignments_f asg

2874: and asg.effective_end_date;
2875: --
2876: cursor csr_asg_defaulting_date is
2877: select min(asg.effective_start_date)
2878: from per_assignments_f asg
2879: where asg.assignment_id = p_assignment_id
2880: and asg.pay_basis_id is not null
2881: and asg.payroll_id is not null
2882: and asg.soft_coding_keyflex_id is not null

Line 2893: ,per_assignments_f asg

2889: --
2890: cursor csr_adr_defaulting_date is
2891: select min(adr.date_from)
2892: from per_addresses adr
2893: ,per_assignments_f asg
2894: where asg.assignment_id = p_assignment_id
2895: and adr.person_id = asg.person_id
2896: and adr.primary_flag = 'Y';
2897: --

Line 2900: from per_assignments_f

2896: and adr.primary_flag = 'Y';
2897: --
2898: cursor csr_asg_loc_id is
2899: select location_id
2900: from per_assignments_f
2901: where assignment_id = p_assignment_id
2902: and effective_end_date > l_effective_date
2903: order by effective_end_date;
2904:

Line 2907: from per_assignments_f

2903: order by effective_end_date;
2904:
2905: cursor csr_get_asg_details is
2906: select location_id,person_id
2907: from per_assignments_f
2908: where assignment_id = p_assignment_id
2909: and l_defaulting_date between effective_start_date and effective_end_date;
2910: --
2911: --

Line 3308: l_assignment_id per_assignments_f.assignment_id%TYPE;

3304: --
3305: l_proc varchar2(72) := g_package||'maintain_us_employee_taxes';
3306: l_counter number := 0;
3307: l_effective_date date;
3308: l_assignment_id per_assignments_f.assignment_id%TYPE;
3309: l_location_id per_assignments_f.location_id%TYPE;
3310: l_defaulting_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
3311: l_fed_tax_rule_id pay_us_emp_fed_tax_rules_f.emp_fed_tax_rule_id%TYPE;
3312: l_fed_object_version_number

Line 3309: l_location_id per_assignments_f.location_id%TYPE;

3305: l_proc varchar2(72) := g_package||'maintain_us_employee_taxes';
3306: l_counter number := 0;
3307: l_effective_date date;
3308: l_assignment_id per_assignments_f.assignment_id%TYPE;
3309: l_location_id per_assignments_f.location_id%TYPE;
3310: l_defaulting_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
3311: l_fed_tax_rule_id pay_us_emp_fed_tax_rules_f.emp_fed_tax_rule_id%TYPE;
3312: l_fed_object_version_number
3313: pay_us_emp_fed_tax_rules_f.object_version_number%TYPE;

Line 3338: from per_assignments_f asg,

3334: -- rmonge Bug fix 3599825.
3335:
3336: cursor csr_asg_id(p_csr_assignment_id number) is
3337: select null
3338: from per_assignments_f asg,
3339: hr_organization_information bus
3340: where asg.assignment_id = p_csr_assignment_id
3341: and bus.organization_id = asg.business_group_id
3342: and bus.org_information9 = 'US'

Line 3356: from per_assignments_f asg,

3352: where adr.address_id = p_adr_id;
3353: --
3354: cursor csr_adr_asg_id(p_adr_id number) is
3355: select asg.assignment_id
3356: from per_assignments_f asg,
3357: per_addresses adr
3358: where asg.person_id = adr.person_id
3359: and p_effective_date between asg.effective_start_date
3360: and asg.effective_end_date

Line 3646: l_assignment_id per_assignments_f.assignment_id%TYPE;

3642: l_temp_char varchar2(10);
3643: l_default_flag varchar2(1) := 'Y';
3644: l_defaulting_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
3645: l_fed_tax_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
3646: l_assignment_id per_assignments_f.assignment_id%TYPE;
3647: l_business_group_id per_assignments_f.business_group_id%TYPE;
3648: l_location_id per_assignments_f.location_id%TYPE;
3649: l_loc_id per_assignments_f.location_id%TYPE;
3650: l_chg_effective_start_date per_assignments_f.effective_start_date%TYPE;

Line 3647: l_business_group_id per_assignments_f.business_group_id%TYPE;

3643: l_default_flag varchar2(1) := 'Y';
3644: l_defaulting_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
3645: l_fed_tax_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
3646: l_assignment_id per_assignments_f.assignment_id%TYPE;
3647: l_business_group_id per_assignments_f.business_group_id%TYPE;
3648: l_location_id per_assignments_f.location_id%TYPE;
3649: l_loc_id per_assignments_f.location_id%TYPE;
3650: l_chg_effective_start_date per_assignments_f.effective_start_date%TYPE;
3651: l_chg_effective_end_date per_assignments_f.effective_end_date%TYPE;

Line 3648: l_location_id per_assignments_f.location_id%TYPE;

3644: l_defaulting_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
3645: l_fed_tax_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
3646: l_assignment_id per_assignments_f.assignment_id%TYPE;
3647: l_business_group_id per_assignments_f.business_group_id%TYPE;
3648: l_location_id per_assignments_f.location_id%TYPE;
3649: l_loc_id per_assignments_f.location_id%TYPE;
3650: l_chg_effective_start_date per_assignments_f.effective_start_date%TYPE;
3651: l_chg_effective_end_date per_assignments_f.effective_end_date%TYPE;
3652: l_sui_state_code pay_us_states.state_code%TYPE;

Line 3649: l_loc_id per_assignments_f.location_id%TYPE;

3645: l_fed_tax_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
3646: l_assignment_id per_assignments_f.assignment_id%TYPE;
3647: l_business_group_id per_assignments_f.business_group_id%TYPE;
3648: l_location_id per_assignments_f.location_id%TYPE;
3649: l_loc_id per_assignments_f.location_id%TYPE;
3650: l_chg_effective_start_date per_assignments_f.effective_start_date%TYPE;
3651: l_chg_effective_end_date per_assignments_f.effective_end_date%TYPE;
3652: l_sui_state_code pay_us_states.state_code%TYPE;
3653: l_loc_state_code pay_us_states.state_code%TYPE;

Line 3650: l_chg_effective_start_date per_assignments_f.effective_start_date%TYPE;

3646: l_assignment_id per_assignments_f.assignment_id%TYPE;
3647: l_business_group_id per_assignments_f.business_group_id%TYPE;
3648: l_location_id per_assignments_f.location_id%TYPE;
3649: l_loc_id per_assignments_f.location_id%TYPE;
3650: l_chg_effective_start_date per_assignments_f.effective_start_date%TYPE;
3651: l_chg_effective_end_date per_assignments_f.effective_end_date%TYPE;
3652: l_sui_state_code pay_us_states.state_code%TYPE;
3653: l_loc_state_code pay_us_states.state_code%TYPE;
3654: l_loc_ovrd_state_code pay_us_states.state_code%TYPE;

Line 3651: l_chg_effective_end_date per_assignments_f.effective_end_date%TYPE;

3647: l_business_group_id per_assignments_f.business_group_id%TYPE;
3648: l_location_id per_assignments_f.location_id%TYPE;
3649: l_loc_id per_assignments_f.location_id%TYPE;
3650: l_chg_effective_start_date per_assignments_f.effective_start_date%TYPE;
3651: l_chg_effective_end_date per_assignments_f.effective_end_date%TYPE;
3652: l_sui_state_code pay_us_states.state_code%TYPE;
3653: l_loc_state_code pay_us_states.state_code%TYPE;
3654: l_loc_ovrd_state_code pay_us_states.state_code%TYPE;
3655: l_loc_county_code pay_us_counties.county_code%TYPE;

Line 3686: from per_assignments_f asg

3682: where assignment_id = p_assignment_id;
3683: --
3684: cursor csr_asg_data is
3685: select asg.location_id, asg.effective_start_date, asg.effective_end_date
3686: from per_assignments_f asg
3687: where asg.assignment_id = p_assignment_id
3688: and l_effective_date between asg.effective_start_date
3689: and asg.effective_end_date;
3690: --

Line 5233: l_asg_eed per_assignments_f.effective_end_date%TYPE;

5229: l_defaulting_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
5230: l_fed_eed pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
5231: l_default_flag varchar2(1) := 'Y';
5232: l_defaulting_met boolean;
5233: l_asg_eed per_assignments_f.effective_end_date%TYPE;
5234: l_asg_esd per_assignments_f.effective_start_date%TYPE;
5235: l_loc_state_code pay_us_states.state_code%TYPE;
5236: l_loc_county_code pay_us_counties.county_code%TYPE;
5237: l_loc_city_code pay_us_city_names.city_code%TYPE;

Line 5234: l_asg_esd per_assignments_f.effective_start_date%TYPE;

5230: l_fed_eed pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
5231: l_default_flag varchar2(1) := 'Y';
5232: l_defaulting_met boolean;
5233: l_asg_eed per_assignments_f.effective_end_date%TYPE;
5234: l_asg_esd per_assignments_f.effective_start_date%TYPE;
5235: l_loc_state_code pay_us_states.state_code%TYPE;
5236: l_loc_county_code pay_us_counties.county_code%TYPE;
5237: l_loc_city_code pay_us_city_names.city_code%TYPE;
5238: l_loc_ovrd_state_code pay_us_states.state_code%TYPE;

Line 5260: from per_assignments_f paf

5256: l_exit_quietly exception;
5257: --
5258: cursor csr_check_payroll(p_csr_date1 date, p_csr_date2 date) is
5259: select null
5260: from per_assignments_f paf
5261: ,pay_payroll_actions ppa
5262: ,pay_assignment_actions paa
5263: ,pay_run_results prr
5264: where paf.assignment_id = p_assignment_id

Line 5284: from per_assignments_f asg

5280: group by emp_fed_tax_rule_id;
5281: --
5282: cursor csr_asg_data(p_csr_asg_id number, p_csr_eff_date date) is
5283: select asg.effective_start_date, asg.effective_end_date
5284: from per_assignments_f asg
5285: where asg.assignment_id = p_csr_asg_id
5286: and p_csr_eff_date between asg.effective_start_date
5287: and asg.effective_end_date;
5288: --

Line 5291: from per_assignments_f asg

5287: and asg.effective_end_date;
5288: --
5289: cursor csr_assignment_id is
5290: select null
5291: from per_assignments_f asg
5292: where asg.assignment_id = p_assignment_id;
5293: --
5294: -- reimp - added cursor to get current location id
5295: -- since it is not passed in if it is unchanged

Line 5299: from per_assignments_f asg

5295: -- since it is not passed in if it is unchanged
5296:
5297: cursor csr_asg_loc_id(p_date date) is
5298: select location_id
5299: from per_assignments_f asg
5300: where asg.assignment_id = p_assignment_id
5301: and p_date between asg.effective_start_date and asg.effective_end_date;
5302: --
5303: cursor csr_future_fed_rule(l_csr_date date default hr_api.g_date) is

Line 6268: -- Validate p_assignment_id against per_assignments_f

6264: hr_api.mandatory_arg_error(p_api_name => l_proc,
6265: p_argument => 'effective_date',
6266: p_argument_value => l_effective_date);
6267: --
6268: -- Validate p_assignment_id against per_assignments_f
6269: --
6270: if p_assignment_id is null then
6271: hr_utility.set_message(801,'PAY_7702_PDT_VALUE_NOT_FOUND');
6272: hr_utility.raise_error;