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 PYCADAR_PKG

Line 199: and pycadar_pkg.get_parameter(''PRE_ORGANIZATION_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
198: and ppa_arch.report_type = ''CAEOY_RL2_AMEND_PP''
199: and pycadar_pkg.get_parameter(''PRE_ORGANIZATION_ID'',
200: ppa_arch.legislative_parameters) = '|| ln_pre_org_id ||'
201: and paa_arch.action_status = ''C''
202: and ppa_arch.payroll_action_id = paa_arch.payroll_action_id
203: order by paf.person_id ';

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

319: AND ppa.report_qualifier = 'CAEOY_RL2_AMEND_PPQ'
320: AND ppa.business_group_id = cp_bg_id
321: AND ppa.effective_date = cp_eff_date
322: AND paa.payroll_action_id = ppa.payroll_action_id
323: AND pycadar_pkg.get_parameter('PRE_ORGANIZATION_ID',
324: ppa.legislative_parameters) = to_char(hou.organization_id));
325:
326: cursor c_all_asg(cp_bg_id number,
327: cp_pre_org_id number,

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

337: and ppa_arch.effective_date = cp_eff_date
338: and ppa_arch.action_status = 'C'
339: and paa_arch.payroll_action_id = ppa_arch.payroll_action_id
340: and paa_arch.action_status = 'C'
341: and pycadar_pkg.get_parameter('PRE_ORGANIZATION_ID',
342: ppa_arch.legislative_parameters) = to_char(cp_pre_org_id)
343: and to_number(paa_arch.serial_number) between
344: cp_start_person and cp_end_person;
345: