APPS.HR_PROCESS_PERSON_SS dependencies on PER_BUSINESS_GROUPS

Line 1847: from per_business_groups_perf

1843: and DESCRIPTIVE_FLEX_CONTEXT_CODE = 'US_ETHNIC_ORIGIN';
1844:
1845: cursor csr_get_legc_code is
1846: select legislation_code
1847: from per_business_groups_perf
1848: where business_group_id = p_business_group_id;
1849:
1850: cursor csr_add_style is
1851: select style

Line 1867: l_legislation_code per_business_groups.legislation_code%TYPE;

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:
1871: p_job_name varchar2(700);

Line 5643: from per_business_groups_perf

5639: order by asg.assignment_id;
5640:
5641: cursor csr_get_legc_code (p_business_group_id in varchar2) is
5642: select legislation_code
5643: from per_business_groups_perf
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

Line 5660: l_legislation_code per_business_groups.legislation_code%TYPE;

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:
5664: dummy_payroll_id number;

Line 9373: l_legislation_code per_business_groups.legislation_code%TYPE;

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:
9376: cursor csr_get_person_dob is
9377: select date_of_birth from per_people_f

Line 9374: l_leg_code per_business_groups.legislation_code%TYPE;

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:
9376: cursor csr_get_person_dob is
9377: select date_of_birth from per_people_f
9378: where person_id = p_person_id

Line 9389: select legislation_code from per_business_groups_perf

9385: and ( (style='US' and region_1 is not null)
9386: or style<>'US');
9387:
9388: cursor csr_get_legc_code is
9389: select legislation_code from per_business_groups_perf
9390: where business_group_id = p_business_group_id;
9391:
9392: cursor csr_pay_legislation_rules is
9393: select legislation_code from pay_legislation_rules