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 330: from per_business_groups pbg, pay_payroll_actions ppa

326: pactid number,
327: p_balance_load_date date
328: ) is
329: select ppa.payroll_action_id
330: from per_business_groups pbg, pay_payroll_actions ppa
331: Where ppa.action_type in ('R', 'Q', 'I', 'B', 'V')
332: and ppa.effective_date >= p_balance_load_date
333: and pbg.business_group_id = ppa.business_group_id
334: and pbg.legislation_code in ( 'US', 'CA');

Line 5316: from per_business_groups pbg, pay_payroll_actions ppa

5312: c_end_pactid number
5313: ) is
5314: select pbg.legislation_code,
5315: ppa.payroll_action_id
5316: from per_business_groups pbg, pay_payroll_actions ppa
5317: Where ppa.payroll_action_id between c_start_pactid and c_end_pactid
5318: and pbg.business_group_id = ppa.business_group_id;
5319:
5320: group_level_bal_ca_rec group_level_bal_ca%ROWTYPE;

Line 5326: l_legislation_code per_business_groups.legislation_code%TYPE;

5322:
5323: l_proc_type pay_us_modified_geocodes.process_type%TYPE;
5324: l_geocode pay_run_balances.jurisdiction_code%TYPE;
5325: l_new_city_code pay_us_modified_geocodes.new_city_code%TYPE;
5326: l_legislation_code per_business_groups.legislation_code%TYPE;
5327: l_pactid pay_payroll_actions.payroll_action_id%TYPE;
5328:
5329: l_row_updated varchar2(1);
5330: