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 4109: rmode pay_legislation_rules.rule_mode%type;

4105: p_run_type_id in number default null ,
4106: p_mode in varchar2 default 'STANDARD'
4107: ) return number
4108: is
4109: rmode pay_legislation_rules.rule_mode%type;
4110: posid per_periods_of_service.period_of_service_id%type;
4111: actyp pay_payroll_actions.action_type%type;
4112: bgid pay_payroll_actions.business_group_id%type;
4113: l_action_population_status pay_payroll_actions.action_population_status%type;

Line 4366: default_run_type pay_legislation_rules.rule_mode%type;

4362: if (actyp = 'B') then
4363: --
4364: declare
4365: l_rt_id varchar2(10);
4366: default_run_type pay_legislation_rules.rule_mode%type;
4367: begin
4368: if (p_run_type_id is null) then
4369: begin
4370: select rule_mode

Line 4372: from pay_legislation_rules

4368: if (p_run_type_id is null) then
4369: begin
4370: select rule_mode
4371: into default_run_type
4372: from pay_legislation_rules
4373: where legislation_code = lgcode
4374: and rule_type = 'DEFAULT_RUN_TYPE';
4375: exception
4376: when no_data_found then

Line 4667: pay_legislation_rules plr

4663: -- get the rule_mode
4664: select /*+ ORDERED*/ plr.rule_mode
4665: into rmode
4666: from per_business_groups_perf grp,
4667: pay_legislation_rules plr
4668: where grp.business_group_id = bgid
4669: and plr.legislation_code = grp.legislation_code
4670: and plr.rule_type = 'I'
4671: and plr.rule_mode in ('Y','N','G');

Line 5387: l_rule_mode pay_legislation_rules.rule_mode%type;

5383: l_process_path pay_assignment_actions.process_path%type;
5384: l_found boolean;
5385: l_inp_val_name pay_input_values_f.name%type;
5386: l_rev_lat_bal_maintenance boolean;
5387: l_rule_mode pay_legislation_rules.rule_mode%type;
5388: l_si_needed pay_legislation_rules.rule_mode%type;
5389: l_st_needed pay_legislation_rules.rule_mode%type;
5390: l_sn_needed pay_legislation_rules.rule_mode%type;
5391: l_sn2_needed pay_legislation_rules.rule_mode%type;

Line 5388: l_si_needed pay_legislation_rules.rule_mode%type;

5384: l_found boolean;
5385: l_inp_val_name pay_input_values_f.name%type;
5386: l_rev_lat_bal_maintenance boolean;
5387: l_rule_mode pay_legislation_rules.rule_mode%type;
5388: l_si_needed pay_legislation_rules.rule_mode%type;
5389: l_st_needed pay_legislation_rules.rule_mode%type;
5390: l_sn_needed pay_legislation_rules.rule_mode%type;
5391: l_sn2_needed pay_legislation_rules.rule_mode%type;
5392: l_org_needed pay_legislation_rules.rule_mode%type;

Line 5389: l_st_needed pay_legislation_rules.rule_mode%type;

5385: l_inp_val_name pay_input_values_f.name%type;
5386: l_rev_lat_bal_maintenance boolean;
5387: l_rule_mode pay_legislation_rules.rule_mode%type;
5388: l_si_needed pay_legislation_rules.rule_mode%type;
5389: l_st_needed pay_legislation_rules.rule_mode%type;
5390: l_sn_needed pay_legislation_rules.rule_mode%type;
5391: l_sn2_needed pay_legislation_rules.rule_mode%type;
5392: l_org_needed pay_legislation_rules.rule_mode%type;
5393: l_st2_needed pay_legislation_rules.rule_mode%type;

Line 5390: l_sn_needed pay_legislation_rules.rule_mode%type;

5386: l_rev_lat_bal_maintenance boolean;
5387: l_rule_mode pay_legislation_rules.rule_mode%type;
5388: l_si_needed pay_legislation_rules.rule_mode%type;
5389: l_st_needed pay_legislation_rules.rule_mode%type;
5390: l_sn_needed pay_legislation_rules.rule_mode%type;
5391: l_sn2_needed pay_legislation_rules.rule_mode%type;
5392: l_org_needed pay_legislation_rules.rule_mode%type;
5393: l_st2_needed pay_legislation_rules.rule_mode%type;
5394: l_value pay_action_parameters.parameter_value%type;

Line 5391: l_sn2_needed pay_legislation_rules.rule_mode%type;

5387: l_rule_mode pay_legislation_rules.rule_mode%type;
5388: l_si_needed pay_legislation_rules.rule_mode%type;
5389: l_st_needed pay_legislation_rules.rule_mode%type;
5390: l_sn_needed pay_legislation_rules.rule_mode%type;
5391: l_sn2_needed pay_legislation_rules.rule_mode%type;
5392: l_org_needed pay_legislation_rules.rule_mode%type;
5393: l_st2_needed pay_legislation_rules.rule_mode%type;
5394: l_value pay_action_parameters.parameter_value%type;
5395: l_tax_group hr_organization_information.org_information5%type;

