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_YEER_PKG dependencies on PYCADAR_PKG

Line 2881: pycadar_pkg.get_parameter('PRE_ORGANIZATION_ID',

2877: and hoi.organization_id = hou.organization_id
2878: and hoi.org_information_context = 'Prov Reporting Est'
2879: and ppa.business_group_id = fp_b_g_id
2880: and hoi.organization_id =
2881: pycadar_pkg.get_parameter('PRE_ORGANIZATION_ID',
2882: ppa.legislative_parameters)
2883: and pycadar_pkg.get_parameter('PRE_ORGANIZATION_ID',
2884: ppa.legislative_parameters) =
2885: nvl(to_char(fp_pre),pycadar_pkg.get_parameter('PRE_ORGANIZATION_ID',

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

2879: and ppa.business_group_id = fp_b_g_id
2880: and hoi.organization_id =
2881: pycadar_pkg.get_parameter('PRE_ORGANIZATION_ID',
2882: ppa.legislative_parameters)
2883: and pycadar_pkg.get_parameter('PRE_ORGANIZATION_ID',
2884: ppa.legislative_parameters) =
2885: nvl(to_char(fp_pre),pycadar_pkg.get_parameter('PRE_ORGANIZATION_ID',
2886: ppa.legislative_parameters))
2887: and ppa.report_type in ('RL1', 'CAEOY_RL1_AMEND_PP','RL2')

Line 2885: nvl(to_char(fp_pre),pycadar_pkg.get_parameter('PRE_ORGANIZATION_ID',

2881: pycadar_pkg.get_parameter('PRE_ORGANIZATION_ID',
2882: ppa.legislative_parameters)
2883: and pycadar_pkg.get_parameter('PRE_ORGANIZATION_ID',
2884: ppa.legislative_parameters) =
2885: nvl(to_char(fp_pre),pycadar_pkg.get_parameter('PRE_ORGANIZATION_ID',
2886: ppa.legislative_parameters))
2887: and ppa.report_type in ('RL1', 'CAEOY_RL1_AMEND_PP','RL2')
2888: and ppa.action_status = 'C'
2889: and to_char(ppa.effective_date,'YYYY') = sv_reporting_year

Line 2952: and pycadar_pkg.get_parameter('PRE_ORGANIZATION_ID',ppa.legislative_parameters) =

2948: and ppa_amend.payroll_action_id = paa_amend.payroll_action_id
2949: and ppa_amend.report_type = 'CAEOY_RL1_AMEND_PP'
2950: and ppa_amend.business_group_id = fp_b_g_id
2951: and ppa_amend.action_status = 'C'
2952: and pycadar_pkg.get_parameter('PRE_ORGANIZATION_ID',ppa.legislative_parameters) =
2953: pycadar_pkg.get_parameter('PRE_ORGANIZATION_ID',ppa_amend.legislative_parameters)
2954: and to_char(ppa_amend.effective_date,'YYYY') = sv_reporting_year
2955: and to_char(ppa_amend.effective_date,'YYYY') = to_char(ppa.effective_date,'YYYY')
2956: and to_char(ppa_amend.effective_date,'DD-MM') = '31-12'

Line 2953: pycadar_pkg.get_parameter('PRE_ORGANIZATION_ID',ppa_amend.legislative_parameters)

2949: and ppa_amend.report_type = 'CAEOY_RL1_AMEND_PP'
2950: and ppa_amend.business_group_id = fp_b_g_id
2951: and ppa_amend.action_status = 'C'
2952: and pycadar_pkg.get_parameter('PRE_ORGANIZATION_ID',ppa.legislative_parameters) =
2953: pycadar_pkg.get_parameter('PRE_ORGANIZATION_ID',ppa_amend.legislative_parameters)
2954: and to_char(ppa_amend.effective_date,'YYYY') = sv_reporting_year
2955: and to_char(ppa_amend.effective_date,'YYYY') = to_char(ppa.effective_date,'YYYY')
2956: and to_char(ppa_amend.effective_date,'DD-MM') = '31-12'
2957: and to_char(ppa_amend.effective_date,'DD-MM') = to_char(ppa.effective_date,'DD-MM'))

Line 3324: and hoi.organization_id = pycadar_pkg.get_parameter('TRANSFER_GRE',

3320: where hou.business_group_id = fp_b_g_id
3321: and hoi.organization_id = hou.organization_id
3322: and hoi.org_information_context = 'Canada Employer Identification'
3323: and ppa.business_group_id = fp_b_g_id
3324: and hoi.organization_id = pycadar_pkg.get_parameter('TRANSFER_GRE',
3325: ppa.legislative_parameters )
3326: and ( ( hoi.organization_id = fp_gre ) OR
3327: ( fp_gre is null and hoi.organization_id = hoi.organization_id ))
3328: and ( ( ppa.report_type in ('T4', 'CAEOY_T4_AMEND_PP', 'T4A', 'CAEOY_T4A_AMEND_PP' ) and sv_p_y = 'E' ) or

Line 3410: and pycadar_pkg.get_parameter('TRANSFER_GRE',ppa.legislative_parameters) =

3406: and ppa_amend.payroll_action_id = paa_amend.payroll_action_id
3407: and ppa_amend.report_type in ('CAEOY_T4_AMEND_PP','CAEOY_T4A_AMEND_PP')
3408: and ppa_amend.business_group_id = fp_b_g_id
3409: and ppa_amend.action_status = 'C'
3410: and pycadar_pkg.get_parameter('TRANSFER_GRE',ppa.legislative_parameters) =
3411: pycadar_pkg.get_parameter('TRANSFER_GRE',ppa_amend.legislative_parameters)
3412: and to_char(ppa_amend.effective_date,'YYYY') = sv_reporting_year
3413: and to_char(ppa_amend.effective_date,'YYYY') = to_char(ppa.effective_date,'YYYY')
3414: and to_char(ppa_amend.effective_date,'DD-MM') = '31-12'

Line 3411: pycadar_pkg.get_parameter('TRANSFER_GRE',ppa_amend.legislative_parameters)

3407: and ppa_amend.report_type in ('CAEOY_T4_AMEND_PP','CAEOY_T4A_AMEND_PP')
3408: and ppa_amend.business_group_id = fp_b_g_id
3409: and ppa_amend.action_status = 'C'
3410: and pycadar_pkg.get_parameter('TRANSFER_GRE',ppa.legislative_parameters) =
3411: pycadar_pkg.get_parameter('TRANSFER_GRE',ppa_amend.legislative_parameters)
3412: and to_char(ppa_amend.effective_date,'YYYY') = sv_reporting_year
3413: and to_char(ppa_amend.effective_date,'YYYY') = to_char(ppa.effective_date,'YYYY')
3414: and to_char(ppa_amend.effective_date,'DD-MM') = '31-12'
3415: and to_char(ppa_amend.effective_date,'DD-MM') = to_char(ppa.effective_date,'DD-MM'))