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_JP_ITAX_PKG dependencies on PAY_ACTION_INFORMATION

Line 3: c_action_info_category_person CONSTANT pay_action_information.action_information_category%type := 'JP_ITAX_PERSON';

1: package body PAY_JP_ITAX_PKG as
2: /* $Header: pyjpitax.pkb 120.1 2006/05/30 09:12:07 sgottipa noship $ */
3: c_action_info_category_person CONSTANT pay_action_information.action_information_category%type := 'JP_ITAX_PERSON';
4: c_action_info_category_arch CONSTANT pay_action_information.action_information_category%type := 'JP_ITAX_ARCH';
5: c_action_info_category_tax CONSTANT pay_action_information.action_information_category%type := 'JP_ITAX_TAX';
6: c_action_info_category_other CONSTANT pay_action_information.action_information_category%type := 'JP_ITAX_OTHER';
7: c_action_info_category_other2 CONSTANT pay_action_information.action_information_category%type := 'JP_ITAX_OTHER2';

Line 4: c_action_info_category_arch CONSTANT pay_action_information.action_information_category%type := 'JP_ITAX_ARCH';

1: package body PAY_JP_ITAX_PKG as
2: /* $Header: pyjpitax.pkb 120.1 2006/05/30 09:12:07 sgottipa noship $ */
3: c_action_info_category_person CONSTANT pay_action_information.action_information_category%type := 'JP_ITAX_PERSON';
4: c_action_info_category_arch CONSTANT pay_action_information.action_information_category%type := 'JP_ITAX_ARCH';
5: c_action_info_category_tax CONSTANT pay_action_information.action_information_category%type := 'JP_ITAX_TAX';
6: c_action_info_category_other CONSTANT pay_action_information.action_information_category%type := 'JP_ITAX_OTHER';
7: c_action_info_category_other2 CONSTANT pay_action_information.action_information_category%type := 'JP_ITAX_OTHER2';
8: c_action_context_type CONSTANT pay_action_information.action_context_type%type := 'AAP';

Line 5: c_action_info_category_tax CONSTANT pay_action_information.action_information_category%type := 'JP_ITAX_TAX';

1: package body PAY_JP_ITAX_PKG as
2: /* $Header: pyjpitax.pkb 120.1 2006/05/30 09:12:07 sgottipa noship $ */
3: c_action_info_category_person CONSTANT pay_action_information.action_information_category%type := 'JP_ITAX_PERSON';
4: c_action_info_category_arch CONSTANT pay_action_information.action_information_category%type := 'JP_ITAX_ARCH';
5: c_action_info_category_tax CONSTANT pay_action_information.action_information_category%type := 'JP_ITAX_TAX';
6: c_action_info_category_other CONSTANT pay_action_information.action_information_category%type := 'JP_ITAX_OTHER';
7: c_action_info_category_other2 CONSTANT pay_action_information.action_information_category%type := 'JP_ITAX_OTHER2';
8: c_action_context_type CONSTANT pay_action_information.action_context_type%type := 'AAP';
9: c_first_object_version_number CONSTANT pay_action_information.object_version_number%type := 1;

Line 6: c_action_info_category_other CONSTANT pay_action_information.action_information_category%type := 'JP_ITAX_OTHER';

2: /* $Header: pyjpitax.pkb 120.1 2006/05/30 09:12:07 sgottipa noship $ */
3: c_action_info_category_person CONSTANT pay_action_information.action_information_category%type := 'JP_ITAX_PERSON';
4: c_action_info_category_arch CONSTANT pay_action_information.action_information_category%type := 'JP_ITAX_ARCH';
5: c_action_info_category_tax CONSTANT pay_action_information.action_information_category%type := 'JP_ITAX_TAX';
6: c_action_info_category_other CONSTANT pay_action_information.action_information_category%type := 'JP_ITAX_OTHER';
7: c_action_info_category_other2 CONSTANT pay_action_information.action_information_category%type := 'JP_ITAX_OTHER2';
8: c_action_context_type CONSTANT pay_action_information.action_context_type%type := 'AAP';
9: c_first_object_version_number CONSTANT pay_action_information.object_version_number%type := 1;
10: c_enabled CONSTANT VARCHAR2(80) := 'Enabled';

