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_HK_IR56_ARCHIVE dependencies on PAY_CORE_UTILS

Line 109: -- pay_core_utils removed.

105: -- run for the year YYYY. Hence modified the cursor process_assignments by
106: -- including the join with actual_termination_date <> 31-Mar-YYYY.
107: -- 28 Aug 2003 srrajago 3059915 # In the cursor 'process_assignments', few joins with effective_date,
108: -- reporting_year and business_group_id included.Few joins with
109: -- pay_core_utils removed.
110: -- # In the cursors 'ir56_Spouse_info' and 'ir56_Employee_info',view
111: -- fnd_territories_vl replaced with fnd_territories_tl table and a
112: -- join with language also included.
113: -- # In the procedure 'Archive_Excep_Error_dtls', cursor 'ir56_employer_info'

Line 223: SELECT to_date('01-04-'|| to_char(to_number(pay_core_utils.get_parameter('REPORTING_YEAR',legislative_parameters))

219: /* Introduced the following cursor get_params for Bug No : 2740270 */
220:
221: CURSOR get_params(c_payroll_action_id in pay_payroll_actions.payroll_action_id%type)
222: IS
223: SELECT to_date('01-04-'|| to_char(to_number(pay_core_utils.get_parameter('REPORTING_YEAR',legislative_parameters))
224: -1),'DD-MM-YYYY') FINANCIAL_YEAR_START
225: ,to_date('31-03-'||pay_core_utils.get_parameter('REPORTING_YEAR',legislative_parameters),'DD-MM-YYYY')
226: FINANCIAL_YEAR_END
227: ,pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters) BUSINESS_GROUP_ID

Line 225: ,to_date('31-03-'||pay_core_utils.get_parameter('REPORTING_YEAR',legislative_parameters),'DD-MM-YYYY')

221: CURSOR get_params(c_payroll_action_id in pay_payroll_actions.payroll_action_id%type)
222: IS
223: SELECT to_date('01-04-'|| to_char(to_number(pay_core_utils.get_parameter('REPORTING_YEAR',legislative_parameters))
224: -1),'DD-MM-YYYY') FINANCIAL_YEAR_START
225: ,to_date('31-03-'||pay_core_utils.get_parameter('REPORTING_YEAR',legislative_parameters),'DD-MM-YYYY')
226: FINANCIAL_YEAR_END
227: ,pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters) BUSINESS_GROUP_ID
228: ,pay_core_utils.get_parameter('LEGAL_ENTITY_ID',legislative_parameters) LEGAL_ENTITY_ID
229: ,pay_core_utils.get_parameter('REPORTING_YEAR',legislative_parameters) REPORTING_YEAR

Line 227: ,pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters) BUSINESS_GROUP_ID

223: SELECT to_date('01-04-'|| to_char(to_number(pay_core_utils.get_parameter('REPORTING_YEAR',legislative_parameters))
224: -1),'DD-MM-YYYY') FINANCIAL_YEAR_START
225: ,to_date('31-03-'||pay_core_utils.get_parameter('REPORTING_YEAR',legislative_parameters),'DD-MM-YYYY')
226: FINANCIAL_YEAR_END
227: ,pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters) BUSINESS_GROUP_ID
228: ,pay_core_utils.get_parameter('LEGAL_ENTITY_ID',legislative_parameters) LEGAL_ENTITY_ID
229: ,pay_core_utils.get_parameter('REPORTING_YEAR',legislative_parameters) REPORTING_YEAR
230: FROM pay_payroll_actions
231: WHERE payroll_action_id = c_payroll_Action_id;

Line 228: ,pay_core_utils.get_parameter('LEGAL_ENTITY_ID',legislative_parameters) LEGAL_ENTITY_ID

224: -1),'DD-MM-YYYY') FINANCIAL_YEAR_START
225: ,to_date('31-03-'||pay_core_utils.get_parameter('REPORTING_YEAR',legislative_parameters),'DD-MM-YYYY')
226: FINANCIAL_YEAR_END
227: ,pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters) BUSINESS_GROUP_ID
228: ,pay_core_utils.get_parameter('LEGAL_ENTITY_ID',legislative_parameters) LEGAL_ENTITY_ID
229: ,pay_core_utils.get_parameter('REPORTING_YEAR',legislative_parameters) REPORTING_YEAR
230: FROM pay_payroll_actions
231: WHERE payroll_action_id = c_payroll_Action_id;
232:

Line 229: ,pay_core_utils.get_parameter('REPORTING_YEAR',legislative_parameters) REPORTING_YEAR

