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 PAY_PAYROLL_ACTIONS

Line 2875: pay_payroll_actions ppa

2871: ppa.report_type,
2872: hoi.org_information2
2873: from hr_organization_information hoi,
2874: hr_all_organization_units hou,
2875: pay_payroll_actions ppa
2876: where hou.business_group_id = fp_b_g_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

Line 2937: pay_payroll_actions ppa,

2933: paa.assignment_id,
2934: paa.serial_number person_id,
2935: paa.action_status
2936: from pay_assignment_actions paa,
2937: pay_payroll_actions ppa,
2938: per_all_people_f ppf
2939: where paa.payroll_action_id = cp_pactid
2940: and ppa.payroll_action_id = paa.payroll_action_id
2941: and ppa.business_group_id = fp_b_g_id

Line 2945: pay_payroll_actions ppa_amend

2941: and ppa.business_group_id = fp_b_g_id
2942: and not exists
2943: (select 1
2944: from pay_assignment_actions paa_amend,
2945: pay_payroll_actions ppa_amend
2946: where paa_amend.payroll_action_id > cp_pactid
2947: and paa.serial_number = paa_amend.serial_number
2948: and ppa_amend.payroll_action_id = paa_amend.payroll_action_id
2949: and ppa_amend.report_type = 'CAEOY_RL1_AMEND_PP'

Line 3319: pay_payroll_actions ppa

3315: ppa.effective_date,
3316: ppa.report_type
3317: from hr_organization_information hoi,
3318: hr_all_organization_units hou,
3319: pay_payroll_actions ppa
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

Line 3395: pay_payroll_actions ppa,

3391: paa.serial_number person_id,
3392: paa.action_status,
3393: ppf.last_name,ppf.first_name,ppf.middle_names
3394: from pay_assignment_actions paa,
3395: pay_payroll_actions ppa,
3396: per_all_people_f ppf
3397: where paa.payroll_action_id = cp_pactid
3398: and ppa.payroll_action_id = paa.payroll_action_id
3399: and ppa.business_group_id = fp_b_g_id

Line 3403: pay_payroll_actions ppa_amend

3399: and ppa.business_group_id = fp_b_g_id
3400: and not exists
3401: (select 1
3402: from pay_assignment_actions paa_amend,
3403: pay_payroll_actions ppa_amend
3404: where paa_amend.payroll_action_id > cp_pactid
3405: and paa.serial_number = paa_amend.serial_number
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')