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 221: SELECT to_date('01-04-'|| to_char(to_number(pay_core_utils.get_parameter('REPORTING_YEAR',legislative_parameters))

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1496: (c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
1497: IS
1498: SELECT paa.person_id,
1499: pac.assignment_id,
1500: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',ppa.legislative_parameters),
1501: pay_core_utils.get_parameter('LEGAL_ENTITY_ID',ppa.legislative_parameters),
1502: pay_core_utils.get_parameter('REPORTING_YEAR',ppa.legislative_parameters),
1503: effective_date
1504: FROM pay_payroll_actions ppa,

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

1497: IS
1498: SELECT paa.person_id,
1499: pac.assignment_id,
1500: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',ppa.legislative_parameters),
1501: pay_core_utils.get_parameter('LEGAL_ENTITY_ID',ppa.legislative_parameters),
1502: pay_core_utils.get_parameter('REPORTING_YEAR',ppa.legislative_parameters),
1503: effective_date
1504: FROM pay_payroll_actions ppa,
1505: pay_assignment_actions pac,

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

1498: SELECT paa.person_id,
1499: pac.assignment_id,
1500: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',ppa.legislative_parameters),
1501: pay_core_utils.get_parameter('LEGAL_ENTITY_ID',ppa.legislative_parameters),
1502: pay_core_utils.get_parameter('REPORTING_YEAR',ppa.legislative_parameters),
1503: effective_date
1504: FROM pay_payroll_actions ppa,
1505: pay_assignment_actions pac,
1506: per_assignments_f paa

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

1651: pay_payroll_actions ppa, -- Magtape payroll action
1652: pay_payroll_actions ppa2, -- Report payroll action
1653: pay_payroll_actions ppa3 -- Archive payroll action
1654: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
1655: and ppa2.payroll_action_id =pay_core_utils.get_parameter('REPORT_ACTION_ID', ppa.legislative_parameters)
1656: and ppa3.payroll_action_id =pay_core_utils.get_parameter('ARCHIVE_ACTION_ID', ppa2.legislative_parameters);
1657:
1658:
1659:

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

1652: pay_payroll_actions ppa2, -- Report payroll action
1653: pay_payroll_actions ppa3 -- Archive payroll action
1654: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
1655: and ppa2.payroll_action_id =pay_core_utils.get_parameter('REPORT_ACTION_ID', ppa.legislative_parameters)
1656: and ppa3.payroll_action_id =pay_core_utils.get_parameter('ARCHIVE_ACTION_ID', ppa2.legislative_parameters);
1657:
1658:
1659:
1660: