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_SE_TAX_DECL dependencies on PAY_SE_TAX_DECL

Line 1: PACKAGE BODY PAY_SE_TAX_DECL AS

1: PACKAGE BODY PAY_SE_TAX_DECL AS
2: /* $Header: pysetada.pkb 120.8 2008/01/25 11:58:23 rsengupt noship $ */
3:
4: g_debug boolean := hr_utility.debug_enabled;
5: l_business_id NUMBER;

Line 96: PAY_SE_TAX_DECL.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER')

92:
93:
94: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
95: SELECT
96: PAY_SE_TAX_DECL.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER')
97: ,PAY_SE_TAX_DECL.GET_PARAMETER(legislative_parameters,'MONTH')
98: ,PAY_SE_TAX_DECL.GET_PARAMETER(legislative_parameters,'YEAR')
99:
100: ,FND_DATE.canonical_to_date(PAY_SE_TAX_DECL.GET_PARAMETER(legislative_parameters,

Line 97: ,PAY_SE_TAX_DECL.GET_PARAMETER(legislative_parameters,'MONTH')

93:
94: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
95: SELECT
96: PAY_SE_TAX_DECL.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER')
97: ,PAY_SE_TAX_DECL.GET_PARAMETER(legislative_parameters,'MONTH')
98: ,PAY_SE_TAX_DECL.GET_PARAMETER(legislative_parameters,'YEAR')
99:
100: ,FND_DATE.canonical_to_date(PAY_SE_TAX_DECL.GET_PARAMETER(legislative_parameters,
101: 'DECLARATION_DUE_DATE'))

Line 98: ,PAY_SE_TAX_DECL.GET_PARAMETER(legislative_parameters,'YEAR')

94: CURSOR csr_parameter_info(p_payroll_action_id NUMBER) IS
95: SELECT
96: PAY_SE_TAX_DECL.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER')
97: ,PAY_SE_TAX_DECL.GET_PARAMETER(legislative_parameters,'MONTH')
98: ,PAY_SE_TAX_DECL.GET_PARAMETER(legislative_parameters,'YEAR')
99:
100: ,FND_DATE.canonical_to_date(PAY_SE_TAX_DECL.GET_PARAMETER(legislative_parameters,
101: 'DECLARATION_DUE_DATE'))
102: ,PAY_SE_TAX_DECL.GET_PARAMETER(legislative_parameters,'ADMINISTRATIVE_CODE')

Line 100: ,FND_DATE.canonical_to_date(PAY_SE_TAX_DECL.GET_PARAMETER(legislative_parameters,

96: PAY_SE_TAX_DECL.GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER')
97: ,PAY_SE_TAX_DECL.GET_PARAMETER(legislative_parameters,'MONTH')
98: ,PAY_SE_TAX_DECL.GET_PARAMETER(legislative_parameters,'YEAR')
99:
100: ,FND_DATE.canonical_to_date(PAY_SE_TAX_DECL.GET_PARAMETER(legislative_parameters,
101: 'DECLARATION_DUE_DATE'))
102: ,PAY_SE_TAX_DECL.GET_PARAMETER(legislative_parameters,'ADMINISTRATIVE_CODE')
103: ,PAY_SE_TAX_DECL.GET_PARAMETER(legislative_parameters,'INFORMATION')
104: ,PAY_SE_TAX_DECL.GET_PARAMETER(legislative_parameters,'ARCHIVE')

Line 102: ,PAY_SE_TAX_DECL.GET_PARAMETER(legislative_parameters,'ADMINISTRATIVE_CODE')

98: ,PAY_SE_TAX_DECL.GET_PARAMETER(legislative_parameters,'YEAR')
99:
100: ,FND_DATE.canonical_to_date(PAY_SE_TAX_DECL.GET_PARAMETER(legislative_parameters,
101: 'DECLARATION_DUE_DATE'))
102: ,PAY_SE_TAX_DECL.GET_PARAMETER(legislative_parameters,'ADMINISTRATIVE_CODE')
103: ,PAY_SE_TAX_DECL.GET_PARAMETER(legislative_parameters,'INFORMATION')
104: ,PAY_SE_TAX_DECL.GET_PARAMETER(legislative_parameters,'ARCHIVE')
105: ,effective_date
106: ,business_group_id

Line 103: ,PAY_SE_TAX_DECL.GET_PARAMETER(legislative_parameters,'INFORMATION')

99:
100: ,FND_DATE.canonical_to_date(PAY_SE_TAX_DECL.GET_PARAMETER(legislative_parameters,
101: 'DECLARATION_DUE_DATE'))
102: ,PAY_SE_TAX_DECL.GET_PARAMETER(legislative_parameters,'ADMINISTRATIVE_CODE')
103: ,PAY_SE_TAX_DECL.GET_PARAMETER(legislative_parameters,'INFORMATION')
104: ,PAY_SE_TAX_DECL.GET_PARAMETER(legislative_parameters,'ARCHIVE')
105: ,effective_date
106: ,business_group_id
107: FROM pay_payroll_actions

Line 104: ,PAY_SE_TAX_DECL.GET_PARAMETER(legislative_parameters,'ARCHIVE')

100: ,FND_DATE.canonical_to_date(PAY_SE_TAX_DECL.GET_PARAMETER(legislative_parameters,
101: 'DECLARATION_DUE_DATE'))
102: ,PAY_SE_TAX_DECL.GET_PARAMETER(legislative_parameters,'ADMINISTRATIVE_CODE')
103: ,PAY_SE_TAX_DECL.GET_PARAMETER(legislative_parameters,'INFORMATION')
104: ,PAY_SE_TAX_DECL.GET_PARAMETER(legislative_parameters,'ARCHIVE')
105: ,effective_date
106: ,business_group_id
107: FROM pay_payroll_actions
108: WHERE payroll_action_id = p_payroll_action_id;

Line 254: nvl(pay_balance_pkg.get_value(pay_se_tax_decl.get_defined_balance_id

250: NULL,NULL,NULL,l_effective_date),0) Special_65_Tax,
251: nvl(pay_balance_pkg.get_value(get_defined_balance_id
252: ('Special Taxation Year 1937 Taxable Base','_LE_MONTH'),NULL,l_legal_employer_id,
253: NULL,NULL,NULL,l_effective_date),0) Special_1937_Taxable_Base,
254: nvl(pay_balance_pkg.get_value(pay_se_tax_decl.get_defined_balance_id
255: ('Special Taxation Year 1937 Tax','_LE_MONTH'),NULL,l_legal_employer_id,
256: NULL,NULL,NULL,l_effective_date),0) Special_1937_Tax,
257: nvl(pay_balance_pkg.get_value(pay_se_tax_decl.get_defined_balance_id
258: ('Foreigners Below 65 Employer Taxable Base','_LE_MONTH'),NULL,l_legal_employer_id,

Line 257: nvl(pay_balance_pkg.get_value(pay_se_tax_decl.get_defined_balance_id

253: NULL,NULL,NULL,l_effective_date),0) Special_1937_Taxable_Base,
254: nvl(pay_balance_pkg.get_value(pay_se_tax_decl.get_defined_balance_id
255: ('Special Taxation Year 1937 Tax','_LE_MONTH'),NULL,l_legal_employer_id,
256: NULL,NULL,NULL,l_effective_date),0) Special_1937_Tax,
257: nvl(pay_balance_pkg.get_value(pay_se_tax_decl.get_defined_balance_id
258: ('Foreigners Below 65 Employer Taxable Base','_LE_MONTH'),NULL,l_legal_employer_id,
259: NULL,NULL,NULL,l_effective_date),0) Comp_Without_Lu,
260: nvl(pay_balance_pkg.get_value(pay_se_tax_decl.get_defined_balance_id
261: ('Foreigners Below 65 Employer Tax','_LE_MONTH'),NULL,l_legal_employer_id,

Line 260: nvl(pay_balance_pkg.get_value(pay_se_tax_decl.get_defined_balance_id

256: NULL,NULL,NULL,l_effective_date),0) Special_1937_Tax,
257: nvl(pay_balance_pkg.get_value(pay_se_tax_decl.get_defined_balance_id
258: ('Foreigners Below 65 Employer Taxable Base','_LE_MONTH'),NULL,l_legal_employer_id,
259: NULL,NULL,NULL,l_effective_date),0) Comp_Without_Lu,
260: nvl(pay_balance_pkg.get_value(pay_se_tax_decl.get_defined_balance_id
261: ('Foreigners Below 65 Employer Tax','_LE_MONTH'),NULL,l_legal_employer_id,
262: NULL,NULL,NULL,l_effective_date),0) Comp_Without_Lu_29,
263: nvl(pay_balance_pkg.get_value(pay_se_tax_decl.get_defined_balance_id
264: ('Foreigners Below 25 Employer Taxable Base','_LE_MONTH'),NULL,l_legal_employer_id,

Line 263: nvl(pay_balance_pkg.get_value(pay_se_tax_decl.get_defined_balance_id

259: NULL,NULL,NULL,l_effective_date),0) Comp_Without_Lu,
260: nvl(pay_balance_pkg.get_value(pay_se_tax_decl.get_defined_balance_id
261: ('Foreigners Below 65 Employer Tax','_LE_MONTH'),NULL,l_legal_employer_id,
262: NULL,NULL,NULL,l_effective_date),0) Comp_Without_Lu_29,
263: nvl(pay_balance_pkg.get_value(pay_se_tax_decl.get_defined_balance_id
264: ('Foreigners Below 25 Employer Taxable Base','_LE_MONTH'),NULL,l_legal_employer_id,
265: NULL,NULL,NULL,l_effective_date),0) Comp_Without_Lu_25_Below,
266: nvl(pay_balance_pkg.get_value(pay_se_tax_decl.get_defined_balance_id
267: ('Foreigners Below 25 Employer Tax','_LE_MONTH'),NULL,l_legal_employer_id,

Line 266: nvl(pay_balance_pkg.get_value(pay_se_tax_decl.get_defined_balance_id

262: NULL,NULL,NULL,l_effective_date),0) Comp_Without_Lu_29,
263: nvl(pay_balance_pkg.get_value(pay_se_tax_decl.get_defined_balance_id
264: ('Foreigners Below 25 Employer Taxable Base','_LE_MONTH'),NULL,l_legal_employer_id,
265: NULL,NULL,NULL,l_effective_date),0) Comp_Without_Lu_25_Below,
266: nvl(pay_balance_pkg.get_value(pay_se_tax_decl.get_defined_balance_id
267: ('Foreigners Below 25 Employer Tax','_LE_MONTH'),NULL,l_legal_employer_id,
268: NULL,NULL,NULL,l_effective_date),0) Comp_Without_Lu_29_25_below,
269: nvl(pay_balance_pkg.get_value(pay_se_tax_decl.get_defined_balance_id
270: ('Foreigners Above 65 Employer Taxable Base','_LE_MONTH'),NULL,l_legal_employer_id,

Line 269: nvl(pay_balance_pkg.get_value(pay_se_tax_decl.get_defined_balance_id

265: NULL,NULL,NULL,l_effective_date),0) Comp_Without_Lu_25_Below,
266: nvl(pay_balance_pkg.get_value(pay_se_tax_decl.get_defined_balance_id
267: ('Foreigners Below 25 Employer Tax','_LE_MONTH'),NULL,l_legal_employer_id,
268: NULL,NULL,NULL,l_effective_date),0) Comp_Without_Lu_29_25_below,
269: nvl(pay_balance_pkg.get_value(pay_se_tax_decl.get_defined_balance_id
270: ('Foreigners Above 65 Employer Taxable Base','_LE_MONTH'),NULL,l_legal_employer_id,
271: NULL,NULL,NULL,l_effective_date),0) Comp_Without_Lu_65_above,
272: nvl(pay_balance_pkg.get_value(pay_se_tax_decl.get_defined_balance_id
273: ('Foreigners Above 65 Employer Tax','_LE_MONTH'),NULL,l_legal_employer_id,

Line 272: nvl(pay_balance_pkg.get_value(pay_se_tax_decl.get_defined_balance_id

268: NULL,NULL,NULL,l_effective_date),0) Comp_Without_Lu_29_25_below,
269: nvl(pay_balance_pkg.get_value(pay_se_tax_decl.get_defined_balance_id
270: ('Foreigners Above 65 Employer Taxable Base','_LE_MONTH'),NULL,l_legal_employer_id,
271: NULL,NULL,NULL,l_effective_date),0) Comp_Without_Lu_65_above,
272: nvl(pay_balance_pkg.get_value(pay_se_tax_decl.get_defined_balance_id
273: ('Foreigners Above 65 Employer Tax','_LE_MONTH'),NULL,l_legal_employer_id,
274: NULL,NULL,NULL,l_effective_date),0) Comp_Without_Lu_29_65_above,
275: nvl(pay_balance_pkg.get_value(pay_se_tax_decl.get_defined_balance_id
276: ('Special Taxation Age 25 below Taxable Base','_LE_MONTH'),NULL,l_legal_employer_id,

Line 275: nvl(pay_balance_pkg.get_value(pay_se_tax_decl.get_defined_balance_id

271: NULL,NULL,NULL,l_effective_date),0) Comp_Without_Lu_65_above,
272: nvl(pay_balance_pkg.get_value(pay_se_tax_decl.get_defined_balance_id
273: ('Foreigners Above 65 Employer Tax','_LE_MONTH'),NULL,l_legal_employer_id,
274: NULL,NULL,NULL,l_effective_date),0) Comp_Without_Lu_29_65_above,
275: nvl(pay_balance_pkg.get_value(pay_se_tax_decl.get_defined_balance_id
276: ('Special Taxation Age 25 below Taxable Base','_LE_MONTH'),NULL,l_legal_employer_id,
277: NULL,NULL,NULL,l_effective_date),0) Special_25_below_Taxable_Base,
278: nvl(pay_balance_pkg.get_value(pay_se_tax_decl.get_defined_balance_id
279: ('Special Taxation Age 25 below Tax','_LE_MONTH'),NULL,l_legal_employer_id,

Line 278: nvl(pay_balance_pkg.get_value(pay_se_tax_decl.get_defined_balance_id

274: NULL,NULL,NULL,l_effective_date),0) Comp_Without_Lu_29_65_above,
275: nvl(pay_balance_pkg.get_value(pay_se_tax_decl.get_defined_balance_id
276: ('Special Taxation Age 25 below Taxable Base','_LE_MONTH'),NULL,l_legal_employer_id,
277: NULL,NULL,NULL,l_effective_date),0) Special_25_below_Taxable_Base,
278: nvl(pay_balance_pkg.get_value(pay_se_tax_decl.get_defined_balance_id
279: ('Special Taxation Age 25 below Tax','_LE_MONTH'),NULL,l_legal_employer_id,
280: NULL,NULL,NULL,l_effective_date),0) Special_25_below_Tax,
281: nvl(hoi4.org_information4,0) Certain_Insurances,
282: nvl(hoi4.org_information5,0) Certain_Insurances_29,

Line 355: PAY_SE_TAX_DECL.GET_ALL_PARAMETERS(

351: ORDER BY ppf.person_id';
352:
353:
354: -- fetch the input parameter values
355: PAY_SE_TAX_DECL.GET_ALL_PARAMETERS(
356: pactid
357: ,l_business_id
358: ,l_effective_date
359: ,l_archive

Line 580: END PAY_SE_TAX_DECL;

576: END IF;
577:
578: END ARCHIVE_CODE;
579:
580: END PAY_SE_TAX_DECL;