eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HRDYNDBI dependencies on PER_BUSINESS_GROUPS_PERF

Line 928: from per_business_groups_perf b

924: or
925: p_legislation_code =
926: (
927: select b.legislation_code
928: from per_business_groups_perf b
929: where b.business_group_id = a.business_group_id
930: )
931: )
932: )

Line 1098: from per_business_groups_perf b

1094: or
1095: p_legislation_code =
1096: (
1097: select b.legislation_code
1098: from per_business_groups_perf b
1099: where b.business_group_id = a.business_group_id
1100: )
1101: )
1102: )

Line 1150: from per_business_groups_perf b

1146: or
1147: p_legislation_code =
1148: (
1149: select b.legislation_code
1150: from per_business_groups_perf b
1151: where b.business_group_id = a.business_group_id
1152: )
1153: )
1154: )

Line 1306: from per_business_groups_perf bg

1302: l_legislation_code := p_legislation_code;
1303: if l_legislation_code is null then
1304: select bg.legislation_code
1305: into l_legislation_code
1306: from per_business_groups_perf bg
1307: where bg.business_group_id = p_business_group_id
1308: ;
1309: end if;
1310: l_full_mls := ff_dbi_utils_pkg.translations_supported(l_legislation_code);

Line 1705: from per_business_groups_perf b

1701: and u.creator_type = 'B')
1702: and mod(defined_balance_id, p_maxworkers) = p_worker_id
1703: and (a.legislation_code = p_leg_code
1704: or exists (select null
1705: from per_business_groups_perf b
1706: where a.business_group_id = b.business_group_id
1707: and nvl(b.legislation_code, p_leg_code) = p_leg_code))
1708: order by a.defined_balance_id;
1709:

Line 1743: from per_business_groups_perf b

1739: ))
1740: and mod(defined_balance_id, p_maxworkers) = p_worker_id
1741: and (a.legislation_code = p_leg_code
1742: or exists (select null
1743: from per_business_groups_perf b
1744: where a.business_group_id = b.business_group_id
1745: and nvl(b.legislation_code, p_leg_code) = p_leg_code))
1746: order by a.defined_balance_id;
1747:

Line 2674: from per_business_groups_perf b

2670: or
2671: p_legislation_code =
2672: (
2673: select b.legislation_code
2674: from per_business_groups_perf b
2675: where b.business_group_id = a.business_group_id
2676: )
2677: )
2678: )