225: ,to_date('31-03-'||pay_core_utils.get_parameter('REPORTING_YEAR',legislative_parameters),'DD-MM-YYYY')
226: FINANCIAL_YEAR_END
227: ,pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters) BUSINESS_GROUP_ID
228: ,pay_core_utils.get_parameter('LEGAL_ENTITY_ID',legislative_parameters) LEGAL_ENTITY_ID
229: ,pay_core_utils.get_parameter('REPORTING_YEAR',legislative_parameters) REPORTING_YEAR
230: FROM pay_payroll_actions
231: WHERE payroll_action_id = c_payroll_Action_id;
232:
233: /* Bug No : 2740270 - Cursor to get all the assignments in the basis year

Line 307: AND ppaa.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_ACTION_ID',

303: AND ppaa.action_status='C'
304: AND ppai.report_type = 'HK_IR56B_REPORT'
305: AND paa.assignment_action_id = pai.locking_action_id
306: AND ppai.payroll_action_id = paa.payroll_action_id
307: AND ppaa.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_ACTION_ID',
308: ppai.legislative_parameters)
309: /* Start of Bug No : 3059915 */
310: AND ppaa.business_group_id = c_business_group_id
311: AND ppaa.business_group_id = ppai.business_group_id

Line 315: AND pay_core_utils.get_parameter('LEGAL_ENTITY_ID',ppaa.legislative_parameters) =

311: AND ppaa.business_group_id = ppai.business_group_id
312: AND to_char(ppaa.effective_date,'YYYY') = c_reporting_year
313: AND ppaa.effective_date = ppai.effective_date
314: /* End of Bug No : 3059915 */
315: AND pay_core_utils.get_parameter('LEGAL_ENTITY_ID',ppaa.legislative_parameters) =
316: c_legal_entity_id
317: )
318: ;
319:

Line 1569: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',ppa.legislative_parameters),

1565: (c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
1566: IS
1567: SELECT paa.person_id,
1568: pac.assignment_id,
1569: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',ppa.legislative_parameters),
1570: pay_core_utils.get_parameter('LEGAL_ENTITY_ID',ppa.legislative_parameters),
1571: pay_core_utils.get_parameter('REPORTING_YEAR',ppa.legislative_parameters),
1572: effective_date
1573: FROM pay_payroll_actions ppa,

Line 1570: pay_core_utils.get_parameter('LEGAL_ENTITY_ID',ppa.legislative_parameters),

1566: IS
1567: SELECT paa.person_id,
1568: pac.assignment_id,
1569: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',ppa.legislative_parameters),
1570: pay_core_utils.get_parameter('LEGAL_ENTITY_ID',ppa.legislative_parameters),
1571: pay_core_utils.get_parameter('REPORTING_YEAR',ppa.legislative_parameters),
1572: effective_date
1573: FROM pay_payroll_actions ppa,
1574: pay_assignment_actions pac,

Line 1571: pay_core_utils.get_parameter('REPORTING_YEAR',ppa.legislative_parameters),

1567: SELECT paa.person_id,
1568: pac.assignment_id,
1569: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',ppa.legislative_parameters),
1570: pay_core_utils.get_parameter('LEGAL_ENTITY_ID',ppa.legislative_parameters),
1571: pay_core_utils.get_parameter('REPORTING_YEAR',ppa.legislative_parameters),
1572: effective_date
1573: FROM pay_payroll_actions ppa,
1574: pay_assignment_actions pac,
1575: per_assignments_f paa

Line 1724: and ppa2.payroll_action_id =pay_core_utils.get_parameter('REPORT_ACTION_ID', ppa.legislative_parameters)

1720: pay_payroll_actions ppa, -- Magtape payroll action
1721: pay_payroll_actions ppa2, -- Report payroll action
1722: pay_payroll_actions ppa3 -- Archive payroll action
1723: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
1724: and ppa2.payroll_action_id =pay_core_utils.get_parameter('REPORT_ACTION_ID', ppa.legislative_parameters)
1725: and ppa3.payroll_action_id =pay_core_utils.get_parameter('ARCHIVE_ACTION_ID', ppa2.legislative_parameters);
1726:
1727:
1728:

Line 1725: and ppa3.payroll_action_id =pay_core_utils.get_parameter('ARCHIVE_ACTION_ID', ppa2.legislative_parameters);

1721: pay_payroll_actions ppa2, -- Report payroll action
1722: pay_payroll_actions ppa3 -- Archive payroll action
1723: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
1724: and ppa2.payroll_action_id =pay_core_utils.get_parameter('REPORT_ACTION_ID', ppa.legislative_parameters)
1725: and ppa3.payroll_action_id =pay_core_utils.get_parameter('ARCHIVE_ACTION_ID', ppa2.legislative_parameters);
1726:
1727:
1728:
1729: