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 444: INDEX(PAF PER_ASSIGNMENTS_F_PK)

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

Line 447: from per_assignments_f paf,

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

Line 487: assignment_id per_assignments_f.assignment_id%TYPE,

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

Line 488: location_id per_assignments_f.location_id%TYPE,

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

Line 489: start_date per_assignments_f.effective_start_date%TYPE,

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

Line 490: end_date per_assignments_f.effective_end_date%TYPE

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

Line 509: l_location_id per_assignments_f.location_id%TYPE;

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

Line 510: l_start_date per_assignments_f.effective_start_date%TYPE;

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

Line 511: l_end_date per_assignments_f.effective_end_date%TYPE;

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

Line 512: cur_location_id per_assignments_f.location_id%TYPE;

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

Line 513: cur_start_date per_assignments_f.effective_start_date%TYPE;

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

Line 514: cur_end_date per_assignments_f.effective_end_date%TYPE;

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

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

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

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

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

Line 2562: l_assignment_id per_assignments_f.assignment_id%TYPE;

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

Line 2563: l_person_id per_assignments_f.person_id%TYPE;

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

Line 2579: from per_assignments_f asg

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

Line 2584: from per_assignments_f asg

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

Line 2802: l_business_group_id per_assignments_f.business_group_id%TYPE;

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

Line 2836: l_asg_min_start_date per_assignments_f.effective_start_date%TYPE;

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

Line 2838: l_defaulting_date per_assignments_f.effective_start_date%TYPE;

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

Line 2873: from per_assignments_f asg

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

Line 2880: from per_assignments_f asg

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

Line 2895: ,per_assignments_f asg

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

Line 2902: from per_assignments_f

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

Line 2909: from per_assignments_f

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

Line 3310: l_assignment_id per_assignments_f.assignment_id%TYPE;

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

Line 3311: l_location_id per_assignments_f.location_id%TYPE;

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

Line 3343: from per_assignments_f asg,

3339: -- rmonge Bug fix 3599825.
3340:
3341: cursor csr_asg_id(p_csr_assignment_id number) is
3342: select null
3343: from per_assignments_f asg,
3344: hr_organization_information bus
3345: where asg.assignment_id = p_csr_assignment_id
3346: and bus.organization_id = asg.business_group_id
3347: and bus.org_information9 = 'US'

Line 3361: from per_assignments_f asg,

3357: where adr.address_id = p_adr_id;
3358: --
3359: cursor csr_adr_asg_id(p_adr_id number) is
3360: select asg.assignment_id
3361: from per_assignments_f asg,
3362: per_addresses adr
3363: where asg.person_id = adr.person_id
3364: and p_effective_date between asg.effective_start_date
3365: and asg.effective_end_date

Line 3730: l_assignment_id per_assignments_f.assignment_id%TYPE;

3726: l_temp_char varchar2(10);
3727: l_default_flag varchar2(1) := 'Y';
3728: l_defaulting_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
3729: l_fed_tax_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
3730: l_assignment_id per_assignments_f.assignment_id%TYPE;
3731: l_business_group_id per_assignments_f.business_group_id%TYPE;
3732: l_location_id per_assignments_f.location_id%TYPE;
3733: l_loc_id per_assignments_f.location_id%TYPE;
3734: l_chg_effective_start_date per_assignments_f.effective_start_date%TYPE;

Line 3731: l_business_group_id per_assignments_f.business_group_id%TYPE;

3727: l_default_flag varchar2(1) := 'Y';
3728: l_defaulting_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
3729: l_fed_tax_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
3730: l_assignment_id per_assignments_f.assignment_id%TYPE;
3731: l_business_group_id per_assignments_f.business_group_id%TYPE;
3732: l_location_id per_assignments_f.location_id%TYPE;
3733: l_loc_id per_assignments_f.location_id%TYPE;
3734: l_chg_effective_start_date per_assignments_f.effective_start_date%TYPE;
3735: l_chg_effective_end_date per_assignments_f.effective_end_date%TYPE;

Line 3732: l_location_id per_assignments_f.location_id%TYPE;

3728: l_defaulting_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
3729: l_fed_tax_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
3730: l_assignment_id per_assignments_f.assignment_id%TYPE;
3731: l_business_group_id per_assignments_f.business_group_id%TYPE;
3732: l_location_id per_assignments_f.location_id%TYPE;
3733: l_loc_id per_assignments_f.location_id%TYPE;
3734: l_chg_effective_start_date per_assignments_f.effective_start_date%TYPE;
3735: l_chg_effective_end_date per_assignments_f.effective_end_date%TYPE;
3736: l_sui_state_code pay_us_states.state_code%TYPE;

Line 3733: l_loc_id per_assignments_f.location_id%TYPE;

3729: l_fed_tax_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
3730: l_assignment_id per_assignments_f.assignment_id%TYPE;
3731: l_business_group_id per_assignments_f.business_group_id%TYPE;
3732: l_location_id per_assignments_f.location_id%TYPE;
3733: l_loc_id per_assignments_f.location_id%TYPE;
3734: l_chg_effective_start_date per_assignments_f.effective_start_date%TYPE;
3735: l_chg_effective_end_date per_assignments_f.effective_end_date%TYPE;
3736: l_sui_state_code pay_us_states.state_code%TYPE;
3737: l_loc_state_code pay_us_states.state_code%TYPE;

