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 PYCADAR_PKG

Line 213: and pycadar_pkg.get_parameter(''PRE_ORGANIZATION_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
212: and ppa_arch.report_type = ''CAEOY_RL1_AMEND_PP''
213: and pycadar_pkg.get_parameter(''PRE_ORGANIZATION_ID'',
214: ppa_arch.legislative_parameters) = '|| ln_pre_org_id ||'
215: and paa_arch.action_status = ''C''
216: and ppa_arch.payroll_action_id = paa_arch.payroll_action_id
217: order by paf.person_id ';

Line 339: AND pycadar_pkg.get_parameter('PRE_ORGANIZATION_ID',

335: AND ppa.report_qualifier = 'CAEOY_RL1_AMEND_PPQ'
336: AND ppa.business_group_id = cp_bg_id
337: AND ppa.effective_date = cp_eff_date
338: AND paa.payroll_action_id = ppa.payroll_action_id
339: AND pycadar_pkg.get_parameter('PRE_ORGANIZATION_ID',
340: ppa.legislative_parameters) = to_char(hou.organization_id));
341:
342: cursor c_all_asg(cp_bg_id number,
343: cp_pre_org_id number,

Line 357: and pycadar_pkg.get_parameter('PRE_ORGANIZATION_ID',

353: and ppa_arch.effective_date = cp_eff_date
354: and ppa_arch.action_status = 'C'
355: and paa_arch.payroll_action_id = ppa_arch.payroll_action_id
356: and paa_arch.action_status = 'C'
357: and pycadar_pkg.get_parameter('PRE_ORGANIZATION_ID',
358: ppa_arch.legislative_parameters) = to_char(cp_pre_org_id)
359: and to_number(paa_arch.serial_number) between
360: cp_start_person and cp_end_person;
361: