DBA Data[Home] [Help]

APPS.HR_PROCESS_PERSON_SS dependencies on PER_BUSINESS_GROUPS_PERF

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 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 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