Line 2782: or exists (select null from per_business_groups_perf b

2778: and ent.user_entity_id = dbi.user_entity_id
2779: and ent.creator_type = p_creator_type
2780: and ent.user_entity_name like p_user_entity_name
2781: and (nvl (ent.legislation_code, ' ') = nvl (p_leg_code, ' ')
2782: or exists (select null from per_business_groups_perf b
2783: where ent.business_group_id = b.business_group_id
2784: and nvl(b.legislation_code, p_leg_code) = p_leg_code))
2785: and nvl(ent.creator_id, -1) = nvl(nvl(p_creator_id, ent.creator_id), -1);
2786: --

Line 2798: or exists (select null from per_business_groups_perf b

2794: from ff_formulas_f f
2795: where form.formula_id = f.formula_id
2796: and form.effective_start_date = f.effective_start_date
2797: and (nvl (f.legislation_code, ' ') = nvl (p_leg_code, nvl (f.legislation_code, ' '))
2798: or exists (select null from per_business_groups_perf b
2799: where f.business_group_id = b.business_group_id
2800: and nvl(b.legislation_code, p_leg_code) = p_leg_code));
2801:
2802: if num > 0 then

Line 2855: or exists (select null from per_business_groups_perf b

2851: and exists (select null
2852: from ff_formulas_f f
2853: where fdi.formula_id = f.formula_id
2854: and (nvl (f.legislation_code, ' ') = nvl (p_leg_code, nvl (f.legislation_code, ' '))
2855: or exists (select null from per_business_groups_perf b
2856: where f.business_group_id = b.business_group_id
2857: and nvl(b.legislation_code, p_leg_code) = p_leg_code)))
2858: and exists (select null from
2859: ff_database_items dbi

Line 2868: or exists (select null from per_business_groups_perf b

2864: and ent.creator_id = p_creator_id
2865: and ent.creator_type = p_creator_type
2866: and ent.user_entity_name like p_user_entity_name
2867: and (nvl (ent.legislation_code, ' ') = nvl (p_leg_code, ' ')
2868: or exists (select null from per_business_groups_perf b
2869: where ent.business_group_id = b.business_group_id
2870: and nvl(b.legislation_code, p_leg_code) = p_leg_code))
2871: ))
2872: returning fdi.formula_id, fdi.effective_start_date

Line 3089: from per_business_groups_perf bg

3085: l_legislation_code1 := l_legislation_code;
3086: if l_legislation_code1 is null and l_business_group_id is not null then
3087: select bg.legislation_code
3088: into l_legislation_code1
3089: from per_business_groups_perf bg
3090: where bg.business_group_id = l_business_group_id
3091: ;
3092: end if;
3093: l_full_mls := ff_dbi_utils_pkg.translations_supported(l_legislation_code1);

Line 3615: , per_business_groups_perf BUSGP

3611: select nvl (ltrim(rtrim(ETYPE.legislation_code)),
3612: ltrim(rtrim(BUSGP.legislation_code)))
3613: into l_leg_code_class
3614: from pay_element_types_f ETYPE
3615: , per_business_groups_perf BUSGP
3616: where ETYPE.element_type_id = p_element_type_id
3617: and p_effective_date between ETYPE.effective_start_date
3618: and ETYPE.effective_end_date
3619: and BUSGP.business_group_id (+) = ETYPE.business_group_id;

Line 4060: from per_business_groups_perf bg

4056: l_legislation_code1 := l_legislation_code;
4057: if l_legislation_code1 is null and l_business_group_id is not null then
4058: select bg.legislation_code
4059: into l_legislation_code1
4060: from per_business_groups_perf bg
4061: where bg.business_group_id = l_business_group_id
4062: ;
4063: end if;
4064: l_full_mls := ff_dbi_utils_pkg.translations_supported(l_legislation_code1);

Line 4743: , per_business_groups_perf BUSGP

4739: select nvl (ltrim(rtrim(INPUTV.legislation_code)),
4740: ltrim(rtrim(BUSGP.legislation_code)))
4741: into l_leg_code_ben
4742: from pay_input_values_f INPUTV
4743: , per_business_groups_perf BUSGP
4744: where INPUTV.input_value_id = p_input_value_id
4745: and p_effective_date between INPUTV.effective_start_date
4746: and INPUTV.effective_end_date
4747: and BUSGP.business_group_id (+) = INPUTV.business_group_id;

Line 4938: from per_business_groups_perf b

4934: and u.creator_type = 'E')
4935: and mod(element_type_id, p_maxworkers) = p_worker_id
4936: and (a.legislation_code = p_leg_code
4937: or exists (select null
4938: from per_business_groups_perf b
4939: where a.business_group_id = b.business_group_id
4940: and nvl(b.legislation_code, p_leg_code) = p_leg_code))
4941: group by element_type_id
4942: order by element_type_id;

Line 4956: from per_business_groups_perf b

4952: and u.creator_type = 'I')
4953: and mod(input_value_id, p_maxworkers) = p_worker_id
4954: and (a.legislation_code = p_leg_code
4955: or exists (select null
4956: from per_business_groups_perf b
4957: where a.business_group_id = b.business_group_id
4958: and nvl(b.legislation_code, p_leg_code) = p_leg_code))
4959: group by input_value_id
4960: order by input_value_id;

Line 5108: from per_business_groups_perf b

5104: where u.creator_id = a.input_value_id
5105: and (a.legislation_code = p_leg_code
5106: or exists
5107: (select null
5108: from per_business_groups_perf b
5109: where a.business_group_id = b.business_group_id
5110: and nvl(b.legislation_code, p_leg_code) = p_leg_code)));
5111:
5112: delete ff_user_entities u

Line 5121: from per_business_groups_perf y

5117: where u.creator_id = x.element_type_id
5118: and (x.legislation_code = p_leg_code
5119: or exists
5120: (select null
5121: from per_business_groups_perf y
5122: where x.business_group_id = y.business_group_id
5123: and nvl(y.legislation_code, p_leg_code) = p_leg_code)));
5124:
5125: end delete_element_types;

Line 5561: from per_business_groups_perf b

5557: and
5558: (nvl (ent.legislation_code, ' ') = nvl (p_leg_code, ' ')
5559: or exists
5560: (select null
5561: from per_business_groups_perf b
5562: where ent.business_group_id = b.business_group_id
5563: and nvl(b.legislation_code, p_leg_code) = p_leg_code
5564: )
5565: )

Line 7492: from per_business_groups_perf

7488: l_job_flex_num,
7489: l_position_flex_num,
7490: l_competence_flex_num,
7491: l_legislation_code
7492: from per_business_groups_perf
7493: where business_group_id = p_business_group_id;
7494: --
7495: -- create each of the flexfields
7496: --

Line 8112: from per_business_groups_perf c

8108: or
8109: p_leg_code =
8110: (
8111: select c.legislation_code
8112: from per_business_groups_perf c
8113: where c.business_group_id = b.business_group_id
8114: )
8115: )
8116: )

Line 8161: from per_business_groups_perf c

8157: or
8158: p_leg_code =
8159: (
8160: select c.legislation_code
8161: from per_business_groups_perf c
8162: where c.business_group_id = b.business_group_id
8163: )
8164: )
8165: )

Line 8819: from per_business_groups_perf c

8815: or
8816: p_leg_code =
8817: (
8818: select c.legislation_code
8819: from per_business_groups_perf c
8820: where c.business_group_id = b.business_group_id
8821: )
8822: )
8823: )

Line 8868: from per_business_groups_perf c

8864: or
8865: p_leg_code =
8866: (
8867: select c.legislation_code
8868: from per_business_groups_perf c
8869: where c.business_group_id = b.business_group_id
8870: )
8871: )
8872: )