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.HR_PROCESS_PERSON_SS dependencies on PER_ADDRESSES

Line 1852: from per_addresses a

1848: where business_group_id = p_business_group_id;
1849:
1850: cursor csr_add_style is
1851: select style
1852: from per_addresses a
1853: where a.person_id = p_person_id and a.primary_flag = 'Y'
1854: and p_effective_date between a.date_from and nvl(a.date_to,hr_api.g_eot);
1855:
1856:

Line 1859: from per_addresses a

1855:
1856:
1857: cursor csr_get_region1 is
1858: select region_1
1859: from per_addresses a
1860: where a.person_id = p_person_id and a.primary_flag = 'Y'
1861: and p_effective_date between a.date_from and nvl(a.date_to,hr_api.g_eot);
1862:
1863:

Line 1865: l_style per_addresses.style%TYPE := '1';

1861: and p_effective_date between a.date_from and nvl(a.date_to,hr_api.g_eot);
1862:
1863:
1864:
1865: l_style per_addresses.style%TYPE := '1';
1866: l_style_old per_addresses.style%TYPE := '1';
1867: l_legislation_code per_business_groups.legislation_code%TYPE;
1868: l_region1_old per_addresses.region_1%TYPE := '1';
1869: l_region1 per_addresses.region_1%TYPE := '1';

Line 1866: l_style_old per_addresses.style%TYPE := '1';

1862:
1863:
1864:
1865: l_style per_addresses.style%TYPE := '1';
1866: l_style_old per_addresses.style%TYPE := '1';
1867: l_legislation_code per_business_groups.legislation_code%TYPE;
1868: l_region1_old per_addresses.region_1%TYPE := '1';
1869: l_region1 per_addresses.region_1%TYPE := '1';
1870:

Line 1868: l_region1_old per_addresses.region_1%TYPE := '1';

1864:
1865: l_style per_addresses.style%TYPE := '1';
1866: l_style_old per_addresses.style%TYPE := '1';
1867: l_legislation_code per_business_groups.legislation_code%TYPE;
1868: l_region1_old per_addresses.region_1%TYPE := '1';
1869: l_region1 per_addresses.region_1%TYPE := '1';
1870:
1871: p_job_name varchar2(700);
1872: p_org_name varchar2(240);

Line 1869: l_region1 per_addresses.region_1%TYPE := '1';

1865: l_style per_addresses.style%TYPE := '1';
1866: l_style_old per_addresses.style%TYPE := '1';
1867: l_legislation_code per_business_groups.legislation_code%TYPE;
1868: l_region1_old per_addresses.region_1%TYPE := '1';
1869: l_region1 per_addresses.region_1%TYPE := '1';
1870:
1871: p_job_name varchar2(700);
1872: p_org_name varchar2(240);
1873:

Line 2074: update per_addresses set style = 'US' ,region_1 ='Snohomish'

2070: if l_style <> 'US' then
2071:
2072: if hr_general2.is_legislation_install('PAY','US') then
2073: l_style := 'US';
2074: update per_addresses set style = 'US' ,region_1 ='Snohomish'
2075: where person_id = p_person_id and primary_flag = 'Y'
2076: and p_effective_date between date_from and nvl(date_to,hr_api.g_eot);
2077:
2078: end if;

Line 2102: update per_addresses set style = l_style_old, region_1=l_region1_old

2098: -- Bug Fix 13336753
2099:
2100: if l_style <> l_style_old then
2101:
2102: update per_addresses set style = l_style_old, region_1=l_region1_old
2103: where person_id = p_person_id and primary_flag = 'Y'
2104: and p_effective_date between date_from and nvl(date_to,hr_api.g_eot);
2105:
2106: end if;

Line 5648: from per_addresses a

5644: where business_group_id = p_business_group_id;
5645:
5646: cursor csr_add_style(p_person_id in varchar2, p_effective_date in date ) is
5647: select style
5648: from per_addresses a
5649: where a.person_id = p_person_id and a.primary_flag = 'Y'
5650: and p_effective_date between a.date_from and nvl(a.date_to,hr_api.g_eot);
5651:
5652: cursor csr_get_region1(p_person_id in varchar2, p_effective_date in date ) is

Line 5654: from per_addresses a

