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 3247: pycadar_pkg.get_parameter('PRE_ORGANIZATION_ID',

3243: and hoi.organization_id = hou.organization_id
3244: and hoi.org_information_context = 'Prov Reporting Est'
3245: and ppa.business_group_id = fp_b_g_id
3246: and hoi.organization_id =
3247: pycadar_pkg.get_parameter('PRE_ORGANIZATION_ID',
3248: ppa.legislative_parameters)
3249: and pycadar_pkg.get_parameter('PRE_ORGANIZATION_ID',
3250: ppa.legislative_parameters) =
3251: nvl(to_char(fp_pre),pycadar_pkg.get_parameter('PRE_ORGANIZATION_ID',

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

3245: and ppa.business_group_id = fp_b_g_id
3246: and hoi.organization_id =
3247: pycadar_pkg.get_parameter('PRE_ORGANIZATION_ID',
3248: ppa.legislative_parameters)
3249: and pycadar_pkg.get_parameter('PRE_ORGANIZATION_ID',
3250: ppa.legislative_parameters) =
3251: nvl(to_char(fp_pre),pycadar_pkg.get_parameter('PRE_ORGANIZATION_ID',
3252: ppa.legislative_parameters))
3253: and ppa.report_type in ('RL1', 'CAEOY_RL1_AMEND_PP','RL2')

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

3247: pycadar_pkg.get_parameter('PRE_ORGANIZATION_ID',
3248: ppa.legislative_parameters)
3249: and pycadar_pkg.get_parameter('PRE_ORGANIZATION_ID',
3250: ppa.legislative_parameters) =
3251: nvl(to_char(fp_pre),pycadar_pkg.get_parameter('PRE_ORGANIZATION_ID',
3252: ppa.legislative_parameters))
3253: and ppa.report_type in ('RL1', 'CAEOY_RL1_AMEND_PP','RL2')
3254: and ppa.action_status = 'C'
3255: and to_char(ppa.effective_date,'YYYY') = sv_reporting_year

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

3317: and ppa_amend.payroll_action_id = paa_amend.payroll_action_id
3318: and ppa_amend.report_type = 'CAEOY_RL1_AMEND_PP'
3319: and ppa_amend.business_group_id = fp_b_g_id
3320: and ppa_amend.action_status = 'C'
3321: and pycadar_pkg.get_parameter('PRE_ORGANIZATION_ID',ppa.legislative_parameters) =
3322: pycadar_pkg.get_parameter('PRE_ORGANIZATION_ID',ppa_amend.legislative_parameters)
3323: and to_char(ppa_amend.effective_date,'YYYY') = sv_reporting_year
3324: and to_char(ppa_amend.effective_date,'YYYY') = to_char(ppa.effective_date,'YYYY')
3325: and to_char(ppa_amend.effective_date,'DD-MM') = '31-12'

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

3318: and ppa_amend.report_type = 'CAEOY_RL1_AMEND_PP'
3319: and ppa_amend.business_group_id = fp_b_g_id
3320: and ppa_amend.action_status = 'C'
3321: and pycadar_pkg.get_parameter('PRE_ORGANIZATION_ID',ppa.legislative_parameters) =
3322: pycadar_pkg.get_parameter('PRE_ORGANIZATION_ID',ppa_amend.legislative_parameters)
3323: and to_char(ppa_amend.effective_date,'YYYY') = sv_reporting_year
3324: and to_char(ppa_amend.effective_date,'YYYY') = to_char(ppa.effective_date,'YYYY')
3325: and to_char(ppa_amend.effective_date,'DD-MM') = '31-12'
3326: and to_char(ppa_amend.effective_date,'DD-MM') = to_char(ppa.effective_date,'DD-MM'))

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

3780: where hou.business_group_id = fp_b_g_id
3781: and hoi.organization_id = hou.organization_id
3782: and hoi.org_information_context = 'Canada Employer Identification'
3783: and ppa.business_group_id = fp_b_g_id
3784: and hoi.organization_id = pycadar_pkg.get_parameter('TRANSFER_GRE',
3785: ppa.legislative_parameters )
3786: and ( ( hoi.organization_id = fp_gre ) OR
3787: ( fp_gre is null and hoi.organization_id = hoi.organization_id ))
3788: and ( ( ppa.report_type in ('T4', 'CAEOY_T4_AMEND_PP', 'T4A', 'CAEOY_T4A_AMEND_PP' ) and sv_p_y = 'E' ) or

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

3871: and ppa_amend.payroll_action_id = paa_amend.payroll_action_id
3872: and ppa_amend.report_type in ('CAEOY_T4_AMEND_PP','CAEOY_T4A_AMEND_PP')
3873: and ppa_amend.business_group_id = fp_b_g_id
3874: and ppa_amend.action_status = 'C'
3875: and pycadar_pkg.get_parameter('TRANSFER_GRE',ppa.legislative_parameters) =
3876: pycadar_pkg.get_parameter('TRANSFER_GRE',ppa_amend.legislative_parameters)
3877: and to_char(ppa_amend.effective_date,'YYYY') = sv_reporting_year
3878: and to_char(ppa_amend.effective_date,'YYYY') = to_char(ppa.effective_date,'YYYY')
3879: and to_char(ppa_amend.effective_date,'DD-MM') = '31-12'

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

3872: and ppa_amend.report_type in ('CAEOY_T4_AMEND_PP','CAEOY_T4A_AMEND_PP')
3873: and ppa_amend.business_group_id = fp_b_g_id
3874: and ppa_amend.action_status = 'C'
3875: and pycadar_pkg.get_parameter('TRANSFER_GRE',ppa.legislative_parameters) =
3876: pycadar_pkg.get_parameter('TRANSFER_GRE',ppa_amend.legislative_parameters)
3877: and to_char(ppa_amend.effective_date,'YYYY') = sv_reporting_year
3878: and to_char(ppa_amend.effective_date,'YYYY') = to_char(ppa.effective_date,'YYYY')
3879: and to_char(ppa_amend.effective_date,'DD-MM') = '31-12'
3880: and to_char(ppa_amend.effective_date,'DD-MM') = to_char(ppa.effective_date,'DD-MM'))