APPS.HR_NMF_SYNC dependencies on PER_BUSINESS_GROUPS_PERF

Line 62: (select distinct legislation_code from per_business_groups_perf)

58: ,nmf.user_format_choice
59: ,nmf.format_mask
60: from HR_NAME_FORMATS nmf
61: where nmf.legislation_code in
62: (select distinct legislation_code from per_business_groups_perf)
63: and ((cp_formatName is not null and nmf.format_name = cp_formatName)
64: OR (cp_formatName is null))
65: and ((cp_scope is not null and nmf.user_format_choice = cp_scope)
66: OR (cp_scope is null));

Line 185: from PER_BUSINESS_GROUPS_PERF bg

181: PROCEDURE cache_bg_info(p_legislation_code in varchar2) IS
182: --
183: cursor csr_get_bgs(cp_legCode varchar2) is
184: select legislation_code, business_group_id, name
185: from PER_BUSINESS_GROUPS_PERF bg
186: where ((cp_legCode is not null and bg.legislation_code = cp_legCode)
187: or (cp_legCode is null));
188: --
189: BEGIN

Line 296: (select distinct legislation_code from per_business_groups_perf);

292: cursor csr_get_legislations is
293: select leg.territory_code legislation_code
294: from fnd_territories_vl leg
295: where leg.territory_code in
296: (select distinct legislation_code from per_business_groups_perf);
297: --
298: BEGIN
299: --
300: if g_seeded_pkg_cached = FALSE then

Line 726: from PER_BUSINESS_GROUPS_PERF bg

722: l_bg_list varchar2(4000);
723: --
724: cursor csr_get_bgs(cp_legCode varchar2) is
725: select business_group_id
726: from PER_BUSINESS_GROUPS_PERF bg
727: where bg.legislation_code = cp_legCode;
728: --
729: BEGIN
730: select pay_core_utils.get_parameter('LEGISLATION_CODE',

Line 750: ,per_business_groups_perf bg

746: order by per.person_id';
747: else
748: sqlstr := 'select distinct per.person_id
749: from per_all_people_f per
750: ,per_business_groups_perf bg
751: where :payroll_action_id > 0
752: and bg.business_group_id = per.business_group_id
753: and bg.legislation_code = '||''''||l_leg_code||''''||
754: ' order by per.person_id';

Line 776: l_legislation_code per_business_groups_perf.legislation_code%TYPE;

772: --
773: l_temp_person_id per_all_people_f.person_id%TYPE;
774: l_lockingactid pay_assignment_actions.assignment_action_id%TYPE;
775: l_business_group_id number;
776: l_legislation_code per_business_groups_perf.legislation_code%TYPE;
777: --
778: cursor csr_actions(cp_pactid number
779: ,cp_stperson number
780: ,cp_endperson number

Line 784: ,per_business_groups_perf bg

780: ,cp_endperson number
781: ,cp_leg_code varchar2) is -- #4571033
782: select distinct ppf.person_id
783: from per_all_people_f ppf
784: ,per_business_groups_perf bg
785: ,pay_payroll_actions ppa
786: where ppf.person_id between cp_stperson and cp_endperson
787: and ppa.payroll_action_id = cp_pactid
788: and ppf.business_group_id = bg.business_group_id

Line 1155: ,per_business_groups_perf bg

1151: --
1152: cursor csr_get_rows_toUpd is
1153: select peo.rowid, bg.legislation_code
1154: from per_all_people_f peo
1155: ,per_business_groups_perf bg
1156: where (peo.global_name is null or peo.local_name is null)
1157: and peo.business_group_id = bg.business_group_id;
1158: --
1159: BEGIN