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

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

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

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

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

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

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

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

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

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

68: 'YYYY/MM/DD'),'DD-MM-YYYY'),'DD-MM-YYYY'),
69: to_date('31-12-'||pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY')),
70: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters),
71: to_date('01-01-'||pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),
72: to_date('31-12-'|| pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),
73: pay_core_utils.get_parameter('LEGAL_ENTITY_ID',legislative_parameters),
74: pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters)
75: from pay_payroll_actions
76: where payroll_action_id =c_payroll_Action_id;

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

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

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

70: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters),
71: to_date('01-01-'||pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),
72: to_date('31-12-'|| pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),
73: pay_core_utils.get_parameter('LEGAL_ENTITY_ID',legislative_parameters),
74: pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters)
75: from pay_payroll_actions
76: where payroll_action_id =c_payroll_Action_id;
77: ----------------------------------------------------------------------------
78: -- Cursor Next Assignment Action

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

119: and paf.assignment_id = mcl.assignment_id
120: and mpl.payroll_action_id = mcl.payroll_action_id
121: and mpl.business_group_id = pa.business_group_id
122: and mpl.effective_date between v_basis_start and v_basis_end
123: and pay_core_utils.get_parameter('LEGAL_ENTITY_ID',mpl.legislative_parameters) = v_legal_entity_id
124: and mpl.report_type in ( 'SG_A8B','SG_IR8A','SG_IR8S','SG_A8A' )
125: and mpl.action_type = 'X'
126: and mcl.action_status = 'C'
127: group by paf.assignment_id

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

299: v_business_group_id number;
300: v_action_parameter_group varchar2(50);
301: --
302: cursor csr_iras_action_details is
303: select pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters),
304: pay_core_utils.get_parameter('LEGAL_ENTITY_ID',legislative_parameters),
305: pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),
306: pay_core_utils.get_parameter('MAGNETIC_FILE_NAME',legislative_parameters),
307: pay_core_utils.get_parameter('ACTION_PARAMETER_GROUP',legislative_parameters)

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

300: v_action_parameter_group varchar2(50);
301: --
302: cursor csr_iras_action_details is
303: select pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters),
304: pay_core_utils.get_parameter('LEGAL_ENTITY_ID',legislative_parameters),
305: pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),
306: pay_core_utils.get_parameter('MAGNETIC_FILE_NAME',legislative_parameters),
307: pay_core_utils.get_parameter('ACTION_PARAMETER_GROUP',legislative_parameters)
308: from pay_payroll_actions

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

301: --
302: cursor csr_iras_action_details is
303: select pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters),
304: pay_core_utils.get_parameter('LEGAL_ENTITY_ID',legislative_parameters),
305: pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),
306: pay_core_utils.get_parameter('MAGNETIC_FILE_NAME',legislative_parameters),
307: pay_core_utils.get_parameter('ACTION_PARAMETER_GROUP',legislative_parameters)
308: from pay_payroll_actions
309: where payroll_action_id = p_payroll_action_id;

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

302: cursor csr_iras_action_details is
303: select pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters),
304: pay_core_utils.get_parameter('LEGAL_ENTITY_ID',legislative_parameters),
305: pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),
306: pay_core_utils.get_parameter('MAGNETIC_FILE_NAME',legislative_parameters),
307: pay_core_utils.get_parameter('ACTION_PARAMETER_GROUP',legislative_parameters)
308: from pay_payroll_actions
309: where payroll_action_id = p_payroll_action_id;
310: begin

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

303: select pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters),
304: pay_core_utils.get_parameter('LEGAL_ENTITY_ID',legislative_parameters),
305: pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),
306: pay_core_utils.get_parameter('MAGNETIC_FILE_NAME',legislative_parameters),
307: pay_core_utils.get_parameter('ACTION_PARAMETER_GROUP',legislative_parameters)
308: from pay_payroll_actions
309: where payroll_action_id = p_payroll_action_id;
310: begin
311: if g_debug then