Line 7: c_action_info_category_other2 CONSTANT pay_action_information.action_information_category%type := 'JP_ITAX_OTHER2';

3: c_action_info_category_person CONSTANT pay_action_information.action_information_category%type := 'JP_ITAX_PERSON';
4: c_action_info_category_arch CONSTANT pay_action_information.action_information_category%type := 'JP_ITAX_ARCH';
5: c_action_info_category_tax CONSTANT pay_action_information.action_information_category%type := 'JP_ITAX_TAX';
6: c_action_info_category_other CONSTANT pay_action_information.action_information_category%type := 'JP_ITAX_OTHER';
7: c_action_info_category_other2 CONSTANT pay_action_information.action_information_category%type := 'JP_ITAX_OTHER2';
8: c_action_context_type CONSTANT pay_action_information.action_context_type%type := 'AAP';
9: c_first_object_version_number CONSTANT pay_action_information.object_version_number%type := 1;
10: c_enabled CONSTANT VARCHAR2(80) := 'Enabled';
11: c_disabled CONSTANT VARCHAR2(80) := 'Disabled';

Line 8: c_action_context_type CONSTANT pay_action_information.action_context_type%type := 'AAP';

4: c_action_info_category_arch CONSTANT pay_action_information.action_information_category%type := 'JP_ITAX_ARCH';
5: c_action_info_category_tax CONSTANT pay_action_information.action_information_category%type := 'JP_ITAX_TAX';
6: c_action_info_category_other CONSTANT pay_action_information.action_information_category%type := 'JP_ITAX_OTHER';
7: c_action_info_category_other2 CONSTANT pay_action_information.action_information_category%type := 'JP_ITAX_OTHER2';
8: c_action_context_type CONSTANT pay_action_information.action_context_type%type := 'AAP';
9: c_first_object_version_number CONSTANT pay_action_information.object_version_number%type := 1;
10: c_enabled CONSTANT VARCHAR2(80) := 'Enabled';
11: c_disabled CONSTANT VARCHAR2(80) := 'Disabled';
12:

Line 9: c_first_object_version_number CONSTANT pay_action_information.object_version_number%type := 1;

5: c_action_info_category_tax CONSTANT pay_action_information.action_information_category%type := 'JP_ITAX_TAX';
6: c_action_info_category_other CONSTANT pay_action_information.action_information_category%type := 'JP_ITAX_OTHER';
7: c_action_info_category_other2 CONSTANT pay_action_information.action_information_category%type := 'JP_ITAX_OTHER2';
8: c_action_context_type CONSTANT pay_action_information.action_context_type%type := 'AAP';
9: c_first_object_version_number CONSTANT pay_action_information.object_version_number%type := 1;
10: c_enabled CONSTANT VARCHAR2(80) := 'Enabled';
11: c_disabled CONSTANT VARCHAR2(80) := 'Disabled';
12:
13: FUNCTION NEXT_ACTION_INFORMATION_ID

Line 18: SELECT pay_action_information_s.nextval

14: RETURN number
15: IS
16: l_action_information_id number;
17: BEGIN
18: SELECT pay_action_information_s.nextval
19: INTO l_action_information_id
20: FROM dual;
21:
22: RETURN l_action_information_id;

Line 498: DELETE PAY_ACTION_INFORMATION PAI