5650: and p_effective_date between a.date_from and nvl(a.date_to,hr_api.g_eot);
5651:
5652: cursor csr_get_region1(p_person_id in varchar2, p_effective_date in date ) is
5653: select region_1
5654: from per_addresses a
5655: where a.person_id = p_person_id and a.primary_flag = 'Y'
5656: and p_effective_date between a.date_from and nvl(a.date_to,hr_api.g_eot);
5657:
5658: l_style per_addresses.style%TYPE := '1';

Line 5658: l_style per_addresses.style%TYPE := '1';

5654: from per_addresses a
5655: where a.person_id = p_person_id and a.primary_flag = 'Y'
5656: and p_effective_date between a.date_from and nvl(a.date_to,hr_api.g_eot);
5657:
5658: l_style per_addresses.style%TYPE := '1';
5659: l_style_old per_addresses.style%TYPE := '1';
5660: l_legislation_code per_business_groups.legislation_code%TYPE;
5661: l_region1_old per_addresses.region_1%TYPE := '1';
5662: l_region1 per_addresses.region_1%TYPE := '1';

Line 5659: l_style_old per_addresses.style%TYPE := '1';

5655: where a.person_id = p_person_id and a.primary_flag = 'Y'
5656: and p_effective_date between a.date_from and nvl(a.date_to,hr_api.g_eot);
5657:
5658: l_style per_addresses.style%TYPE := '1';
5659: l_style_old per_addresses.style%TYPE := '1';
5660: l_legislation_code per_business_groups.legislation_code%TYPE;
5661: l_region1_old per_addresses.region_1%TYPE := '1';
5662: l_region1 per_addresses.region_1%TYPE := '1';
5663:

Line 5661: l_region1_old per_addresses.region_1%TYPE := '1';

5657:
5658: l_style per_addresses.style%TYPE := '1';
5659: l_style_old per_addresses.style%TYPE := '1';
5660: l_legislation_code per_business_groups.legislation_code%TYPE;
5661: l_region1_old per_addresses.region_1%TYPE := '1';
5662: l_region1 per_addresses.region_1%TYPE := '1';
5663:
5664: dummy_payroll_id number;
5665: l_is_payroll_upd boolean := false;

Line 5662: l_region1 per_addresses.region_1%TYPE := '1';

5658: l_style per_addresses.style%TYPE := '1';
5659: l_style_old per_addresses.style%TYPE := '1';
5660: l_legislation_code per_business_groups.legislation_code%TYPE;
5661: l_region1_old per_addresses.region_1%TYPE := '1';
5662: l_region1 per_addresses.region_1%TYPE := '1';
5663:
5664: dummy_payroll_id number;
5665: l_is_payroll_upd boolean := false;
5666: l_leg_code_row csr_leg_code%rowtype;

Line 5897: update per_addresses set style = 'US' ,region_1 ='Snohomish'

5893:
5894: if hr_general2.is_legislation_install('PAY','US') then
5895:
5896: l_style := 'US';
5897: update per_addresses set style = 'US' ,region_1 ='Snohomish'
5898: where person_id = l_person_id and primary_flag = 'Y'
5899: and l_effective_date between date_from and nvl(date_to,hr_api.g_eot);
5900:
5901: end if;

Line 5923: update per_addresses set style = l_style_old, region_1 = l_region1_old

5919: -- ,p_original_date_of_hire => l_original_date_of_hire); --bug 4416684, pass original_date_of_hire
5920:
5921: if l_style <> l_style_old then
5922:
5923: update per_addresses set style = l_style_old, region_1 = l_region1_old
5924: where person_id = l_person_id and primary_flag = 'Y'
5925: and l_effective_date between date_from and nvl(date_to,hr_api.g_eot);
5926:
5927: end if;

Line 9371: l_address_line1 per_addresses.address_line1%type;

9367: ,p_soft_coding_keyflex_id in number default null
9368: ,p_is_payroll_upd out nocopy boolean
9369: ) is
9370:
9371: l_address_line1 per_addresses.address_line1%type;
9372: l_date_of_birth per_all_people_f.date_of_birth%type;
9373: l_legislation_code per_business_groups.legislation_code%TYPE;
9374: l_leg_code per_business_groups.legislation_code%TYPE;
9375:

Line 9383: select address_line1 from per_addresses

9379: and p_effective_date between effective_start_date
9380: and effective_end_date;
9381:
9382: cursor csr_pradd_exists is
9383: select address_line1 from per_addresses
9384: where person_id = p_person_id and primary_flag='Y'
9385: and ( (style='US' and region_1 is not null)
9386: or style<>'US');
9387: