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 PAY_LEGISLATION_RULES

Line 5: g_tax_unit pay_legislation_rules.rule_mode%type;

1: package body hr_dynsql as
2: /* $Header: pydynsql.pkb 120.30.12010000.2 2008/10/01 06:13:09 ankagarw ship $ */
3: -- cache for get_tax_unit
4: g_cached boolean := FALSE;
5: g_tax_unit pay_legislation_rules.rule_mode%type;
6: g_local_unit pay_legislation_rules.rule_mode%type;
7: -- Define PL/SQL Table type.
8: type char60_table is table of VARCHAR2(60)
9: index by binary_integer;

Line 6: g_local_unit pay_legislation_rules.rule_mode%type;

2: /* $Header: pydynsql.pkb 120.30.12010000.2 2008/10/01 06:13:09 ankagarw ship $ */
3: -- cache for get_tax_unit
4: g_cached boolean := FALSE;
5: g_tax_unit pay_legislation_rules.rule_mode%type;
6: g_local_unit pay_legislation_rules.rule_mode%type;
7: -- Define PL/SQL Table type.
8: type char60_table is table of VARCHAR2(60)
9: index by binary_integer;
10: --

Line 2960: from pay_legislation_rules p_plr,

2956: and pay_pac.effective_date between p_pee.effective_start_date
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),''-'',''_'' )=

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