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_US_GEO_UPD_PKG dependencies on PER_BUSINESS_GROUPS

Line 168: from per_business_groups pbg, pay_payroll_actions ppa

164: pactid number,
165: p_balance_load_date date
166: ) is
167: select ppa.payroll_action_id
168: from per_business_groups pbg, pay_payroll_actions ppa
169: Where ppa.action_type in ('R', 'Q', 'I', 'B', 'V')
170: and ppa.effective_date >= p_balance_load_date
171: and pbg.business_group_id = ppa.business_group_id
172: and pbg.legislation_code in ( 'US', 'CA');

Line 4044: from per_business_groups pbg, pay_payroll_actions ppa

4040: c_end_pactid number
4041: ) is
4042: select pbg.legislation_code,
4043: ppa.payroll_action_id
4044: from per_business_groups pbg, pay_payroll_actions ppa
4045: Where ppa.payroll_action_id between c_start_pactid and c_end_pactid
4046: and pbg.business_group_id = ppa.business_group_id;
4047:
4048: group_level_bal_ca_rec group_level_bal_ca%ROWTYPE;

Line 4054: l_legislation_code per_business_groups.legislation_code%TYPE;

4050:
4051: l_proc_type pay_us_modified_geocodes.process_type%TYPE;
4052: l_geocode pay_run_balances.jurisdiction_code%TYPE;
4053: l_new_city_code pay_us_modified_geocodes.new_city_code%TYPE;
4054: l_legislation_code per_business_groups.legislation_code%TYPE;
4055: l_pactid pay_payroll_actions.payroll_action_id%TYPE;
4056:
4057: l_row_updated varchar2(1);
4058: