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.46.12020000.10 2012/12/11 09:32:49 panumala 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.46.12020000.10 2012/12/11 09:32:49 panumala 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 3038: from pay_legislation_rules p_plr,

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

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