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

Line 84: from pay_payroll_actions ppa

80: effective_date,
81: start_date,
82: business_group_id,
83: report_type
84: from pay_payroll_actions ppa
85: where ppa.payroll_action_id = cp_payroll_action_id;
86:
87: ld_end_date DATE;
88: ld_start_date DATE;

Line 204: from pay_payroll_actions ppa_arch,

200: elsif ln_pre_org_id is not NULL then
201:
202: lv_sql_string :=
203: 'select distinct paf.person_id
204: from pay_payroll_actions ppa_arch,
205: pay_assignment_actions paa_arch,
206: per_assignments_f paf,
207: pay_payroll_actions ppa
208: where paa_arch.assignment_id = paf.assignment_id

Line 207: pay_payroll_actions ppa

203: 'select distinct paf.person_id
204: from pay_payroll_actions ppa_arch,
205: pay_assignment_actions paa_arch,
206: per_assignments_f paf,
207: pay_payroll_actions ppa
208: where paa_arch.assignment_id = paf.assignment_id
209: and ppa.payroll_action_id = :payroll_action_id
210: and ppa_arch.business_group_id = ppa.business_group_id
211: and ppa_arch.effective_date = ppa.effective_date

Line 223: from pay_payroll_actions ppa_arch,

219: else
220:
221: lv_sql_string :=
222: 'select distinct paf.person_id
223: from pay_payroll_actions ppa_arch,
224: pay_assignment_actions paa_arch,
225: per_assignments_f paf,
226: pay_payroll_actions ppa
227: where paa_arch.assignment_id = paf.assignment_id

Line 226: pay_payroll_actions ppa

222: 'select distinct paf.person_id
223: from pay_payroll_actions ppa_arch,
224: pay_assignment_actions paa_arch,
225: per_assignments_f paf,
226: pay_payroll_actions ppa
227: where paa_arch.assignment_id = paf.assignment_id
228: and ppa.payroll_action_id = :payroll_action_id
229: and ppa_arch.business_group_id = ppa.business_group_id
230: and ppa_arch.effective_date = ppa.effective_date

Line 281: lv_report_type pay_payroll_actions.report_type%TYPE ;

277: ln_set_person_id NUMBER := 0 ;
278: ln_asg_set NUMBER := 0 ;
279: lv_print varchar2(10);
280:
281: lv_report_type pay_payroll_actions.report_type%TYPE ;
282: ln_asg_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;
283:
284: lv_serial_number VARCHAR2(30);
285: lv_employee_number per_people_f.employee_number%type;

Line 299: pay_payroll_actions ppa_arch,

295: ,cp_effective_date in date) is
296: select distinct paf.person_id
297: from hr_assignment_set_amendments asgset,
298: per_assignments_f paf,
299: pay_payroll_actions ppa_arch,
300: pay_assignment_actions paa_arch
301: where asgset.assignment_set_id = cp_asg_set
302: and asgset.include_or_exclude = 'I'
303: and paf.assignment_id = asgset.assignment_id

Line 332: FROM pay_payroll_actions ppa ,

328: >= cp_eff_date
329: AND hoi.org_information_context = 'Prov Reporting Est'
330: AND hoi.org_information4 = 'P01'
331: AND exists ( SELECT 1
332: FROM pay_payroll_actions ppa ,
333: pay_assignment_actions paa
334: WHERE ppa.report_type = 'CAEOY_RL1_AMEND_PP'
335: AND ppa.report_qualifier = 'CAEOY_RL1_AMEND_PPQ'
336: AND ppa.business_group_id = cp_bg_id

Line 348: from pay_payroll_actions ppa_arch,

344: cp_eff_date date,
345: cp_start_person number,
346: cp_end_person number) is
347: select distinct paa_arch.serial_number
348: from pay_payroll_actions ppa_arch,
349: pay_assignment_actions paa_arch
350: where ppa_arch.business_group_id = cp_bg_id
351: and ppa_arch.report_type = 'CAEOY_RL1_AMEND_PP'
352: AND ppa_arch.report_qualifier = 'CAEOY_RL1_AMEND_PPQ'

Line 376: from pay_payroll_actions ppa,

372: paa.assignment_id,
373: paa.assignment_action_id,
374: pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
375: ppa.legislative_parameters)
376: from pay_payroll_actions ppa,
377: pay_assignment_actions paa
378: where paa.serial_number = to_char(cp_person_id)
379: and pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
380: ppa.legislative_parameters) =

Line 407: from pay_payroll_actions ppa,

403: paa.assignment_id,
404: paa.assignment_action_id,
405: pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
406: ppa.legislative_parameters)
407: from pay_payroll_actions ppa,
408: pay_assignment_actions paa
409: where paa.serial_number = to_char(cp_person_id)
410: and pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
411: ppa.legislative_parameters) =

Line 431: from pay_payroll_actions

427: CURSOR get_yepp_pact_id(cp_bg_id number,
428: cp_pre number,
429: cp_year date) IS
430: select payroll_action_id
431: from pay_payroll_actions
432: where business_group_id = cp_bg_id
433: and report_type = 'RL1'
434: and report_qualifier = 'CAEOYRL1'
435: and action_type = 'X'

Line 865: pay_payroll_actions ppa1

861: hr_locations_all loc,
862: per_all_people_f ppf,
863: per_all_assignments_f paf,
864: pay_assignment_actions paa1,
865: pay_payroll_actions ppa1
866: where ppa1.payroll_action_id = :pactid
867: and paa1.payroll_action_id = ppa1.payroll_action_id
868: and paa1.assignment_id = paf.assignment_id
869: and paf.business_group_id = ppa1.business_group_id

Line 909: token_val pay_payroll_actions.legislative_parameters%type;

905: parameter_list varchar2) return varchar2
906: IS
907: start_ptr number;
908: end_ptr number;
909: token_val pay_payroll_actions.legislative_parameters%type;
910: par_value pay_payroll_actions.legislative_parameters%type;
911:
912: BEGIN
913:

Line 910: par_value pay_payroll_actions.legislative_parameters%type;

906: IS
907: start_ptr number;
908: end_ptr number;
909: token_val pay_payroll_actions.legislative_parameters%type;
910: par_value pay_payroll_actions.legislative_parameters%type;
911:
912: BEGIN
913:
914: token_val := name||'=';