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 PAY_PAYROLL_ACTIONS

Line 24: token_val pay_payroll_actions.legislative_parameters%type;

20: parameter_list varchar2) return varchar2
21: is
22: start_ptr number;
23: end_ptr number;
24: token_val pay_payroll_actions.legislative_parameters%type;
25: par_value pay_payroll_actions.legislative_parameters%type;
26: begin
27: --
28: token_val := name||'=';

Line 25: par_value pay_payroll_actions.legislative_parameters%type;

21: is
22: start_ptr number;
23: end_ptr number;
24: token_val pay_payroll_actions.legislative_parameters%type;
25: par_value pay_payroll_actions.legislative_parameters%type;
26: begin
27: --
28: token_val := name||'=';
29: --

Line 215: leg_param pay_payroll_actions.legislative_parameters%type;

211: procedure range_cursor (pactid in number, sqlstr out nocopy varchar2) is
212:
213: --
214:
215: leg_param pay_payroll_actions.legislative_parameters%type;
216: l_year varchar2(4);
217:
218: ln_upgrade_patch pay_patch_status.patch_name%TYPE;
219: --

Line 228: from pay_payroll_actions ppa

224: select ppa.legislative_parameters,
225: pay_us_geo_upd_pkg.get_parameter('PATCH_NAME',PPa.legislative_parameters)
226: into leg_param,
227: ln_upgrade_patch
228: from pay_payroll_actions ppa
229: where ppa.payroll_action_id = pactid;
230:
231: sqlstr := ' select distinct paf.person_id
232: from pay_us_modified_geocodes mg,

Line 259: leg_param pay_payroll_actions.legislative_parameters%type;

255: stperson in number,
256: endperson in number,
257: chunk in number) is
258:
259: leg_param pay_payroll_actions.legislative_parameters%type;
260: l_year varchar2(4);
261: l_geo_phase_id number;
262: l_mode Pay_Payroll_actions.legislative_parameters%type;
263:

Line 262: l_mode Pay_Payroll_actions.legislative_parameters%type;

258:
259: leg_param pay_payroll_actions.legislative_parameters%type;
260: l_year varchar2(4);
261: l_geo_phase_id number;
262: l_mode Pay_Payroll_actions.legislative_parameters%type;
263:
264: l_patch_name pay_patch_status.patch_name%TYPE;
265:
266:

Line 273: from pay_payroll_actions ppa

269: cursor c_parameters ( pactid number) is
270: select ppa.legislative_parameters,
271: pay_us_geo_upd_pkg.get_parameter('PATCH_NAME',PPa.legislative_parameters),
272: pay_us_geo_upd_pkg.get_parameter('MODE',PPa.legislative_parameters)
273: from pay_payroll_actions ppa
274: where ppa.payroll_action_id = pactid;
275:
276:
277: CURSOR c_actions_assignment

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 565: pay_payroll_actions ppa1 -- PYUGEN payroll action id

561: begin
562:
563: sqlstr := 'select paa1.rowid
564: from pay_assignment_actions paa1, -- PYUGEN assignment action
565: pay_payroll_actions ppa1 -- PYUGEN payroll action id
566: where ppa1.payroll_action_id = :pactid
567: and paa1.payroll_action_id = ppa1.payroll_action_id
568: order by paa1.assignment_action_id
569: for update of paa1.assignment_id';

Line 590: from pay_payroll_actions ppa

586: cursor c_parameters ( pactid number) is
587: select ppa.legislative_parameters,
588: pay_us_geo_upd_pkg.get_parameter('PATCH_NAME',PPa.legislative_parameters),
589: pay_us_geo_upd_pkg.get_parameter('MODE',PPa.legislative_parameters)
590: from pay_payroll_actions ppa
591: where ppa.payroll_action_id = pactid;
592:
593: cursor c_get_phase_id (p_patch_name varchar2)
594: is

Line 607: leg_param pay_payroll_actions.legislative_parameters%type;

603:
604: l_geo_phase_id number;
605: l_year varchar2(4);
606: l_mode varchar2(7);
607: leg_param pay_payroll_actions.legislative_parameters%type;
608: l_patch_name pay_patch_status.patch_name%type;
609:
610: BEGIN
611:

Line 687: from pay_payroll_actions ppa

683: cursor c_parameters ( pactid number) is
684: select ppa.legislative_parameters,
685: pay_us_geo_upd_pkg.get_parameter('PATCH_NAME',PPa.legislative_parameters),
686: pay_us_geo_upd_pkg.get_parameter('MODE',PPa.legislative_parameters)
687: from pay_payroll_actions ppa
688: where ppa.payroll_action_id = pactid;
689:
690:
691:

Line 700: leg_param pay_payroll_actions.legislative_parameters%type;

696: lc_status varchar2(1);
697: --
698: ln_upgrade_patch pay_patch_status.patch_name%TYPE;
699: ln_upgrade_patch_id pay_patch_status.id%TYPE;
700: leg_param pay_payroll_actions.legislative_parameters%type;
701: l_year varchar2(4);
702: l_mode pay_payroll_actions.legislative_parameters%type;
703: l_geo_phase_id number;
704:

Line 702: l_mode pay_payroll_actions.legislative_parameters%type;

698: ln_upgrade_patch pay_patch_status.patch_name%TYPE;
699: ln_upgrade_patch_id pay_patch_status.id%TYPE;
700: leg_param pay_payroll_actions.legislative_parameters%type;
701: l_year varchar2(4);
702: l_mode pay_payroll_actions.legislative_parameters%type;
703: l_geo_phase_id number;
704:
705: l_patch_name pay_patch_status.patch_name%TYPE;
706:

Line 1128: pay_payroll_actions ppa,

1124: faic.context old_juri_code, faic.archive_item_id, ffc.context_id
1125: FROM ff_archive_items fai,
1126: ff_archive_item_contexts faic,
1127: pay_assignment_actions paa,
1128: pay_payroll_actions ppa,
1129: ff_contexts ffc
1130: WHERE ppa.report_type = 'YREND'
1131: AND ppa.report_category = 'RT'
1132: AND ppa.report_qualifier = 'FED'

Line 1159: pay_payroll_actions ppa,

1155: ffc.context_id
1156: FROM ff_archive_items fai,
1157: ff_archive_item_contexts faic,
1158: pay_assignment_actions paa,
1159: pay_payroll_actions ppa,
1160: ff_contexts ffc
1161: WHERE ppa.report_type in ('T4', 'T4A', 'RL1', 'RL2', 'YREND')
1162: and ppa.report_category in ('RT', 'CAEOYRL1', 'CAEOYRL2', 'CAEOY', 'CAEOY')
1163: and report_qualifier in ('FED','CAEOYRL1', 'CAEOYRL2', 'CAEOY', 'CAEOY')

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 5327: l_pactid pay_payroll_actions.payroll_action_id%TYPE;

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:
5331: l_error_message_text varchar2(240);