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 925: from per_business_groups_perf b

921: or
922: p_legislation_code =
923: (
924: select b.legislation_code
925: from per_business_groups_perf b
926: where b.business_group_id = a.business_group_id
927: )
928: )
929: )

Line 1095: from per_business_groups_perf b

1091: or
1092: p_legislation_code =
1093: (
1094: select b.legislation_code
1095: from per_business_groups_perf b
1096: where b.business_group_id = a.business_group_id
1097: )
1098: )
1099: )

Line 1147: from per_business_groups_perf b

1143: or
1144: p_legislation_code =
1145: (
1146: select b.legislation_code
1147: from per_business_groups_perf b
1148: where b.business_group_id = a.business_group_id
1149: )
1150: )
1151: )

Line 1303: from per_business_groups_perf bg

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

Line 1702: from per_business_groups_perf b

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

Line 1740: from per_business_groups_perf b

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

Line 2671: from per_business_groups_perf b

2667: or
2668: p_legislation_code =
2669: (
2670: select b.legislation_code
2671: from per_business_groups_perf b
2672: where b.business_group_id = a.business_group_id
2673: )
2674: )
2675: )

Line 2779: or exists (select null from per_business_groups_perf b

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

Line 2795: or exists (select null from per_business_groups_perf b

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

Line 2852: or exists (select null from per_business_groups_perf b

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

Line 2865: or exists (select null from per_business_groups_perf b

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

Line 3086: from per_business_groups_perf bg

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

Line 3612: , per_business_groups_perf BUSGP

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

Line 4057: from per_business_groups_perf bg

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

Line 4740: , per_business_groups_perf BUSGP

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

Line 4935: from per_business_groups_perf b

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

Line 4953: from per_business_groups_perf b

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

Line 5105: from per_business_groups_perf b

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

Line 5118: from per_business_groups_perf y

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

Line 5558: from per_business_groups_perf b

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

Line 7415: from per_business_groups_perf

7411: l_job_flex_num,
7412: l_position_flex_num,
7413: l_competence_flex_num,
7414: l_legislation_code
7415: from per_business_groups_perf
7416: where business_group_id = p_business_group_id;
7417: --
7418: -- create each of the flexfields
7419: --

Line 8035: from per_business_groups_perf c

8031: or
8032: p_leg_code =
8033: (
8034: select c.legislation_code
8035: from per_business_groups_perf c
8036: where c.business_group_id = b.business_group_id
8037: )
8038: )
8039: )

Line 8084: from per_business_groups_perf c

8080: or
8081: p_leg_code =
8082: (
8083: select c.legislation_code
8084: from per_business_groups_perf c
8085: where c.business_group_id = b.business_group_id
8086: )
8087: )
8088: )

Line 8742: from per_business_groups_perf c

8738: or
8739: p_leg_code =
8740: (
8741: select c.legislation_code
8742: from per_business_groups_perf c
8743: where c.business_group_id = b.business_group_id
8744: )
8745: )
8746: )

Line 8791: from per_business_groups_perf c

8787: or
8788: p_leg_code =
8789: (
8790: select c.legislation_code
8791: from per_business_groups_perf c
8792: where c.business_group_id = b.business_group_id
8793: )
8794: )
8795: )