Line 5392: l_org_needed pay_legislation_rules.rule_mode%type;

5388: l_si_needed pay_legislation_rules.rule_mode%type;
5389: l_st_needed pay_legislation_rules.rule_mode%type;
5390: l_sn_needed pay_legislation_rules.rule_mode%type;
5391: l_sn2_needed pay_legislation_rules.rule_mode%type;
5392: l_org_needed pay_legislation_rules.rule_mode%type;
5393: l_st2_needed pay_legislation_rules.rule_mode%type;
5394: l_value pay_action_parameters.parameter_value%type;
5395: l_tax_group hr_organization_information.org_information5%type;
5396: begin

Line 5393: l_st2_needed pay_legislation_rules.rule_mode%type;

5389: l_st_needed pay_legislation_rules.rule_mode%type;
5390: l_sn_needed pay_legislation_rules.rule_mode%type;
5391: l_sn2_needed pay_legislation_rules.rule_mode%type;
5392: l_org_needed pay_legislation_rules.rule_mode%type;
5393: l_st2_needed pay_legislation_rules.rule_mode%type;
5394: l_value pay_action_parameters.parameter_value%type;
5395: l_tax_group hr_organization_information.org_information5%type;
5396: begin
5397: g_debug := hr_utility.debug_enabled;

Line 6218: source_iv pay_legislation_rules.rule_type%type;

6214: --
6215: cxt_id number;
6216: cnt number;
6217: pay_id number;
6218: source_iv pay_legislation_rules.rule_type%type;
6219: source_text_iv pay_legislation_rules.rule_type%type;
6220: jurisdiction_iv pay_legislation_rules.rule_type%type;
6221: action_contexts boolean;
6222: l_def_jur_str varchar2(2000); -- used with dynamic pl/sql

Line 6219: source_text_iv pay_legislation_rules.rule_type%type;

6215: cxt_id number;
6216: cnt number;
6217: pay_id number;
6218: source_iv pay_legislation_rules.rule_type%type;
6219: source_text_iv pay_legislation_rules.rule_type%type;
6220: jurisdiction_iv pay_legislation_rules.rule_type%type;
6221: action_contexts boolean;
6222: l_def_jur_str varchar2(2000); -- used with dynamic pl/sql
6223: l_ctx_balance_date date;

Line 6220: jurisdiction_iv pay_legislation_rules.rule_type%type;

6216: cnt number;
6217: pay_id number;
6218: source_iv pay_legislation_rules.rule_type%type;
6219: source_text_iv pay_legislation_rules.rule_type%type;
6220: jurisdiction_iv pay_legislation_rules.rule_type%type;
6221: action_contexts boolean;
6222: l_def_jur_str varchar2(2000); -- used with dynamic pl/sql
6223: l_ctx_balance_date date;
6224: l_ctx_time_def_id number;

Line 6271: from pay_legislation_rules plr

6267: hr_utility.set_location(c_indent,20);
6268: end if;
6269: select 1
6270: into dummy
6271: from pay_legislation_rules plr
6272: where p_legcode = plr.legislation_code
6273: and plr.rule_type = 'ACTION_CONTEXTS'
6274: and plr.rule_mode = 'Y';
6275: --

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

6658: ) is
6659: c_indent constant varchar2(32) := 'hrassact.bal_adjust_actions';
6660: pactid number; -- payroll_action_id.
6661: busgrp number; -- business_group_id.
6662: legcode pay_legislation_rules.legislation_code%TYPE; -- leg code
6663: asgid number; -- assignment_id.
6664: payid number; -- payroll_id.
6665: tperiod number; -- time_period_id.
6666: dtearned date; -- date_earned.

Line 6684: from pay_legislation_rules

6680: l_dummy varchar2(1);
6681: --
6682: cursor csr_time_period_leg (p_leg_code in varchar2) is
6683: select 'Y'
6684: from pay_legislation_rules
6685: where rule_type = 'TIME_PERIOD_ID'
6686: and legislation_code = p_leg_code
6687: and rule_mode = 'Y';
6688: --

Line 7142: l_rule_mode pay_legislation_rules.rule_mode%TYPE;

7138: balance_expiry_level pay_balance_dimensions.expiry_checking_level%TYPE;
7139: bal_context_string varchar2(2000);
7140: bal_fed boolean;
7141: l_change_flag boolean;
7142: l_rule_mode pay_legislation_rules.rule_mode%TYPE;
7143: not_supported boolean;
7144: l_status varchar2(30);
7145: dummy_date date;
7146:

Line 8740: pay_legislation_rules plr

8736: begin
8737: select /*+ ORDERED*/ plr.rule_mode
8738: into v_r_mode
8739: from per_business_groups_perf grp,
8740: pay_legislation_rules plr
8741: where grp.business_group_id = v_business_group_id
8742: and plr.legislation_code = grp.legislation_code
8743: and plr.rule_type = 'I'
8744: and plr.rule_mode in ('Y','N','G');