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 476: from per_business_groups bg

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

Line 849: from per_business_groups bg

845: bg.currency_code
846: into v_business_group_id,
847: v_legislation_code,
848: v_currency_code
849: from per_business_groups bg
850: where name = p_business_group_name;
851: --
852: if g_debug then
853: hr_utility.set_location('pay_db_pay_setup.create_payroll',4);

Line 1018: from per_business_groups

1014: select pay_consolidation_sets_s.nextval,
1015: business_group_id
1016: into v_consolidation_set_id,
1017: v_business_group_id
1018: from per_business_groups
1019: where name = p_business_group_name;
1020: --
1021: insert into pay_consolidation_sets
1022: (CONSOLIDATION_SET_ID,

Line 1178: from per_business_groups bg

1174: bg.legislation_code
1175: into v_element_link_id,
1176: v_business_group_id,
1177: v_legislation_code
1178: from per_business_groups bg
1179: where name = p_business_group_name;
1180: --
1181: if g_debug then
1182: hr_utility.set_location('pay_db_pay_setup.create_element_link',2);

Line 1541: from per_business_groups

1537: --
1538: cursor get_bg_leg(p_bg_name varchar2)
1539: is
1540: select legislation_code
1541: from per_business_groups
1542: where name = p_bg_name;
1543: --
1544: cursor get_base_balance(p_base_bal_name varchar2
1545: ,p_ctl_bg number

Line 1629: from per_business_groups

1625: legislation_code
1626: into v_business_group_id,
1627: v_currency_code,
1628: v_legislation_code
1629: from per_business_groups
1630: where name = p_business_group_name;
1631: --
1632: --
1633: -- select the currency for the legislation for potential defaulting

Line 1966: from per_business_groups bg

1962: select bg.business_group_id,
1963: bg.legislation_code
1964: into v_business_group_id,
1965: v_legislation_code
1966: from per_business_groups bg
1967: where bg.name = p_business_group_name;
1968: --
1969: v_startup_mode := 'USER';
1970: --

Line 2143: from per_business_groups

2139: select business_group_id,
2140: legislation_code
2141: into v_business_group_id,
2142: v_legislation_code
2143: from per_business_groups
2144: where name = p_business_group_name;
2145: --
2146: elsif p_legislation_code is not NULL then
2147: --