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 1873: l_legislation per_business_groups_perf.legislation_code%type;

1869: --
1870: -- Holds the tax unit an assignment belongs to.
1871: --
1872: l_local_unit_id number;
1873: l_legislation per_business_groups_perf.legislation_code%type;
1874: l_business_group_id per_business_groups_perf.business_group_id%type;
1875: plsql_state varchar2(2000); -- used with dynamic pl/sql
1876: sql_cursor integer;
1877: l_rows integer;

Line 1874: l_business_group_id per_business_groups_perf.business_group_id%type;

1870: -- Holds the tax unit an assignment belongs to.
1871: --
1872: l_local_unit_id number;
1873: l_legislation per_business_groups_perf.legislation_code%type;
1874: l_business_group_id per_business_groups_perf.business_group_id%type;
1875: plsql_state varchar2(2000); -- used with dynamic pl/sql
1876: sql_cursor integer;
1877: l_rows integer;
1878: l_found boolean;

Line 1891: per_business_groups_perf pbg

1887: select /*+ INDEX(paf PER_ASSIGNMENTS_F_PK)*/
1888: pbg.legislation_code
1889: into l_legislation
1890: from per_all_assignments_f paf,
1891: per_business_groups_perf pbg
1892: where paf.assignment_id = p_assignment_id
1893: and p_effective_date between paf.effective_start_date
1894: and paf.effective_end_date
1895: and paf.business_group_id = pbg.business_group_id;

Line 1933: per_business_groups_perf pbg

1929: pbg.business_group_id
1930: into l_legislation,
1931: l_business_group_id
1932: from per_all_assignments_f paf,
1933: per_business_groups_perf pbg
1934: where paf.assignment_id = p_assignment_id
1935: and p_effective_date between paf.effective_start_date
1936: and paf.effective_end_date
1937: and paf.business_group_id = pbg.business_group_id;

Line 2037: l_legislation per_business_groups_perf.legislation_code%type;

2033: --
2034: -- Holds the tax unit an assignment belongs to.
2035: --
2036: l_tax_unit_id number;
2037: l_legislation per_business_groups_perf.legislation_code%type;
2038: plsql_state varchar2(2000); -- used with dynamic pl/sql
2039: sql_cursor integer;
2040: l_rows integer;
2041: l_found boolean;

Line 2053: per_business_groups_perf pbg

2049: select /*+ INDEX(paf PER_ASSIGNMENTS_F_PK)*/
2050: pbg.legislation_code
2051: into l_legislation
2052: from per_all_assignments_f paf,
2053: per_business_groups_perf pbg
2054: where paf.assignment_id = p_assignment_id
2055: and p_effective_date between paf.effective_start_date
2056: and paf.effective_end_date
2057: and paf.business_group_id = pbg.business_group_id;

Line 2104: per_business_groups_perf pbg

2100: select /*+ INDEX(paf PER_ASSIGNMENTS_F_PK)*/
2101: pbg.legislation_code
2102: into l_legislation
2103: from per_all_assignments_f paf,
2104: per_business_groups_perf pbg
2105: where paf.assignment_id = p_assignment_id
2106: and p_effective_date between paf.effective_start_date
2107: and paf.effective_end_date
2108: and paf.business_group_id = pbg.business_group_id;

Line 2961: per_business_groups_perf p_pbg

2957: and p_pee.effective_end_date
2958: and p_pee.element_type_id =
2959: (select to_number(p_plr.rule_mode)
2960: from pay_legislation_rules p_plr,
2961: per_business_groups_perf p_pbg
2962: where p_pbg.business_group_id = pay_pac.business_group_id
2963: and p_pbg.legislation_code = p_plr.legislation_code
2964: and TRANSLATE(upper(p_plr.rule_type),''-'',''_'' )=
2965: ''PAY_ADVANCE_INDICATOR'')

Line 2971: from pay_legislation_rules p_plr, per_business_groups_perf p_pbg

2967: and p_pee.element_entry_id = p_pev2.element_entry_id
2968: and p_pev.input_value_id = p_piv.input_value_id
2969: and p_piv2.input_value_id = p_pev2.input_value_id
2970: and p_piv.input_value_id = (select to_number(p_plr.rule_mode)
2971: from pay_legislation_rules p_plr, per_business_groups_perf p_pbg
2972: where p_pbg.business_group_id = pay_pac.business_group_id
2973: and p_pbg.legislation_code = p_plr.legislation_code
2974: and TRANSLATE(upper(p_plr.rule_type),''-'',''_'') = ''PAI_START_DATE'')
2975: and p_piv2.input_value_id = (select to_number(p_plr.rule_mode)

Line 2976: from pay_legislation_rules p_plr, per_business_groups_perf p_pbg

2972: where p_pbg.business_group_id = pay_pac.business_group_id
2973: and p_pbg.legislation_code = p_plr.legislation_code
2974: and TRANSLATE(upper(p_plr.rule_type),''-'',''_'') = ''PAI_START_DATE'')
2975: and p_piv2.input_value_id = (select to_number(p_plr.rule_mode)
2976: from pay_legislation_rules p_plr, per_business_groups_perf p_pbg
2977: where p_pbg.business_group_id = pay_pac.business_group_id
2978: and p_pbg.legislation_code = p_plr.legislation_code
2979: and TRANSLATE(upper(p_plr.rule_type), ''-'',''_'') = ''PAI_END_DATE'')
2980: and not exists (select null

Line 2985: from pay_legislation_rules p_plr2, per_business_groups_perf p_pbg2

2981: from pay_element_entries_f p_pe2
2982: where p_pe2.assignment_id = pay_asg.assignment_id
2983: and p_pe2.element_type_id =
2984: (select to_number(p_plr2.rule_mode)
2985: from pay_legislation_rules p_plr2, per_business_groups_perf p_pbg2
2986: where p_pbg2.business_group_id = pay_pac.business_group_id
2987: and p_pbg2.legislation_code = p_plr2.legislation_code
2988: and TRANSLATE(upper(p_plr2.rule_type), ''-'', ''_'') = ''ADV_DEDUCTION'')
2989: and p_pe2.effective_start_date between