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.PAY_CA_ARCHIVE_RULES dependencies on PAY_CORE_UTILS

Line 62: l_pre_organization_id := pay_core_utils.get_parameter('TRANSFER_PRE',lv_legislative_param);

58: select ppa.legislative_parameters
59: into lv_legislative_param
60: from pay_payroll_actions ppa
61: where payroll_action_id = pactid;
62: l_pre_organization_id := pay_core_utils.get_parameter('TRANSFER_PRE',lv_legislative_param);
63: l_gre_id := pay_core_utils.get_parameter('TRANSFER_GRE',lv_legislative_param);
64:
65: if (l_gre_id is not null) then
66: sqlstr := 'AND PAA.tax_unit_id = '||to_number(l_gre_id);

Line 63: l_gre_id := pay_core_utils.get_parameter('TRANSFER_GRE',lv_legislative_param);

59: into lv_legislative_param
60: from pay_payroll_actions ppa
61: where payroll_action_id = pactid;
62: l_pre_organization_id := pay_core_utils.get_parameter('TRANSFER_PRE',lv_legislative_param);
63: l_gre_id := pay_core_utils.get_parameter('TRANSFER_GRE',lv_legislative_param);
64:
65: if (l_gre_id is not null) then
66: sqlstr := 'AND PAA.tax_unit_id = '||to_number(l_gre_id);
67: elsif (l_pre_organization_id is not null) then

Line 103: pay_core_utils.get_parameter('TRANSFER_GRE',legislative_parameters),

99: l_proc := gv_package_name||'action_creation';
100: hr_utility.set_location(l_proc, 10);
101: hr_utility.trace('PACTID = '||to_char(pactid));
102: SELECT effective_date,
103: pay_core_utils.get_parameter('TRANSFER_GRE',legislative_parameters),
104: pay_core_utils.get_parameter('TRANSFER_PRE',legislative_parameters),
105: pay_core_utils.get_parameter('REPORT_TYPE',legislative_parameters)
106: INTO ld_effective_date,
107: ln_tax_unit_id,

Line 104: pay_core_utils.get_parameter('TRANSFER_PRE',legislative_parameters),

100: hr_utility.set_location(l_proc, 10);
101: hr_utility.trace('PACTID = '||to_char(pactid));
102: SELECT effective_date,
103: pay_core_utils.get_parameter('TRANSFER_GRE',legislative_parameters),
104: pay_core_utils.get_parameter('TRANSFER_PRE',legislative_parameters),
105: pay_core_utils.get_parameter('REPORT_TYPE',legislative_parameters)
106: INTO ld_effective_date,
107: ln_tax_unit_id,
108: l_pre_organization_id,

Line 105: pay_core_utils.get_parameter('REPORT_TYPE',legislative_parameters)

101: hr_utility.trace('PACTID = '||to_char(pactid));
102: SELECT effective_date,
103: pay_core_utils.get_parameter('TRANSFER_GRE',legislative_parameters),
104: pay_core_utils.get_parameter('TRANSFER_PRE',legislative_parameters),
105: pay_core_utils.get_parameter('REPORT_TYPE',legislative_parameters)
106: INTO ld_effective_date,
107: ln_tax_unit_id,
108: l_pre_organization_id,
109: l_report_type

Line 177: l_pre_organization_id := pay_core_utils.get_parameter('TRANSFER_PRE',lv_legislative_param);

173: select ppa.legislative_parameters
174: into lv_legislative_param
175: from pay_payroll_actions ppa
176: where payroll_action_id = pactid;
177: l_pre_organization_id := pay_core_utils.get_parameter('TRANSFER_PRE',lv_legislative_param);
178: l_gre_id := pay_core_utils.get_parameter('TRANSFER_GRE',lv_legislative_param);
179: if (l_gre_id is not null) then
180: sqlstr := 'AND PAA.tax_unit_id = '||to_number(l_gre_id);
181: elsif (l_pre_organization_id is not null) then

Line 178: l_gre_id := pay_core_utils.get_parameter('TRANSFER_GRE',lv_legislative_param);

174: into lv_legislative_param
175: from pay_payroll_actions ppa
176: where payroll_action_id = pactid;
177: l_pre_organization_id := pay_core_utils.get_parameter('TRANSFER_PRE',lv_legislative_param);
178: l_gre_id := pay_core_utils.get_parameter('TRANSFER_GRE',lv_legislative_param);
179: if (l_gre_id is not null) then
180: sqlstr := 'AND PAA.tax_unit_id = '||to_number(l_gre_id);
181: elsif (l_pre_organization_id is not null) then
182: sqlstr := 'AND exists