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

Line 69: select nvl(to_date(to_char(to_date(pay_core_utils.get_parameter('EFFECTIVE_DATE', legislative_parameters),

65: -- Legislative Parameters for Run
66: ----------------------------------------------------------------------------
67: cursor get_params( c_payroll_action_id in pay_payroll_actions.payroll_action_id%type )
68: is
69: select nvl(to_date(to_char(to_date(pay_core_utils.get_parameter('EFFECTIVE_DATE', legislative_parameters),
70: 'YYYY/MM/DD'),'DD-MM-YYYY'),'DD-MM-YYYY'),
71: to_date('31-12-'||pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY')),
72: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters),
73: to_date('01-01-'||pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),

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

67: cursor get_params( c_payroll_action_id in pay_payroll_actions.payroll_action_id%type )
68: is
69: select nvl(to_date(to_char(to_date(pay_core_utils.get_parameter('EFFECTIVE_DATE', legislative_parameters),
70: 'YYYY/MM/DD'),'DD-MM-YYYY'),'DD-MM-YYYY'),
71: to_date('31-12-'||pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY')),
72: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters),
73: to_date('01-01-'||pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),
74: to_date('31-12-'|| pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),
75: pay_core_utils.get_parameter('LEGAL_ENTITY_ID',legislative_parameters),

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

68: is
69: select nvl(to_date(to_char(to_date(pay_core_utils.get_parameter('EFFECTIVE_DATE', legislative_parameters),
70: 'YYYY/MM/DD'),'DD-MM-YYYY'),'DD-MM-YYYY'),
71: to_date('31-12-'||pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY')),
72: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters),
73: to_date('01-01-'||pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),
74: to_date('31-12-'|| pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),
75: pay_core_utils.get_parameter('LEGAL_ENTITY_ID',legislative_parameters),
76: pay_core_utils.get_parameter('ASSIGNMENT_SET_ID',legislative_parameters),

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

69: select nvl(to_date(to_char(to_date(pay_core_utils.get_parameter('EFFECTIVE_DATE', legislative_parameters),
70: 'YYYY/MM/DD'),'DD-MM-YYYY'),'DD-MM-YYYY'),
71: to_date('31-12-'||pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY')),
72: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters),
73: to_date('01-01-'||pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),
74: to_date('31-12-'|| pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),
75: pay_core_utils.get_parameter('LEGAL_ENTITY_ID',legislative_parameters),
76: pay_core_utils.get_parameter('ASSIGNMENT_SET_ID',legislative_parameters),
77: pay_core_utils.get_parameter('PERSON_ID',legislative_parameters),

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

70: 'YYYY/MM/DD'),'DD-MM-YYYY'),'DD-MM-YYYY'),
71: to_date('31-12-'||pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY')),
72: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters),
73: to_date('01-01-'||pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),
74: to_date('31-12-'|| pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),
75: pay_core_utils.get_parameter('LEGAL_ENTITY_ID',legislative_parameters),
76: pay_core_utils.get_parameter('ASSIGNMENT_SET_ID',legislative_parameters),
77: pay_core_utils.get_parameter('PERSON_ID',legislative_parameters),
78: pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters)

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

71: to_date('31-12-'||pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY')),
72: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters),
73: to_date('01-01-'||pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),
74: to_date('31-12-'|| pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),
75: pay_core_utils.get_parameter('LEGAL_ENTITY_ID',legislative_parameters),
76: pay_core_utils.get_parameter('ASSIGNMENT_SET_ID',legislative_parameters),
77: pay_core_utils.get_parameter('PERSON_ID',legislative_parameters),
78: pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters)
79: from pay_payroll_actions

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

72: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters),
73: to_date('01-01-'||pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),
74: to_date('31-12-'|| pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),
75: pay_core_utils.get_parameter('LEGAL_ENTITY_ID',legislative_parameters),
76: pay_core_utils.get_parameter('ASSIGNMENT_SET_ID',legislative_parameters),
77: pay_core_utils.get_parameter('PERSON_ID',legislative_parameters),
78: pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters)
79: from pay_payroll_actions
80: where payroll_action_id =c_payroll_Action_id;

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

73: to_date('01-01-'||pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),
74: to_date('31-12-'|| pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),
75: pay_core_utils.get_parameter('LEGAL_ENTITY_ID',legislative_parameters),
76: pay_core_utils.get_parameter('ASSIGNMENT_SET_ID',legislative_parameters),
77: pay_core_utils.get_parameter('PERSON_ID',legislative_parameters),
78: pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters)
79: from pay_payroll_actions
80: where payroll_action_id =c_payroll_Action_id;
81: ----------------------------------------------------------------------------

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

74: to_date('31-12-'|| pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),
75: pay_core_utils.get_parameter('LEGAL_ENTITY_ID',legislative_parameters),
76: pay_core_utils.get_parameter('ASSIGNMENT_SET_ID',legislative_parameters),
77: pay_core_utils.get_parameter('PERSON_ID',legislative_parameters),
78: pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters)
79: from pay_payroll_actions
80: where payroll_action_id =c_payroll_Action_id;
81: ----------------------------------------------------------------------------
82: -- Cursor Next Assignment Action

