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.HRASSACT dependencies on PAY_LEGISLATION_RULES

Line 4089: rmode pay_legislation_rules.rule_mode%type;

4085: p_run_type_id in number default null ,
4086: p_mode in varchar2 default 'STANDARD'
4087: ) return number
4088: is
4089: rmode pay_legislation_rules.rule_mode%type;
4090: posid per_periods_of_service.period_of_service_id%type;
4091: actyp pay_payroll_actions.action_type%type;
4092: bgid pay_payroll_actions.business_group_id%type;
4093: l_action_population_status pay_payroll_actions.action_population_status%type;

Line 4346: default_run_type pay_legislation_rules.rule_mode%type;

4342: if (actyp = 'B') then
4343: --
4344: declare
4345: l_rt_id varchar2(10);
4346: default_run_type pay_legislation_rules.rule_mode%type;
4347: begin
4348: if (p_run_type_id is null) then
4349: begin
4350: select rule_mode

Line 4352: from pay_legislation_rules

4348: if (p_run_type_id is null) then
4349: begin
4350: select rule_mode
4351: into default_run_type
4352: from pay_legislation_rules
4353: where legislation_code = lgcode
4354: and rule_type = 'DEFAULT_RUN_TYPE';
4355: exception
4356: when no_data_found then

Line 4647: pay_legislation_rules plr

4643: -- get the rule_mode
4644: select /*+ ORDERED*/ plr.rule_mode
4645: into rmode
4646: from per_business_groups_perf grp,
4647: pay_legislation_rules plr
4648: where grp.business_group_id = bgid
4649: and plr.legislation_code = grp.legislation_code
4650: and plr.rule_type = 'I'
4651: and plr.rule_mode in ('Y','N','G');

Line 5155: l_rule_mode pay_legislation_rules.rule_mode%type;

5151: l_process_path pay_assignment_actions.process_path%type;
5152: l_found boolean;
5153: l_inp_val_name pay_input_values_f.name%type;
5154: l_rev_lat_bal_maintenance boolean;
5155: l_rule_mode pay_legislation_rules.rule_mode%type;
5156: l_si_needed pay_legislation_rules.rule_mode%type;
5157: l_st_needed pay_legislation_rules.rule_mode%type;
5158: l_sn_needed pay_legislation_rules.rule_mode%type;
5159: l_sn2_needed pay_legislation_rules.rule_mode%type;

Line 5156: l_si_needed pay_legislation_rules.rule_mode%type;

5152: l_found boolean;
5153: l_inp_val_name pay_input_values_f.name%type;
5154: l_rev_lat_bal_maintenance boolean;
5155: l_rule_mode pay_legislation_rules.rule_mode%type;
5156: l_si_needed pay_legislation_rules.rule_mode%type;
5157: l_st_needed pay_legislation_rules.rule_mode%type;
5158: l_sn_needed pay_legislation_rules.rule_mode%type;
5159: l_sn2_needed pay_legislation_rules.rule_mode%type;
5160: l_org_needed pay_legislation_rules.rule_mode%type;

Line 5157: l_st_needed pay_legislation_rules.rule_mode%type;

5153: l_inp_val_name pay_input_values_f.name%type;
5154: l_rev_lat_bal_maintenance boolean;
5155: l_rule_mode pay_legislation_rules.rule_mode%type;
5156: l_si_needed pay_legislation_rules.rule_mode%type;
5157: l_st_needed pay_legislation_rules.rule_mode%type;
5158: l_sn_needed pay_legislation_rules.rule_mode%type;
5159: l_sn2_needed pay_legislation_rules.rule_mode%type;
5160: l_org_needed pay_legislation_rules.rule_mode%type;
5161: l_st2_needed pay_legislation_rules.rule_mode%type;

Line 5158: l_sn_needed pay_legislation_rules.rule_mode%type;

5154: l_rev_lat_bal_maintenance boolean;
5155: l_rule_mode pay_legislation_rules.rule_mode%type;
5156: l_si_needed pay_legislation_rules.rule_mode%type;
5157: l_st_needed pay_legislation_rules.rule_mode%type;
5158: l_sn_needed pay_legislation_rules.rule_mode%type;
5159: l_sn2_needed pay_legislation_rules.rule_mode%type;
5160: l_org_needed pay_legislation_rules.rule_mode%type;
5161: l_st2_needed pay_legislation_rules.rule_mode%type;
5162: l_value pay_action_parameters.parameter_value%type;

Line 5159: l_sn2_needed pay_legislation_rules.rule_mode%type;

5155: l_rule_mode pay_legislation_rules.rule_mode%type;
5156: l_si_needed pay_legislation_rules.rule_mode%type;
5157: l_st_needed pay_legislation_rules.rule_mode%type;
5158: l_sn_needed pay_legislation_rules.rule_mode%type;
5159: l_sn2_needed pay_legislation_rules.rule_mode%type;
5160: l_org_needed pay_legislation_rules.rule_mode%type;
5161: l_st2_needed pay_legislation_rules.rule_mode%type;
5162: l_value pay_action_parameters.parameter_value%type;
5163: l_tax_group hr_organization_information.org_information5%type;

