APPS.PAY_DB_PAY_SETUP dependencies on PER_BUSINESS_GROUPS

Line 156: from per_business_groups

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

Line 474: from per_business_groups bg

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

Line 826: from per_business_groups bg

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

Line 995: from per_business_groups

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

Line 1155: from per_business_groups bg

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

Line 1518: from per_business_groups

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

Line 1606: from per_business_groups

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

Line 1943: from per_business_groups bg

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

Line 2120: from per_business_groups

2116: select business_group_id,
2117: legislation_code
2118: into v_business_group_id,
2119: v_legislation_code
2120: from per_business_groups
2121: where name = p_business_group_name;
2122: --
2123: elsif p_legislation_code is not NULL then
2124: --