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_EOY_RL2_AMEND_REG dependencies on PAY_PAYROLL_ACTIONS

Line 70: from pay_payroll_actions ppa

66: effective_date,
67: start_date,
68: business_group_id,
69: report_type
70: from pay_payroll_actions ppa
71: where ppa.payroll_action_id = cp_payroll_action_id;
72:
73: ld_end_date DATE;
74: ld_start_date DATE;

Line 190: from pay_payroll_actions ppa_arch,

186: elsif ln_pre_org_id is not NULL then
187:
188: lv_sql_string :=
189: 'select distinct paf.person_id
190: from pay_payroll_actions ppa_arch,
191: pay_assignment_actions paa_arch,
192: per_assignments_f paf,
193: pay_payroll_actions ppa
194: where paa_arch.assignment_id = paf.assignment_id

Line 193: pay_payroll_actions ppa

189: 'select distinct paf.person_id
190: from pay_payroll_actions ppa_arch,
191: pay_assignment_actions paa_arch,
192: per_assignments_f paf,
193: pay_payroll_actions ppa
194: where paa_arch.assignment_id = paf.assignment_id
195: and ppa.payroll_action_id = :payroll_action_id
196: and ppa_arch.business_group_id = ppa.business_group_id
197: and ppa_arch.effective_date = ppa.effective_date

Line 209: from pay_payroll_actions ppa_arch,

205: else
206:
207: lv_sql_string :=
208: 'select distinct paf.person_id
209: from pay_payroll_actions ppa_arch,
210: pay_assignment_actions paa_arch,
211: per_assignments_f paf,
212: pay_payroll_actions ppa
213: where paa_arch.assignment_id = paf.assignment_id

Line 212: pay_payroll_actions ppa

208: 'select distinct paf.person_id
209: from pay_payroll_actions ppa_arch,
210: pay_assignment_actions paa_arch,
211: per_assignments_f paf,
212: pay_payroll_actions ppa
213: where paa_arch.assignment_id = paf.assignment_id
214: and ppa.payroll_action_id = :payroll_action_id
215: and ppa_arch.business_group_id = ppa.business_group_id
216: and ppa_arch.effective_date = ppa.effective_date

Line 265: lv_report_type pay_payroll_actions.report_type%TYPE ;

261: ln_set_person_id NUMBER := 0 ;
262: ln_asg_set NUMBER := 0 ;
263: lv_print varchar2(10);
264:
265: lv_report_type pay_payroll_actions.report_type%TYPE ;
266: ln_asg_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;
267:
268: lv_serial_number VARCHAR2(30);
269: lv_employee_number per_people_f.employee_number%type;

Line 283: pay_payroll_actions ppa_arch,

279: ,cp_effective_date in date) is
280: select distinct paf.person_id
281: from hr_assignment_set_amendments asgset,
282: per_assignments_f paf,
283: pay_payroll_actions ppa_arch,
284: pay_assignment_actions paa_arch
285: where asgset.assignment_set_id = cp_asg_set
286: and asgset.include_or_exclude = 'I'
287: and paf.assignment_id = asgset.assignment_id

Line 316: FROM pay_payroll_actions ppa ,

312: fnd_date.canonical_to_date('4712/12/31 00:00:00')) >= cp_eff_date
313: AND hoi.org_information_context = 'Prov Reporting Est'
314: AND hoi.org_information4 = 'P02'
315: AND exists ( SELECT 1
316: FROM pay_payroll_actions ppa ,
317: pay_assignment_actions paa
318: WHERE ppa.report_type = 'CAEOY_RL2_AMEND_PP'
319: AND ppa.report_qualifier = 'CAEOY_RL2_AMEND_PPQ'
320: AND ppa.business_group_id = cp_bg_id

Line 332: from pay_payroll_actions ppa_arch,

328: cp_eff_date date,
329: cp_start_person number,
330: cp_end_person number) is
331: select distinct paa_arch.serial_number
332: from pay_payroll_actions ppa_arch,
333: pay_assignment_actions paa_arch
334: where ppa_arch.business_group_id = cp_bg_id
335: and ppa_arch.report_type = 'CAEOY_RL2_AMEND_PP'
336: AND ppa_arch.report_qualifier = 'CAEOY_RL2_AMEND_PPQ'

Line 360: from pay_payroll_actions ppa,

356: paa.assignment_id,
357: paa.assignment_action_id,
358: pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
359: ppa.legislative_parameters)
360: from pay_payroll_actions ppa,
361: pay_assignment_actions paa
362: where paa.serial_number = to_char(cp_person_id)
363: and pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
364: ppa.legislative_parameters) =

Line 391: from pay_payroll_actions ppa,

387: paa.assignment_id,
388: paa.assignment_action_id,
389: pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
390: ppa.legislative_parameters)
391: from pay_payroll_actions ppa,
392: pay_assignment_actions paa
393: where paa.serial_number = to_char(cp_person_id)
394: and pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
395: ppa.legislative_parameters) =

Line 414: from pay_payroll_actions

410: CURSOR get_yepp_pact_id(cp_bg_id number,
411: cp_pre number,
412: cp_year date) IS
413: select payroll_action_id
414: from pay_payroll_actions
415: where business_group_id = cp_bg_id
416: and report_type = 'RL2'
417: and report_qualifier = 'CAEOYRL2'
418: and action_type = 'X'

Line 820: pay_payroll_actions ppa1

816: hr_locations_all loc,
817: per_all_people_f ppf,
818: per_all_assignments_f paf,
819: pay_assignment_actions paa1,
820: pay_payroll_actions ppa1
821: where ppa1.payroll_action_id = :pactid
822: and paa1.payroll_action_id = ppa1.payroll_action_id
823: and paa1.assignment_id = paf.assignment_id
824: and paf.business_group_id = ppa1.business_group_id

Line 864: token_val pay_payroll_actions.legislative_parameters%type;

860: parameter_list varchar2) return varchar2
861: IS
862: start_ptr number;
863: end_ptr number;
864: token_val pay_payroll_actions.legislative_parameters%type;
865: par_value pay_payroll_actions.legislative_parameters%type;
866:
867: BEGIN
868:

Line 865: par_value pay_payroll_actions.legislative_parameters%type;

861: IS
862: start_ptr number;
863: end_ptr number;
864: token_val pay_payroll_actions.legislative_parameters%type;
865: par_value pay_payroll_actions.legislative_parameters%type;
866:
867: BEGIN
868:
869: token_val := name||'=';