Line 3734: l_chg_effective_start_date per_assignments_f.effective_start_date%TYPE;

3730: l_assignment_id per_assignments_f.assignment_id%TYPE;
3731: l_business_group_id per_assignments_f.business_group_id%TYPE;
3732: l_location_id per_assignments_f.location_id%TYPE;
3733: l_loc_id per_assignments_f.location_id%TYPE;
3734: l_chg_effective_start_date per_assignments_f.effective_start_date%TYPE;
3735: l_chg_effective_end_date per_assignments_f.effective_end_date%TYPE;
3736: l_sui_state_code pay_us_states.state_code%TYPE;
3737: l_loc_state_code pay_us_states.state_code%TYPE;
3738: l_loc_ovrd_state_code pay_us_states.state_code%TYPE;

Line 3735: l_chg_effective_end_date per_assignments_f.effective_end_date%TYPE;

3731: l_business_group_id per_assignments_f.business_group_id%TYPE;
3732: l_location_id per_assignments_f.location_id%TYPE;
3733: l_loc_id per_assignments_f.location_id%TYPE;
3734: l_chg_effective_start_date per_assignments_f.effective_start_date%TYPE;
3735: l_chg_effective_end_date per_assignments_f.effective_end_date%TYPE;
3736: l_sui_state_code pay_us_states.state_code%TYPE;
3737: l_loc_state_code pay_us_states.state_code%TYPE;
3738: l_loc_ovrd_state_code pay_us_states.state_code%TYPE;
3739: l_loc_county_code pay_us_counties.county_code%TYPE;

Line 3770: from per_assignments_f asg

3766: where assignment_id = p_assignment_id;
3767: --
3768: cursor csr_asg_data is
3769: select asg.location_id, asg.effective_start_date, asg.effective_end_date
3770: from per_assignments_f asg
3771: where asg.assignment_id = p_assignment_id
3772: and l_effective_date between asg.effective_start_date
3773: and asg.effective_end_date;
3774: --

Line 5317: l_asg_eed per_assignments_f.effective_end_date%TYPE;

5313: l_defaulting_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
5314: l_fed_eed pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
5315: l_default_flag varchar2(1) := 'Y';
5316: l_defaulting_met boolean;
5317: l_asg_eed per_assignments_f.effective_end_date%TYPE;
5318: l_asg_esd per_assignments_f.effective_start_date%TYPE;
5319: l_loc_state_code pay_us_states.state_code%TYPE;
5320: l_loc_county_code pay_us_counties.county_code%TYPE;
5321: l_loc_city_code pay_us_city_names.city_code%TYPE;

Line 5318: l_asg_esd per_assignments_f.effective_start_date%TYPE;

5314: l_fed_eed pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
5315: l_default_flag varchar2(1) := 'Y';
5316: l_defaulting_met boolean;
5317: l_asg_eed per_assignments_f.effective_end_date%TYPE;
5318: l_asg_esd per_assignments_f.effective_start_date%TYPE;
5319: l_loc_state_code pay_us_states.state_code%TYPE;
5320: l_loc_county_code pay_us_counties.county_code%TYPE;
5321: l_loc_city_code pay_us_city_names.city_code%TYPE;
5322: l_loc_ovrd_state_code pay_us_states.state_code%TYPE;

Line 5344: from per_assignments_f paf

5340: l_exit_quietly exception;
5341: --
5342: cursor csr_check_payroll(p_csr_date1 date, p_csr_date2 date) is
5343: select null
5344: from per_assignments_f paf
5345: ,pay_payroll_actions ppa
5346: ,pay_assignment_actions paa
5347: ,pay_run_results prr
5348: where paf.assignment_id = p_assignment_id

Line 5368: from per_assignments_f asg

5364: group by emp_fed_tax_rule_id;
5365: --
5366: cursor csr_asg_data(p_csr_asg_id number, p_csr_eff_date date) is
5367: select asg.effective_start_date, asg.effective_end_date
5368: from per_assignments_f asg
5369: where asg.assignment_id = p_csr_asg_id
5370: and p_csr_eff_date between asg.effective_start_date
5371: and asg.effective_end_date;
5372: --

Line 5375: from per_assignments_f asg

5371: and asg.effective_end_date;
5372: --
5373: cursor csr_assignment_id is
5374: select null
5375: from per_assignments_f asg
5376: where asg.assignment_id = p_assignment_id;
5377: --
5378: -- reimp - added cursor to get current location id
5379: -- since it is not passed in if it is unchanged

Line 5383: from per_assignments_f asg

5379: -- since it is not passed in if it is unchanged
5380:
5381: cursor csr_asg_loc_id(p_date date) is
5382: select location_id
5383: from per_assignments_f asg
5384: where asg.assignment_id = p_assignment_id
5385: and p_date between asg.effective_start_date and asg.effective_end_date;
5386: --
5387: cursor csr_future_fed_rule(l_csr_date date default hr_api.g_date) is

Line 6352: -- Validate p_assignment_id against per_assignments_f

6348: hr_api.mandatory_arg_error(p_api_name => l_proc,
6349: p_argument => 'effective_date',
6350: p_argument_value => l_effective_date);
6351: --
6352: -- Validate p_assignment_id against per_assignments_f
6353: --
6354: if p_assignment_id is null then
6355: hr_utility.set_message(801,'PAY_7702_PDT_VALUE_NOT_FOUND');
6356: hr_utility.raise_error;