[Home] [Help]
42: 'Y'
43: from pay_assignment_actions ppac,
44: pay_payroll_actions ppa
45: where ppa.payroll_action_id =pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
46: and ppac.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_PAYROLL_ACTION',ppa.legislative_parameters)
47: AND pay_au_payment_summary.get_archive_value('X_REPORTING_FLAG', ppac.assignment_action_id)='YES'
48: AND pay_au_payment_summary.get_archive_value('X_CURR_TERM_0_BAL_FLAG',ppac.assignment_action_id)='NO' /* Added for bug 5257622 */
49: and ppac.action_status = 'C'
50: and ppa.report_type = 'AU_PS_DATA_FILE_VAL'
67: pay_action_interlocks mpai
68: where apac.assignment_action_id = ppai.locked_action_id
69: and mpac.assignment_Action_id = mpai.locking_action_id
70: and ppa.payroll_action_id = ppac.payroll_Action_id
71: and apac.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_ID',ppa.legislative_parameters)
72: and ppac.assignment_action_id = mpai.locked_action_id
73: and mpac.payroll_action_id =pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
74: and apac.action_status = 'C'
75: and ppac.action_status = 'C' /* Bug No : 3288757 */
88: (
89: select 'ASSIGNMENT_ACTION_ID=C',
90: ppac.assignment_action_id ps_report_id,
91: 'FINANCIAL_YEAR_END=P',
92: substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',ppa.legislative_parameters),6,4),
93: 'FINANCIAL_YEAR_START=P',
94: substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',ppa.legislative_parameters),1,4)
95: /*Bug 6630375 - removed ETP_PAYER_TYPE */
96: -- ,'ETP_PAYER_TYPE=P',
90: ppac.assignment_action_id ps_report_id,
91: 'FINANCIAL_YEAR_END=P',
92: substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',ppa.legislative_parameters),6,4),
93: 'FINANCIAL_YEAR_START=P',
94: substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',ppa.legislative_parameters),1,4)
95: /*Bug 6630375 - removed ETP_PAYER_TYPE */
96: -- ,'ETP_PAYER_TYPE=P',
97: -- ,decode(fue.user_entity_name,'X_LUMP_SUM_C_DEDUCTIONS_ASG_YTD',decode(value ,0,null ,null,null, 'P')) etp_payer_type
98: from
101: ff_archive_items ff,
102: ff_user_entities fue
103: where ppa.payroll_action_id =pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
104: and ppac.action_status='C'
105: and ppac.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_PAYROLL_ACTION',ppa.legislative_parameters)
106: AND pay_au_payment_summary.get_archive_value('X_REPORTING_FLAG', ppac.assignment_action_id)='YES'
107: AND pay_au_payment_summary.get_archive_value('X_CURR_TERM_0_BAL_FLAG',ppac.assignment_action_id)='NO' /* Added for bug 5257622 */
108: and fue.user_Entity_id= ff.user_entity_id
109: and ff.context1= ppac.assignment_action_id
120: (
121: select /*+ ORDERED */ 'ASSIGNMENT_ACTION_ID=C',
122: apac.assignment_action_id ps_report_id,
123: 'FINANCIAL_YEAR_END=P',
124: substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',ppa.legislative_parameters),6,4),
125: 'FINANCIAL_YEAR_START=P',
126: substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',ppa.legislative_parameters),1,4)
127: /*Bug 6630375 - removed ETP_PAYER_TYPE */
128: -- ,'ETP_PAYER_TYPE=P',
122: apac.assignment_action_id ps_report_id,
123: 'FINANCIAL_YEAR_END=P',
124: substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',ppa.legislative_parameters),6,4),
125: 'FINANCIAL_YEAR_START=P',
126: substr(pay_core_utils.get_parameter('FINANCIAL_YEAR',ppa.legislative_parameters),1,4)
127: /*Bug 6630375 - removed ETP_PAYER_TYPE */
128: -- ,'ETP_PAYER_TYPE=P',
129: -- ,decode(fue.user_entity_name,'X_LUMP_SUM_C_DEDUCTIONS_ASG_YTD',decode(value ,0,null ,null,null, 'P')) etp_payer_type
130: from
142: and mpai.locking_action_id = mpac.assignment_Action_id -- magtapes locking action id
143: and ppac.assignment_action_id = mpai.locked_action_id --self printed locked by maghtape
144: and ppai.locking_Action_id =ppac.assignment_action_id -- self printed has locked archive
145: and apac.assignment_action_id=ppai.locked_action_id --archive actionslocked by self printed
146: and apac.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_ID',ppa.legislative_parameters)
147: and ppa.payroll_action_id = ppac.payroll_Action_id --payroll actions for self printed
148: and ppa.report_type='AU_PAYMENT_SUMMARY_REPORT'
149: and apac.assignment_id = ppac.assignment_id
150: and ppac.assignment_id = mpac.assignment_id
166: pay_assignment_actions mpac
167: where mpa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
168: AND mpac.payroll_action_id = mpa.payroll_action_id /* Added for bug 6630375 */
169: AND mpac.assignment_id = ppac.assignment_id /* Added for bug 6630375 */
170: AND ppac.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_PAYROLL_ACTION',mpa.legislative_parameters)
171: AND pay_au_payment_summary.get_archive_value('X_REPORTING_FLAG', ppac.assignment_action_id)='YES'
172: AND pay_au_payment_summary.get_archive_value('X_CURR_TERM_0_BAL_FLAG',ppac.assignment_action_id)='NO' /* Added for bug 5257622 */
173: and ppac.action_status = 'C'
174: and mpa.report_type = 'AU_PS_DATA_FILE_VAL'
201: pay_assignment_actions apac,
202: pay_payroll_actions ppa
203: where ppa.payroll_action_id = ppac.payroll_Action_id
204: and apac.assignment_action_id = ppai.locked_action_id
205: and apac.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_ID',ppa.legislative_parameters)
206: and ppai.locking_Action_id = ppac.assignment_action_id /* 5471093 */
207: and ppac.assignment_action_id = mpai.locked_action_id
208: and mpac.assignment_Action_id = mpai.locking_action_id
209: and mpac.payroll_action_id =pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
251: pay_assignment_actions mpac
252: where mpa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
253: AND mpac.payroll_action_id = mpa.payroll_action_id /* Added for bug 6630375 */
254: AND mpac.assignment_id = ppac.assignment_id /* Added for bug 6630375 */
255: AND ppac.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_PAYROLL_ACTION',mpa.legislative_parameters)
256: AND pay_au_payment_summary.get_archive_value('X_REPORTING_FLAG', ppac.assignment_action_id)='YES'
257: AND pay_au_payment_summary.get_archive_value('X_CURR_TERM_0_BAL_FLAG',ppac.assignment_action_id)='NO' /* Added for bug 5257622 */
258: and pay_au_payment_summary.get_archive_value('X_SORT_EMPLOYEE_TYPE',ppac.assignment_action_id) = 'T'
259: and ppac.action_status = 'C'
291: and mpac.assignment_Action_id = mpai.locking_action_id
292: and ppac.assignment_action_id = mpai.locked_action_id
293: and ppai.locking_Action_id = ppac.assignment_action_id
294: and apac.assignment_action_id = ppai.locked_action_id
295: and apac.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_ID',ppa.legislative_parameters)
296: and pay_au_payment_summary.get_archive_value('X_SORT_EMPLOYEE_TYPE',apac.assignment_action_id) = 'T'
297: and ppa.payroll_action_id = ppac.payroll_Action_id
298: and ppa.report_type = 'AU_PAYMENT_SUMMARY_REPORT'
299: and apac.assignment_id = ppac.assignment_id