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

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

59: 'SBMT_REF_ID=P',to_char(ppa.payroll_action_id)
60: FROM hr_organization_information hoi,
61: pay_payroll_actions PPA
62: WHERE
63: hoi.organization_id = pay_magtape_generic.get_parameter_value('TRANSMITTER_GRE')
64: and hoi.org_information_context='Fed Magnetic Reporting'
65: and ppa.report_type = 'T4A' -- T4A Archiver Report Type
66: and hoi.organization_id = substr(ppa.legislative_parameters,instr(ppa.legislative_parameters,'TRANSFER_GRE=')+LENGTH('TRANSFER_GRE='))
67: and to_char(ppa.effective_date,'YYYY')=pay_magtape_generic.get_parameter_value('REPORTING_YEAR')

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

63: hoi.organization_id = pay_magtape_generic.get_parameter_value('TRANSMITTER_GRE')
64: and hoi.org_information_context='Fed Magnetic Reporting'
65: and ppa.report_type = 'T4A' -- T4A Archiver Report Type
66: and hoi.organization_id = substr(ppa.legislative_parameters,instr(ppa.legislative_parameters,'TRANSFER_GRE=')+LENGTH('TRANSFER_GRE='))
67: and to_char(ppa.effective_date,'YYYY')=pay_magtape_generic.get_parameter_value('REPORTING_YEAR')
68: and to_char(ppa.effective_date,'DD-MM')= '31-12';
69:
70:
71: --

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

87: From ff_archive_items fai,
88: ff_database_items fdi,
89: pay_payroll_actions ppa,
90: pay_assignment_actions AA
91: WHERE AA.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID') --Magtape Payroll Action id
92: and ppa.report_type = 'T4A'
93: and to_char(ppa.effective_date,'YYYY') = pay_magtape_generic.get_parameter_value('REPORTING_YEAR')
94: and to_char(ppa.effective_date,'DD-MM') = '31-12'
95: and AA.tax_unit_id = substr(ppa.legislative_parameters,instr(ppa.legislative_parameters,'TRANSFER_GRE=')+LENGTH('TRANSFER_GRE='))

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

89: pay_payroll_actions ppa,
90: pay_assignment_actions AA
91: WHERE AA.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID') --Magtape Payroll Action id
92: and ppa.report_type = 'T4A'
93: and to_char(ppa.effective_date,'YYYY') = pay_magtape_generic.get_parameter_value('REPORTING_YEAR')
94: and to_char(ppa.effective_date,'DD-MM') = '31-12'
95: and AA.tax_unit_id = substr(ppa.legislative_parameters,instr(ppa.legislative_parameters,'TRANSFER_GRE=')+LENGTH('TRANSFER_GRE='))
96: and fdi.user_name = 'CAEOY_EMPLOYER_NAME'
97: and ppa.payroll_action_id = fai.context1

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

110:
111: CURSOR mag_t4a_employee IS
112: Select 'ASSIGNMENT_ACTION_ID=C',pai.locked_action_id, -- Archiver Assignment_Action_id
113: 'ASSIGNMENT_ID=C',paa.assignment_id,
114: 'DATE_EARNED=C',fnd_date.date_to_canonical(pay_magtape_generic.date_earned(ppa.effective_date,paa.assignment_id))
115: From
116: per_all_people_f ppf,
117: per_all_assignments_f paf,
118: pay_action_interlocks pai,

Line 121: Where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

117: per_all_assignments_f paf,
118: pay_action_interlocks pai,
119: pay_assignment_actions paa,
120: pay_payroll_actions ppa
121: Where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
122: AND paa.payroll_action_id = ppa.payroll_action_id
123: AND paa.tax_unit_id = pay_magtape_generic.get_parameter_value('TAX_UNIT_ID')
124: AND pai.locking_action_id = paa.assignment_action_id
125: AND paf.assignment_id = paa.assignment_id

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

119: pay_assignment_actions paa,
120: pay_payroll_actions ppa
121: Where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
122: AND paa.payroll_action_id = ppa.payroll_action_id
123: AND paa.tax_unit_id = pay_magtape_generic.get_parameter_value('TAX_UNIT_ID')
124: AND pai.locking_action_id = paa.assignment_action_id
125: AND paf.assignment_id = paa.assignment_id
126: AND ppf.person_id = paf.person_id
127: AND pay_magtape_generic.date_earned(ppa.effective_date,paa.assignment_id) between

Line 127: AND pay_magtape_generic.date_earned(ppa.effective_date,paa.assignment_id) between

123: AND paa.tax_unit_id = pay_magtape_generic.get_parameter_value('TAX_UNIT_ID')
124: AND pai.locking_action_id = paa.assignment_action_id
125: AND paf.assignment_id = paa.assignment_id
126: AND ppf.person_id = paf.person_id
127: AND pay_magtape_generic.date_earned(ppa.effective_date,paa.assignment_id) between
128: paf.effective_start_date and paf.effective_end_date
129: AND pay_magtape_generic.date_earned(ppa.effective_date,paa.assignment_id)
130: between ppf.effective_start_date and ppf.effective_end_date
131: ORDER BY ppf.last_name,ppf.first_name,ppf.middle_names;

Line 129: AND pay_magtape_generic.date_earned(ppa.effective_date,paa.assignment_id)

125: AND paf.assignment_id = paa.assignment_id
126: AND ppf.person_id = paf.person_id
127: AND pay_magtape_generic.date_earned(ppa.effective_date,paa.assignment_id) between
128: paf.effective_start_date and paf.effective_end_date
129: AND pay_magtape_generic.date_earned(ppa.effective_date,paa.assignment_id)
130: between ppf.effective_start_date and ppf.effective_end_date
131: ORDER BY ppf.last_name,ppf.first_name,ppf.middle_names;
132:
133: PROCEDURE get_report_parameters