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

Line 87: select pay_core_utils.get_parameter('SETUP_ACTION_ID',legislative_parameters)

83: v_person_id per_all_people_f.person_id%type;
84: v_assignment_set_id hr_assignment_sets.assignment_set_id%type;
85: --
86: cursor get_params(c_payroll_action_id in pay_payroll_actions.payroll_action_id%type) is
87: select pay_core_utils.get_parameter('SETUP_ACTION_ID',legislative_parameters)
88: ,pay_core_utils.get_parameter('PERSON_ID',legislative_parameters)
89: ,pay_core_utils.get_parameter('ASSIGNMENT_SET_ID',legislative_parameters)
90: from pay_payroll_actions
91: where payroll_action_id = c_payroll_Action_id;

Line 88: ,pay_core_utils.get_parameter('PERSON_ID',legislative_parameters)

84: v_assignment_set_id hr_assignment_sets.assignment_set_id%type;
85: --
86: cursor get_params(c_payroll_action_id in pay_payroll_actions.payroll_action_id%type) is
87: select pay_core_utils.get_parameter('SETUP_ACTION_ID',legislative_parameters)
88: ,pay_core_utils.get_parameter('PERSON_ID',legislative_parameters)
89: ,pay_core_utils.get_parameter('ASSIGNMENT_SET_ID',legislative_parameters)
90: from pay_payroll_actions
91: where payroll_action_id = c_payroll_Action_id;
92: --

Line 89: ,pay_core_utils.get_parameter('ASSIGNMENT_SET_ID',legislative_parameters)

85: --
86: cursor get_params(c_payroll_action_id in pay_payroll_actions.payroll_action_id%type) is
87: select pay_core_utils.get_parameter('SETUP_ACTION_ID',legislative_parameters)
88: ,pay_core_utils.get_parameter('PERSON_ID',legislative_parameters)
89: ,pay_core_utils.get_parameter('ASSIGNMENT_SET_ID',legislative_parameters)
90: from pay_payroll_actions
91: where payroll_action_id = c_payroll_Action_id;
92: --
93: cursor next_action_id is

Line 143: and pay_core_utils.get_parameter('LEGAL_ENTITY_ID',mpl.legislative_parameters) = g_legal_entity_id

139: where paf.assignment_id = mcl.assignment_id
140: and mpl.payroll_action_id = mcl.payroll_action_id
141: and mcl.assignment_Action_id = intl.locking_action_id
142: and mpl.effective_date between g_basis_start and g_basis_end
143: and pay_core_utils.get_parameter('LEGAL_ENTITY_ID',mpl.legislative_parameters) = g_legal_entity_id
144: and mpl.report_type in ( 'SG_A8B','SG_IR8A','SG_IR8S','SG_A8A','SG_A_A8A' )
145: and mpl.action_type = 'X'
146: and mcl.action_status = 'C'
147: group by paf.assignment_id

Line 220: select pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters),

216: procedure initialization_code
217: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type )
218: is
219: cursor get_params( c_payroll_action_id in pay_payroll_actions.payroll_action_id%type ) is
220: select pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters),
221: to_date('01-01-'||pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),
222: to_date('31-12-'|| pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),
223: pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),
224: pay_core_utils.get_parameter('LEGAL_ENTITY_ID',legislative_parameters),

Line 221: to_date('01-01-'||pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),

217: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type )
218: is
219: cursor get_params( c_payroll_action_id in pay_payroll_actions.payroll_action_id%type ) is
220: select pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters),
221: to_date('01-01-'||pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),
222: to_date('31-12-'|| pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),
223: pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),
224: pay_core_utils.get_parameter('LEGAL_ENTITY_ID',legislative_parameters),
225: pay_core_utils.get_parameter('SETUP_ACTION_ID',legislative_parameters),

Line 222: to_date('31-12-'|| pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),

218: is
219: cursor get_params( c_payroll_action_id in pay_payroll_actions.payroll_action_id%type ) is
220: select pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters),
221: to_date('01-01-'||pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),
222: to_date('31-12-'|| pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),
223: pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),
224: pay_core_utils.get_parameter('LEGAL_ENTITY_ID',legislative_parameters),
225: pay_core_utils.get_parameter('SETUP_ACTION_ID',legislative_parameters),
226: report_type

Line 223: pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),

219: cursor get_params( c_payroll_action_id in pay_payroll_actions.payroll_action_id%type ) is
220: select pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters),
221: to_date('01-01-'||pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),
222: to_date('31-12-'|| pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),
223: pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),
224: pay_core_utils.get_parameter('LEGAL_ENTITY_ID',legislative_parameters),
225: pay_core_utils.get_parameter('SETUP_ACTION_ID',legislative_parameters),
226: report_type
227: from pay_payroll_actions

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

220: select pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters),
221: to_date('01-01-'||pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),
222: to_date('31-12-'|| pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),
223: pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),
224: pay_core_utils.get_parameter('LEGAL_ENTITY_ID',legislative_parameters),
225: pay_core_utils.get_parameter('SETUP_ACTION_ID',legislative_parameters),
226: report_type
227: from pay_payroll_actions
228: where payroll_action_id = c_payroll_action_id;

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

221: to_date('01-01-'||pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),
222: to_date('31-12-'|| pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),
223: pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),
224: pay_core_utils.get_parameter('LEGAL_ENTITY_ID',legislative_parameters),
225: pay_core_utils.get_parameter('SETUP_ACTION_ID',legislative_parameters),
226: report_type
227: from pay_payroll_actions
228: where payroll_action_id = c_payroll_action_id;
229: ------------------------------------------------------------------------

Line 238: and organization_id = pay_core_utils.get_parameter('LEGAL_ENTITY_ID',legislative_parameters)

234: select org_information19
235: from hr_organization_information,
236: pay_payroll_actions
237: where org_information_context ='SG_LEGAL_ENTITY'
238: and organization_id = pay_core_utils.get_parameter('LEGAL_ENTITY_ID',legislative_parameters)
239: and payroll_action_id = p_payroll_action_id;
240: begin
241: if g_debug then
242: hr_utility.set_location('pysgiraa: Start of initialization_code',6);

Line 3412: select pay_core_utils.get_parameter('SETUP_ACTION_ID',legislative_parameters)

3408: from pay_payroll_actions ppa
3409: where ppa.payroll_action_id = p_payroll_action_id ;
3410: --
3411: if l_report_type = 'SG_IRAS_AMEND_ARCHIVE' then
3412: select pay_core_utils.get_parameter('SETUP_ACTION_ID',legislative_parameters)
3413: into v_setup_action
3414: from pay_payroll_actions
3415: where payroll_action_id = p_payroll_action_id ;
3416: --------------------------------------------------------