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.HR_DYNSQL dependencies on PER_BUSINESS_GROUPS_PERF

Line 1908: l_legislation per_business_groups_perf.legislation_code%type;

1904: --
1905: -- Holds the tax unit an assignment belongs to.
1906: --
1907: l_local_unit_id number;
1908: l_legislation per_business_groups_perf.legislation_code%type;
1909: l_business_group_id per_business_groups_perf.business_group_id%type;
1910: plsql_state varchar2(2000); -- used with dynamic pl/sql
1911: sql_cursor integer;
1912: l_rows integer;

Line 1909: l_business_group_id per_business_groups_perf.business_group_id%type;

1905: -- Holds the tax unit an assignment belongs to.
1906: --
1907: l_local_unit_id number;
1908: l_legislation per_business_groups_perf.legislation_code%type;
1909: l_business_group_id per_business_groups_perf.business_group_id%type;
1910: plsql_state varchar2(2000); -- used with dynamic pl/sql
1911: sql_cursor integer;
1912: l_rows integer;
1913: l_found boolean;

Line 1926: per_business_groups_perf pbg

1922: select /*+ INDEX(paf PER_ASSIGNMENTS_F_PK)*/
1923: pbg.legislation_code
1924: into l_legislation
1925: from per_all_assignments_f paf,
1926: per_business_groups_perf pbg
1927: where paf.assignment_id = p_assignment_id
1928: and p_effective_date between paf.effective_start_date
1929: and paf.effective_end_date
1930: and paf.business_group_id = pbg.business_group_id;

Line 1968: per_business_groups_perf pbg

1964: pbg.business_group_id
1965: into l_legislation,
1966: l_business_group_id
1967: from per_all_assignments_f paf,
1968: per_business_groups_perf pbg
1969: where paf.assignment_id = p_assignment_id
1970: and p_effective_date between paf.effective_start_date
1971: and paf.effective_end_date
1972: and paf.business_group_id = pbg.business_group_id;

Line 2072: l_legislation per_business_groups_perf.legislation_code%type;

2068: --
2069: -- Holds the tax unit an assignment belongs to.
2070: --
2071: l_tax_unit_id number;
2072: l_legislation per_business_groups_perf.legislation_code%type;
2073: plsql_state varchar2(2000); -- used with dynamic pl/sql
2074: sql_cursor integer;
2075: l_rows integer;
2076: l_found boolean;

Line 2088: per_business_groups_perf pbg

2084: select /*+ INDEX(paf PER_ASSIGNMENTS_F_PK)*/
2085: pbg.legislation_code
2086: into l_legislation
2087: from per_all_assignments_f paf,
2088: per_business_groups_perf pbg
2089: where paf.assignment_id = p_assignment_id
2090: and p_effective_date between paf.effective_start_date
2091: and paf.effective_end_date
2092: and paf.business_group_id = pbg.business_group_id;

Line 2139: per_business_groups_perf pbg

2135: select /*+ INDEX(paf PER_ASSIGNMENTS_F_PK)*/
2136: pbg.legislation_code
2137: into l_legislation
2138: from per_all_assignments_f paf,
2139: per_business_groups_perf pbg
2140: where paf.assignment_id = p_assignment_id
2141: and p_effective_date between paf.effective_start_date
2142: and paf.effective_end_date
2143: and paf.business_group_id = pbg.business_group_id;

Line 3039: per_business_groups_perf p_pbg

3035: and p_pee.effective_end_date
3036: and p_pee.element_type_id =
3037: (select to_number(p_plr.rule_mode)
3038: from pay_legislation_rules p_plr,
3039: per_business_groups_perf p_pbg
3040: where p_pbg.business_group_id = pay_pac.business_group_id
3041: and p_pbg.legislation_code = p_plr.legislation_code
3042: and TRANSLATE(upper(p_plr.rule_type),''-'',''_'' )=
3043: ''PAY_ADVANCE_INDICATOR'')

Line 3049: from pay_legislation_rules p_plr, per_business_groups_perf p_pbg

3045: and p_pee.element_entry_id = p_pev2.element_entry_id
3046: and p_pev.input_value_id = p_piv.input_value_id
3047: and p_piv2.input_value_id = p_pev2.input_value_id
3048: and p_piv.input_value_id = (select to_number(p_plr.rule_mode)
3049: from pay_legislation_rules p_plr, per_business_groups_perf p_pbg
3050: where p_pbg.business_group_id = pay_pac.business_group_id
3051: and p_pbg.legislation_code = p_plr.legislation_code
3052: and TRANSLATE(upper(p_plr.rule_type),''-'',''_'') = ''PAI_START_DATE'')
3053: and p_piv2.input_value_id = (select to_number(p_plr.rule_mode)

Line 3054: from pay_legislation_rules p_plr, per_business_groups_perf p_pbg

3050: where p_pbg.business_group_id = pay_pac.business_group_id
3051: and p_pbg.legislation_code = p_plr.legislation_code
3052: and TRANSLATE(upper(p_plr.rule_type),''-'',''_'') = ''PAI_START_DATE'')
3053: and p_piv2.input_value_id = (select to_number(p_plr.rule_mode)
3054: from pay_legislation_rules p_plr, per_business_groups_perf p_pbg
3055: where p_pbg.business_group_id = pay_pac.business_group_id
3056: and p_pbg.legislation_code = p_plr.legislation_code
3057: and TRANSLATE(upper(p_plr.rule_type), ''-'',''_'') = ''PAI_END_DATE'')
3058: and not exists (select null

Line 3063: from pay_legislation_rules p_plr2, per_business_groups_perf p_pbg2

3059: from pay_element_entries_f p_pe2
3060: where p_pe2.assignment_id = pay_asg.assignment_id
3061: and p_pe2.element_type_id =
3062: (select to_number(p_plr2.rule_mode)
3063: from pay_legislation_rules p_plr2, per_business_groups_perf p_pbg2
3064: where p_pbg2.business_group_id = pay_pac.business_group_id
3065: and p_pbg2.legislation_code = p_plr2.legislation_code
3066: and TRANSLATE(upper(p_plr2.rule_type), ''-'', ''_'') = ''ADV_DEDUCTION'')
3067: and p_pe2.effective_start_date between