Line 130: and pay_core_utils.get_parameter('LEGAL_ENTITY_ID',mpl.legislative_parameters) = v_legal_entity_id

126: and paf.assignment_id = mcl.assignment_id
127: and mpl.payroll_action_id = mcl.payroll_action_id
128: and mpl.business_group_id = pa.business_group_id
129: and mpl.effective_date between v_basis_start and v_basis_end
130: and pay_core_utils.get_parameter('LEGAL_ENTITY_ID',mpl.legislative_parameters) = v_legal_entity_id
131: and mpl.report_type in ( 'SG_A8B','SG_IR8A','SG_IR8S','SG_A8A' )
132: and mpl.action_type = 'X'
133: and mcl.action_status = 'C'
134: group by paf.assignment_id

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

311: v_action_parameter_group varchar2(50);
312:
313: --
314: cursor csr_iras_action_details is
315: select pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters),
316: pay_core_utils.get_parameter('LEGAL_ENTITY_ID',legislative_parameters),
317: pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),
318: pay_core_utils.get_parameter('MAGNETIC_FILE_NAME',legislative_parameters),
319: pay_core_utils.get_parameter('ACTION_PARAMETER_GROUP',legislative_parameters),

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

312:
313: --
314: cursor csr_iras_action_details is
315: select pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters),
316: pay_core_utils.get_parameter('LEGAL_ENTITY_ID',legislative_parameters),
317: pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),
318: pay_core_utils.get_parameter('MAGNETIC_FILE_NAME',legislative_parameters),
319: pay_core_utils.get_parameter('ACTION_PARAMETER_GROUP',legislative_parameters),
320: pay_core_utils.get_parameter('ASSIGNMENT_SET_ID',legislative_parameters),

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

313: --
314: cursor csr_iras_action_details is
315: select pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters),
316: pay_core_utils.get_parameter('LEGAL_ENTITY_ID',legislative_parameters),
317: pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),
318: pay_core_utils.get_parameter('MAGNETIC_FILE_NAME',legislative_parameters),
319: pay_core_utils.get_parameter('ACTION_PARAMETER_GROUP',legislative_parameters),
320: pay_core_utils.get_parameter('ASSIGNMENT_SET_ID',legislative_parameters),
321: pay_core_utils.get_parameter('PERSON_ID',legislative_parameters)

Line 318: pay_core_utils.get_parameter('MAGNETIC_FILE_NAME',legislative_parameters),

314: cursor csr_iras_action_details is
315: select pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters),
316: pay_core_utils.get_parameter('LEGAL_ENTITY_ID',legislative_parameters),
317: pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),
318: pay_core_utils.get_parameter('MAGNETIC_FILE_NAME',legislative_parameters),
319: pay_core_utils.get_parameter('ACTION_PARAMETER_GROUP',legislative_parameters),
320: pay_core_utils.get_parameter('ASSIGNMENT_SET_ID',legislative_parameters),
321: pay_core_utils.get_parameter('PERSON_ID',legislative_parameters)
322: from pay_payroll_actions

Line 319: pay_core_utils.get_parameter('ACTION_PARAMETER_GROUP',legislative_parameters),

315: select pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters),
316: pay_core_utils.get_parameter('LEGAL_ENTITY_ID',legislative_parameters),
317: pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),
318: pay_core_utils.get_parameter('MAGNETIC_FILE_NAME',legislative_parameters),
319: pay_core_utils.get_parameter('ACTION_PARAMETER_GROUP',legislative_parameters),
320: pay_core_utils.get_parameter('ASSIGNMENT_SET_ID',legislative_parameters),
321: pay_core_utils.get_parameter('PERSON_ID',legislative_parameters)
322: from pay_payroll_actions
323: where payroll_action_id = p_payroll_action_id;

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

316: pay_core_utils.get_parameter('LEGAL_ENTITY_ID',legislative_parameters),
317: pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),
318: pay_core_utils.get_parameter('MAGNETIC_FILE_NAME',legislative_parameters),
319: pay_core_utils.get_parameter('ACTION_PARAMETER_GROUP',legislative_parameters),
320: pay_core_utils.get_parameter('ASSIGNMENT_SET_ID',legislative_parameters),
321: pay_core_utils.get_parameter('PERSON_ID',legislative_parameters)
322: from pay_payroll_actions
323: where payroll_action_id = p_payroll_action_id;
324: begin

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

317: pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),
318: pay_core_utils.get_parameter('MAGNETIC_FILE_NAME',legislative_parameters),
319: pay_core_utils.get_parameter('ACTION_PARAMETER_GROUP',legislative_parameters),
320: pay_core_utils.get_parameter('ASSIGNMENT_SET_ID',legislative_parameters),
321: pay_core_utils.get_parameter('PERSON_ID',legislative_parameters)
322: from pay_payroll_actions
323: where payroll_action_id = p_payroll_action_id;
324: begin
325: if g_debug then