Line 5160: l_org_needed pay_legislation_rules.rule_mode%type;

5156: l_si_needed pay_legislation_rules.rule_mode%type;
5157: l_st_needed pay_legislation_rules.rule_mode%type;
5158: l_sn_needed pay_legislation_rules.rule_mode%type;
5159: l_sn2_needed pay_legislation_rules.rule_mode%type;
5160: l_org_needed pay_legislation_rules.rule_mode%type;
5161: l_st2_needed pay_legislation_rules.rule_mode%type;
5162: l_value pay_action_parameters.parameter_value%type;
5163: l_tax_group hr_organization_information.org_information5%type;
5164: begin

Line 5161: l_st2_needed pay_legislation_rules.rule_mode%type;

5157: l_st_needed pay_legislation_rules.rule_mode%type;
5158: l_sn_needed pay_legislation_rules.rule_mode%type;
5159: l_sn2_needed pay_legislation_rules.rule_mode%type;
5160: l_org_needed pay_legislation_rules.rule_mode%type;
5161: l_st2_needed pay_legislation_rules.rule_mode%type;
5162: l_value pay_action_parameters.parameter_value%type;
5163: l_tax_group hr_organization_information.org_information5%type;
5164: begin
5165: g_debug := hr_utility.debug_enabled;

Line 5954: source_iv pay_legislation_rules.rule_type%type;

5950: --
5951: cxt_id number;
5952: cnt number;
5953: pay_id number;
5954: source_iv pay_legislation_rules.rule_type%type;
5955: source_text_iv pay_legislation_rules.rule_type%type;
5956: jurisdiction_iv pay_legislation_rules.rule_type%type;
5957: action_contexts boolean;
5958: l_def_jur_str varchar2(2000); -- used with dynamic pl/sql

Line 5955: source_text_iv pay_legislation_rules.rule_type%type;

5951: cxt_id number;
5952: cnt number;
5953: pay_id number;
5954: source_iv pay_legislation_rules.rule_type%type;
5955: source_text_iv pay_legislation_rules.rule_type%type;
5956: jurisdiction_iv pay_legislation_rules.rule_type%type;
5957: action_contexts boolean;
5958: l_def_jur_str varchar2(2000); -- used with dynamic pl/sql
5959: l_ctx_balance_date date;

Line 5956: jurisdiction_iv pay_legislation_rules.rule_type%type;

5952: cnt number;
5953: pay_id number;
5954: source_iv pay_legislation_rules.rule_type%type;
5955: source_text_iv pay_legislation_rules.rule_type%type;
5956: jurisdiction_iv pay_legislation_rules.rule_type%type;
5957: action_contexts boolean;
5958: l_def_jur_str varchar2(2000); -- used with dynamic pl/sql
5959: l_ctx_balance_date date;
5960: l_ctx_time_def_id number;

Line 6007: from pay_legislation_rules plr

6003: hr_utility.set_location(c_indent,20);
6004: end if;
6005: select 1
6006: into dummy
6007: from pay_legislation_rules plr
6008: where p_legcode = plr.legislation_code
6009: and plr.rule_type = 'ACTION_CONTEXTS'
6010: and plr.rule_mode = 'Y';
6011: --

Line 6398: legcode pay_legislation_rules.legislation_code%TYPE; -- leg code

6394: ) is
6395: c_indent constant varchar2(32) := 'hrassact.bal_adjust_actions';
6396: pactid number; -- payroll_action_id.
6397: busgrp number; -- business_group_id.
6398: legcode pay_legislation_rules.legislation_code%TYPE; -- leg code
6399: asgid number; -- assignment_id.
6400: payid number; -- payroll_id.
6401: tperiod number; -- time_period_id.
6402: dtearned date; -- date_earned.

Line 6420: from pay_legislation_rules

6416: l_dummy varchar2(1);
6417: --
6418: cursor csr_time_period_leg (p_leg_code in varchar2) is
6419: select 'Y'
6420: from pay_legislation_rules
6421: where rule_type = 'TIME_PERIOD_ID'
6422: and legislation_code = p_leg_code
6423: and rule_mode = 'Y';
6424: --

Line 6878: l_rule_mode pay_legislation_rules.rule_mode%TYPE;

6874: balance_expiry_level pay_balance_dimensions.expiry_checking_level%TYPE;
6875: bal_context_string varchar2(2000);
6876: bal_fed boolean;
6877: l_change_flag boolean;
6878: l_rule_mode pay_legislation_rules.rule_mode%TYPE;
6879: not_supported boolean;
6880: l_status varchar2(30);
6881: dummy_date date;
6882:

Line 8172: from pay_legislation_rules plr,

8168: if g_ba_lat_bal_maintenance is null then
8169: begin
8170: select rule_mode
8171: into l_rule_mode
8172: from pay_legislation_rules plr,
8173: per_business_groups_perf pbg
8174: where pbg.business_group_id = bus_grp_id
8175: and plr.legislation_code = pbg.legislation_code
8176: and rule_type = 'BAL_ADJ_LAT_BAL';