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 55: leg_param pay_payroll_actions.legislative_parameters%type;

51: procedure range_cursor (pactid in number, sqlstr out nocopy varchar2) is
52:
53: --
54:
55: leg_param pay_payroll_actions.legislative_parameters%type;
56: l_year varchar2(4);
57:
58: ln_upgrade_patch pay_patch_status.patch_name%TYPE;
59: --

Line 68: from pay_payroll_actions ppa

64: select ppa.legislative_parameters,
65: pay_us_geo_upd_pkg.get_parameter('PATCH_NAME',PPa.legislative_parameters)
66: into leg_param,
67: ln_upgrade_patch
68: from pay_payroll_actions ppa
69: where ppa.payroll_action_id = pactid;
70:
71: sqlstr := ' select distinct paf.person_id
72: from pay_us_modified_geocodes mg,

Line 99: leg_param pay_payroll_actions.legislative_parameters%type;

95: stperson in number,
96: endperson in number,
97: chunk in number) is
98:
99: leg_param pay_payroll_actions.legislative_parameters%type;
100: l_year varchar2(4);
101: l_geo_phase_id number;
102: l_mode Pay_Payroll_actions.legislative_parameters%type;
103:

Line 102: l_mode Pay_Payroll_actions.legislative_parameters%type;

98:
99: leg_param pay_payroll_actions.legislative_parameters%type;
100: l_year varchar2(4);
101: l_geo_phase_id number;
102: l_mode Pay_Payroll_actions.legislative_parameters%type;
103:
104: l_patch_name pay_patch_status.patch_name%TYPE;
105:
106:

Line 113: from pay_payroll_actions ppa

109: cursor c_parameters ( pactid number) is
110: select ppa.legislative_parameters,
111: pay_us_geo_upd_pkg.get_parameter('PATCH_NAME',PPa.legislative_parameters),
112: pay_us_geo_upd_pkg.get_parameter('MODE',PPa.legislative_parameters)
113: from pay_payroll_actions ppa
114: where ppa.payroll_action_id = pactid;
115:
116:
117: CURSOR c_actions_assignment

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

362: begin
363:
364: sqlstr := 'select paa1.rowid
365: from pay_assignment_actions paa1, -- PYUGEN assignment action
366: pay_payroll_actions ppa1 -- PYUGEN payroll action id
367: where ppa1.payroll_action_id = :pactid
368: and paa1.payroll_action_id = ppa1.payroll_action_id
369: order by paa1.assignment_action_id
370: for update of paa1.assignment_id';

Line 391: from pay_payroll_actions ppa

387: cursor c_parameters ( pactid number) is
388: select ppa.legislative_parameters,
389: pay_us_geo_upd_pkg.get_parameter('PATCH_NAME',PPa.legislative_parameters),
390: pay_us_geo_upd_pkg.get_parameter('MODE',PPa.legislative_parameters)
391: from pay_payroll_actions ppa
392: where ppa.payroll_action_id = pactid;
393:
394: cursor c_get_phase_id (p_patch_name varchar2)
395: is

Line 408: leg_param pay_payroll_actions.legislative_parameters%type;

404:
405: l_geo_phase_id number;
406: l_year varchar2(4);
407: l_mode varchar2(7);
408: leg_param pay_payroll_actions.legislative_parameters%type;
409: l_patch_name pay_patch_status.patch_name%type;
410:
411: BEGIN
412:

Line 488: from pay_payroll_actions ppa

484: cursor c_parameters ( pactid number) is
485: select ppa.legislative_parameters,
486: pay_us_geo_upd_pkg.get_parameter('PATCH_NAME',PPa.legislative_parameters),
487: pay_us_geo_upd_pkg.get_parameter('MODE',PPa.legislative_parameters)
488: from pay_payroll_actions ppa
489: where ppa.payroll_action_id = pactid;
490:
491:
492:

Line 501: leg_param pay_payroll_actions.legislative_parameters%type;

497: lc_status varchar2(1);
498: --
499: ln_upgrade_patch pay_patch_status.patch_name%TYPE;
500: ln_upgrade_patch_id pay_patch_status.id%TYPE;
501: leg_param pay_payroll_actions.legislative_parameters%type;
502: l_year varchar2(4);
503: l_mode pay_payroll_actions.legislative_parameters%type;
504: l_geo_phase_id number;
505:

Line 503: l_mode pay_payroll_actions.legislative_parameters%type;

499: ln_upgrade_patch pay_patch_status.patch_name%TYPE;
500: ln_upgrade_patch_id pay_patch_status.id%TYPE;
501: leg_param pay_payroll_actions.legislative_parameters%type;
502: l_year varchar2(4);
503: l_mode pay_payroll_actions.legislative_parameters%type;
504: l_geo_phase_id number;
505:
506: l_patch_name pay_patch_status.patch_name%TYPE;
507:

Line 919: pay_payroll_actions ppa,

915: faic.context old_juri_code, faic.archive_item_id, ffc.context_id
916: FROM ff_archive_items fai,
917: ff_archive_item_contexts faic,
918: pay_assignment_actions paa,
919: pay_payroll_actions ppa,
920: ff_contexts ffc
921: WHERE ppa.report_type = 'YREND'
922: AND ppa.report_category = 'RT'
923: AND ppa.report_qualifier = 'FED'

Line 950: pay_payroll_actions ppa,

946: ffc.context_id
947: FROM ff_archive_items fai,
948: ff_archive_item_contexts faic,
949: pay_assignment_actions paa,
950: pay_payroll_actions ppa,
951: ff_contexts ffc
952: WHERE ppa.report_type in ('T4', 'T4A', 'RL1', 'RL2', 'YREND')
953: and ppa.report_category in ('RT', 'CAEOYRL1', 'CAEOYRL2', 'CAEOY', 'CAEOY')
954: and report_qualifier in ('FED','CAEOYRL1', 'CAEOYRL2', 'CAEOY', 'CAEOY')

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

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