494: )
495: IS
496: BEGIN
497: -- Fine Tuned the query to fix Bug# 5202835.
498: DELETE PAY_ACTION_INFORMATION PAI
499: WHERE PAI.ACTION_INFORMATION_CATEGORY in ('JP_ITAX_PERSON','JP_ITAX_ARCH','JP_ITAX_TAX','JP_ITAX_OTHER','JP_ITAX_OTHER2')
500: AND PAI.ASSIGNMENT_ID = p_assignment_id
501: AND EXISTS ( SELECT NULL
502: FROM PAY_ACTION_INFORMATION PERSON,

Line 502: FROM PAY_ACTION_INFORMATION PERSON,

498: DELETE PAY_ACTION_INFORMATION PAI
499: WHERE PAI.ACTION_INFORMATION_CATEGORY in ('JP_ITAX_PERSON','JP_ITAX_ARCH','JP_ITAX_TAX','JP_ITAX_OTHER','JP_ITAX_OTHER2')
500: AND PAI.ASSIGNMENT_ID = p_assignment_id
501: AND EXISTS ( SELECT NULL
502: FROM PAY_ACTION_INFORMATION PERSON,
503: PAY_ACTION_INFORMATION ARCH,
504: PAY_ACTION_INFORMATION TAX,
505: PAY_ACTION_INFORMATION OTHER,
506: PAY_ACTION_INFORMATION OTHER2

Line 503: PAY_ACTION_INFORMATION ARCH,

499: WHERE PAI.ACTION_INFORMATION_CATEGORY in ('JP_ITAX_PERSON','JP_ITAX_ARCH','JP_ITAX_TAX','JP_ITAX_OTHER','JP_ITAX_OTHER2')
500: AND PAI.ASSIGNMENT_ID = p_assignment_id
501: AND EXISTS ( SELECT NULL
502: FROM PAY_ACTION_INFORMATION PERSON,
503: PAY_ACTION_INFORMATION ARCH,
504: PAY_ACTION_INFORMATION TAX,
505: PAY_ACTION_INFORMATION OTHER,
506: PAY_ACTION_INFORMATION OTHER2
507: WHERE OTHER2.ACTION_INFORMATION_CATEGORY = 'JP_ITAX_OTHER2'

Line 504: PAY_ACTION_INFORMATION TAX,

500: AND PAI.ASSIGNMENT_ID = p_assignment_id
501: AND EXISTS ( SELECT NULL
502: FROM PAY_ACTION_INFORMATION PERSON,
503: PAY_ACTION_INFORMATION ARCH,
504: PAY_ACTION_INFORMATION TAX,
505: PAY_ACTION_INFORMATION OTHER,
506: PAY_ACTION_INFORMATION OTHER2
507: WHERE OTHER2.ACTION_INFORMATION_CATEGORY = 'JP_ITAX_OTHER2'
508: AND OTHER2.ACTION_CONTEXT_TYPE = 'AAP'

Line 505: PAY_ACTION_INFORMATION OTHER,

501: AND EXISTS ( SELECT NULL
502: FROM PAY_ACTION_INFORMATION PERSON,
503: PAY_ACTION_INFORMATION ARCH,
504: PAY_ACTION_INFORMATION TAX,
505: PAY_ACTION_INFORMATION OTHER,
506: PAY_ACTION_INFORMATION OTHER2
507: WHERE OTHER2.ACTION_INFORMATION_CATEGORY = 'JP_ITAX_OTHER2'
508: AND OTHER2.ACTION_CONTEXT_TYPE = 'AAP'
509: AND OTHER2.ASSIGNMENT_ID = p_assignment_id

Line 506: PAY_ACTION_INFORMATION OTHER2

502: FROM PAY_ACTION_INFORMATION PERSON,
503: PAY_ACTION_INFORMATION ARCH,
504: PAY_ACTION_INFORMATION TAX,
505: PAY_ACTION_INFORMATION OTHER,
506: PAY_ACTION_INFORMATION OTHER2
507: WHERE OTHER2.ACTION_INFORMATION_CATEGORY = 'JP_ITAX_OTHER2'
508: AND OTHER2.ACTION_CONTEXT_TYPE = 'AAP'
509: AND OTHER2.ASSIGNMENT_ID = p_assignment_id
510: AND to_char(OTHER2.EFFECTIVE_DATE,'YYYY') = to_char(p_effective_date,'YYYY')