APPS.PAY_FR_DB_PAY_SETUP dependencies on PER_BUSINESS_GROUPS

Line 155: from per_business_groups

151: legislation_code
152: into v_business_group_id,
153: v_currency_code,
154: v_legislation_code
155: from per_business_groups
156: where name = p_business_group_name;
157: --
158: -- Set startup data mode
159: v_mode := 'USER';

Line 472: from per_business_groups bg

468: if p_business_group_name is not NULL then
469: --
470: select bg.business_group_id
471: into v_business_group_id
472: from per_business_groups bg
473: where bg.name = p_business_group_name;
474: end if;
475: --
476: -- Ignore the comment above and set the legislation code

Line 824: from per_business_groups bg

820: bg.currency_code
821: into v_business_group_id,
822: v_legislation_code,
823: v_currency_code
824: from per_business_groups bg
825: where name = p_business_group_name;
826: --
827: if g_debug then
828: hr_utility.set_location('pay_db_pay_setup.create_payroll',4);

Line 993: from per_business_groups

989: select pay_consolidation_sets_s.nextval,
990: business_group_id
991: into v_consolidation_set_id,
992: v_business_group_id
993: from per_business_groups
994: where name = p_business_group_name;
995: --
996: insert into pay_consolidation_sets
997: (CONSOLIDATION_SET_ID,

Line 1153: from per_business_groups bg

1149: bg.legislation_code
1150: into v_element_link_id,
1151: v_business_group_id,
1152: v_legislation_code
1153: from per_business_groups bg
1154: where name = p_business_group_name;
1155: --
1156: if g_debug then
1157: hr_utility.set_location('pay_db_pay_setup.create_element_link',2);

Line 1516: from per_business_groups

1512: --
1513: cursor get_bg_leg(p_bg_name varchar2)
1514: is
1515: select legislation_code
1516: from per_business_groups
1517: where name = p_bg_name;
1518: --
1519: cursor get_base_balance(p_base_bal_name varchar2
1520: ,p_ctl_bg number

Line 1604: from per_business_groups

1600: legislation_code
1601: into v_business_group_id,
1602: v_currency_code,
1603: v_legislation_code
1604: from per_business_groups
1605: where name = p_business_group_name;
1606: --
1607: --
1608: -- select the currency for the legislation for potential defaulting

Line 1942: from per_business_groups bg

1938: select bg.business_group_id,
1939: bg.legislation_code
1940: into v_business_group_id,
1941: v_legislation_code
1942: from per_business_groups bg
1943: where bg.name = p_business_group_name;
1944: --
1945: v_startup_mode := 'USER';
1946: --

Line 2127: from per_business_groups

2123: select business_group_id,
2124: legislation_code
2125: into v_business_group_id,
2126: v_legislation_code
2127: from per_business_groups
2128: where name = p_business_group_name;
2129: --
2130: elsif p_legislation_code is not NULL then
2131: --