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 3241: pay_payroll_actions ppa

3237: ppa.report_type,
3238: hoi.org_information2
3239: from hr_organization_information hoi,
3240: hr_all_organization_units hou,
3241: pay_payroll_actions ppa
3242: where hou.business_group_id = fp_b_g_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

Line 3304: pay_payroll_actions ppa,

3300: paa.assignment_id,
3301: paa.serial_number person_id,
3302: paa.action_status
3303: from pay_assignment_actions paa,
3304: pay_payroll_actions ppa,
3305: per_all_people_f ppf
3306: where paa.payroll_action_id = cp_pactid
3307: and ppa.payroll_action_id = paa.payroll_action_id
3308: and ppa.business_group_id = fp_b_g_id

Line 3314: pay_payroll_actions ppa_amend

3310: and ppf.effective_end_date
3311: and not exists
3312: (select 1
3313: from pay_assignment_actions paa_amend,
3314: pay_payroll_actions ppa_amend
3315: where paa_amend.payroll_action_id > cp_pactid
3316: and paa.serial_number = paa_amend.serial_number
3317: and ppa_amend.payroll_action_id = paa_amend.payroll_action_id
3318: and ppa_amend.report_type = 'CAEOY_RL1_AMEND_PP'

Line 3455: ,pay_payroll_actions ppa_arch

3451: select pai_emp.ACTION_INFORMATION4 code, pai_emp.ACTION_INFORMATION5 value,
3452: initcap(rtrim(ltrim(replace(replace(replace(pai_emp.ACTION_INFORMATION4,'RL2_'),'AMOUNT_'),'_',' ')))) short_name
3453: FROM pay_action_information pai_emp
3454: ,pay_assignment_actions paa_arch
3455: ,pay_payroll_actions ppa_arch
3456: where pai_emp.action_context_id=cp_asgact_id
3457: AND pai_emp.action_context_id = paa_arch.assignment_action_id
3458: AND pai_emp.action_information_category = 'CAEOY RL2 FURTHER INFO'
3459: AND pai_emp.assignment_id = paa_arch.assignment_id

Line 3779: pay_payroll_actions ppa

3775: ppa.effective_date,
3776: ppa.report_type
3777: from hr_organization_information hoi,
3778: hr_all_organization_units hou,
3779: pay_payroll_actions ppa
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

Line 3858: pay_payroll_actions ppa,

3854: paa.serial_number person_id,
3855: paa.action_status,
3856: ppf.last_name,ppf.first_name,ppf.middle_names
3857: from pay_assignment_actions paa,
3858: pay_payroll_actions ppa,
3859: per_all_people_f ppf
3860: where paa.payroll_action_id = cp_pactid
3861: and ppa.payroll_action_id = paa.payroll_action_id
3862: and ppa.business_group_id = fp_b_g_id

Line 3868: pay_payroll_actions ppa_amend

3864: and ppf.effective_end_date
3865: and not exists
3866: (select 1
3867: from pay_assignment_actions paa_amend,
3868: pay_payroll_actions ppa_amend
3869: where paa_amend.payroll_action_id > cp_pactid
3870: and paa.serial_number = paa_amend.serial_number
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')