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_T4_MAG dependencies on PAY_MAGTAPE_GENERIC

Line 32: WHERE hoi.organization_id = pay_magtape_generic.get_parameter_value('TRANSMITTER_GRE')

28: pay_payroll_actions PPA,
29: pay_ca_legislation_info pcli,
30: pay_ca_legislation_info pcli1,
31: pay_ca_legislation_info pcli2
32: WHERE hoi.organization_id = pay_magtape_generic.get_parameter_value('TRANSMITTER_GRE')
33: and hoi.org_information_context='Fed Magnetic Reporting'
34: and ppa.report_type = 'T4' -- T4 Archiver Report Type
35: and hoi.organization_id = substr(ppa.legislative_parameters,instr(ppa.legislative_parameters,'TRANSFER_GRE=')+LENGTH('TRANSFER_GRE='))
36: and to_char(ppa.effective_date,'YYYY')=pay_magtape_generic.get_parameter_value('REPORTING_YEAR')

Line 36: and to_char(ppa.effective_date,'YYYY')=pay_magtape_generic.get_parameter_value('REPORTING_YEAR')

32: WHERE hoi.organization_id = pay_magtape_generic.get_parameter_value('TRANSMITTER_GRE')
33: and hoi.org_information_context='Fed Magnetic Reporting'
34: and ppa.report_type = 'T4' -- T4 Archiver Report Type
35: and hoi.organization_id = substr(ppa.legislative_parameters,instr(ppa.legislative_parameters,'TRANSFER_GRE=')+LENGTH('TRANSFER_GRE='))
36: and to_char(ppa.effective_date,'YYYY')=pay_magtape_generic.get_parameter_value('REPORTING_YEAR')
37: and to_char(ppa.effective_date,'DD-MM')= '31-12'
38: and pcli.information_type = 'MAX_CPP_EARNINGS'
39: and ppa.effective_date between pcli.start_date and pcli.end_date
40: and pcli.jurisdiction_code is null

Line 70: WHERE AA.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID') --Magtape Payroll Action id

66: ff_database_items fdi,
67: pay_payroll_actions ppa,
68: pay_assignment_actions AA,
69: pay_ca_legislation_info pcli2
70: WHERE AA.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID') --Magtape Payroll Action id
71: and ppa.report_type = 'T4'
72: and to_char(ppa.effective_date,'YYYY') = pay_magtape_generic.get_parameter_value('REPORTING_YEAR')
73: and to_char(ppa.effective_date,'DD-MM') = '31-12'
74: and AA.tax_unit_id = substr(ppa.legislative_parameters,instr(ppa.legislative_parameters,'TRANSFER_GRE=')+LENGTH('TRANSFER_GRE='))

Line 72: and to_char(ppa.effective_date,'YYYY') = pay_magtape_generic.get_parameter_value('REPORTING_YEAR')

68: pay_assignment_actions AA,
69: pay_ca_legislation_info pcli2
70: WHERE AA.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID') --Magtape Payroll Action id
71: and ppa.report_type = 'T4'
72: and to_char(ppa.effective_date,'YYYY') = pay_magtape_generic.get_parameter_value('REPORTING_YEAR')
73: and to_char(ppa.effective_date,'DD-MM') = '31-12'
74: and AA.tax_unit_id = substr(ppa.legislative_parameters,instr(ppa.legislative_parameters,'TRANSFER_GRE=')+LENGTH('TRANSFER_GRE='))
75: and fdi.user_name = 'CAEOY_EMPLOYER_NAME'
76: and ppa.payroll_action_id = fai.context1

Line 96: 'DATE_EARNED=C',fnd_date.date_to_canonical(pay_magtape_generic.date_earned(ppa_mag.effective_date,paa.assignment_id)),

92:
93: CURSOR mag_t4_employee IS
94: Select 'ASSIGNMENT_ACTION_ID=C',paa.assignment_action_id, -- Archiver Assignment_Action_id
95: 'ASSIGNMENT_ID=C',paa.assignment_id,
96: 'DATE_EARNED=C',fnd_date.date_to_canonical(pay_magtape_generic.date_earned(ppa_mag.effective_date,paa.assignment_id)),
97: 'JURISDICTION_CODE=C', fai.value,
98: 'TRANSFER_JURISDICTION_CODE=P', fai.value
99: From ff_archive_items fai,
100: ff_database_items fdi,

Line 105: where ppa_mag.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

101: per_all_people_f ppf,
102: pay_assignment_actions paa,
103: pay_payroll_actions ppa,
104: pay_payroll_actions ppa_mag
105: where ppa_mag.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
106: and ppa.report_type = 'T4'
107: and ppa.report_qualifier = 'CAEOY'
108: and ppa.report_category = 'CAEOY'
109: and ppa.effective_date = ppa_mag.effective_date

Line 112: AND paa.tax_unit_id = pay_magtape_generic.get_parameter_value('TAX_UNIT_ID')

108: and ppa.report_category = 'CAEOY'
109: and ppa.effective_date = ppa_mag.effective_date
110: and paa.payroll_action_id = ppa.payroll_action_id
111: and paa.action_status = 'C'
112: AND paa.tax_unit_id = pay_magtape_generic.get_parameter_value('TAX_UNIT_ID')
113: AND fai.context1 = paa.assignment_action_id
114: AND fdi.user_entity_id = fai.user_entity_id
115: AND fdi.user_name = 'CAEOY_PROVINCE_OF_EMPLOYMENT'
116: AND ppf.person_id = to_number(paa.serial_number)

Line 117: AND pay_magtape_generic.date_earned(ppa_mag.effective_date,paa.assignment_id)

113: AND fai.context1 = paa.assignment_action_id
114: AND fdi.user_entity_id = fai.user_entity_id
115: AND fdi.user_name = 'CAEOY_PROVINCE_OF_EMPLOYMENT'
116: AND ppf.person_id = to_number(paa.serial_number)
117: AND pay_magtape_generic.date_earned(ppa_mag.effective_date,paa.assignment_id)
118: between ppf.effective_start_date and ppf.effective_end_date
119: ORDER BY ppf.last_name,ppf.first_name,ppf.middle_names;
120:
121: