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_IN_TAX_DECLARATION dependencies on PAY_ELEMENT_ENTRY_VALUES

Line 32: ,input_value pay_element_entry_values.screen_entry_value%TYPE);

28: --
29: type t_input_values_rec is record
30: (input_name pay_input_values_f.name%TYPE
31: ,input_value_id pay_input_values_f.input_value_id%TYPE
32: ,input_value pay_element_entry_values.screen_entry_value%TYPE);
33:
34: type t_input_values_tab is table of t_input_values_rec
35: index by binary_integer;
36: --

Line 575: FROM pay_element_entry_values_f

571: --
572: CURSOR csr_entry_value(c_effective_date IN DATE)
573: IS
574: SELECT screen_entry_value
575: FROM pay_element_entry_values_f
576: WHERE element_entry_id = p_ele_entry_id
577: AND input_value_id = p_input_value_id
578: AND c_effective_date BETWEEN effective_start_date
579: AND effective_end_date;

Line 583: l_value pay_element_entry_values.screen_entry_value%TYPE;

579: AND effective_end_date;
580: --
581: l_procedure VARCHAR(100);
582: l_message VARCHAR2(250);
583: l_value pay_element_entry_values.screen_entry_value%TYPE;
584: l_locked VARCHAR2(2);
585: l_date_start DATE;
586: --
587: BEGIN

Line 694: , pay_element_entry_values_f value

690: FROM per_assignments_f assgn
691: , pay_element_links_f link
692: , pay_element_types_f types
693: , pay_element_entries_f entries
694: , pay_element_entry_values_f value
695: , pay_input_values_f inputs
696: WHERE assgn.assignment_id = p_assignment_id
697: AND link.element_link_id = pay_in_utils.get_element_link_id(p_assignment_id
698: ,c_effective_date

Line 3679: l_entry_value pay_element_entry_values_f.screen_entry_value%TYPE;

3675: l_effective_start_date DATE;
3676: l_effective_end_date DATE;
3677: l_ele_entry_id pay_element_entries.element_entry_id%TYPE;
3678: l_ovn pay_element_entries_f.object_version_number%TYPE;
3679: l_entry_value pay_element_entry_values_f.screen_entry_value%TYPE;
3680: l_element_name pay_element_types_f.element_name%TYPE;
3681: l_token1 VARCHAR2(240);
3682: --
3683: CURSOR csr_element_link_details

Line 3736: , pay_element_entry_values_f value1

3732: FROM per_assignments_f assgn
3733: , pay_element_links_f link
3734: , pay_element_types_f types
3735: , pay_element_entries_f entries
3736: , pay_element_entry_values_f value1
3737: , pay_input_values_f inputs1
3738: , pay_element_entry_values_f value2
3739: , pay_input_values_f inputs2
3740: WHERE assgn.assignment_id = p_assignment_id

Line 3738: , pay_element_entry_values_f value2

3734: , pay_element_types_f types
3735: , pay_element_entries_f entries
3736: , pay_element_entry_values_f value1
3737: , pay_input_values_f inputs1
3738: , pay_element_entry_values_f value2
3739: , pay_input_values_f inputs2
3740: WHERE assgn.assignment_id = p_assignment_id
3741: AND link.element_link_id = pay_in_utils.get_element_link_id(p_assignment_id
3742: ,c_effective_date

Line 3775: pay_element_entry_values_f peev

3771: IS
3772: SELECT peev.screen_entry_value
3773: FROM pay_element_entries_f peef,
3774: pay_input_values_f piv,
3775: pay_element_entry_values_f peev
3776: WHERE peef.element_entry_id = p_element_entry_id
3777: AND piv.element_type_id = peef.element_type_id
3778: AND piv.name = 'Component Name'
3779: AND peev.input_value_id = piv.input_value_id

Line 7128: , pay_element_entry_values_f value1

7124: FROM per_assignments_f assgn
7125: , pay_element_links_f link
7126: , pay_element_types_f types
7127: , pay_element_entries_f entries
7128: , pay_element_entry_values_f value1
7129: , pay_input_values_f inputs1
7130: , pay_element_entry_values_f value2
7131: , pay_input_values_f inputs2
7132: , pay_element_entry_values_f value3

Line 7130: , pay_element_entry_values_f value2

7126: , pay_element_types_f types
7127: , pay_element_entries_f entries
7128: , pay_element_entry_values_f value1
7129: , pay_input_values_f inputs1
7130: , pay_element_entry_values_f value2
7131: , pay_input_values_f inputs2
7132: , pay_element_entry_values_f value3
7133: , pay_input_values_f inputs3
7134: WHERE assgn.assignment_id = p_assignment_id

Line 7132: , pay_element_entry_values_f value3

7128: , pay_element_entry_values_f value1
7129: , pay_input_values_f inputs1
7130: , pay_element_entry_values_f value2
7131: , pay_input_values_f inputs2
7132: , pay_element_entry_values_f value3
7133: , pay_input_values_f inputs3
7134: WHERE assgn.assignment_id = p_assignment_id
7135: AND link.element_link_id = p_element_link_id-- Changed for bug 4774108
7136: AND (types.processing_type = 'R' OR assgn.payroll_id IS NOT NULL)

Line 7185: , pay_element_entry_values_f value1

7181: FROM per_assignments_f assgn
7182: , pay_element_links_f link
7183: , pay_element_types_f types
7184: , pay_element_entries_f entries
7185: , pay_element_entry_values_f value1
7186: , pay_input_values_f inputs1
7187: , pay_element_entry_values_f value2
7188: , pay_input_values_f inputs2
7189: WHERE assgn.assignment_id = p_assignment_id

Line 7187: , pay_element_entry_values_f value2

7183: , pay_element_types_f types
7184: , pay_element_entries_f entries
7185: , pay_element_entry_values_f value1
7186: , pay_input_values_f inputs1
7187: , pay_element_entry_values_f value2
7188: , pay_input_values_f inputs2
7189: WHERE assgn.assignment_id = p_assignment_id
7190: AND link.element_link_id = p_element_link_id
7191: AND (types.processing_type = 'R' OR assgn.payroll_id IS NOT NULL)

Line 7234: , pay_element_entry_values_f value1

7230: FROM per_assignments_f assgn
7231: , pay_element_links_f link
7232: , pay_element_types_f types
7233: , pay_element_entries_f entries
7234: , pay_element_entry_values_f value1
7235: , pay_input_values_f inputs1
7236: , pay_element_entry_values_f value2
7237: , pay_input_values_f inputs2
7238: , pay_element_entry_values_f value3

Line 7236: , pay_element_entry_values_f value2

7232: , pay_element_types_f types
7233: , pay_element_entries_f entries
7234: , pay_element_entry_values_f value1
7235: , pay_input_values_f inputs1
7236: , pay_element_entry_values_f value2
7237: , pay_input_values_f inputs2
7238: , pay_element_entry_values_f value3
7239: , pay_input_values_f inputs3
7240: , pay_element_entry_values_f value4

Line 7238: , pay_element_entry_values_f value3

7234: , pay_element_entry_values_f value1
7235: , pay_input_values_f inputs1
7236: , pay_element_entry_values_f value2
7237: , pay_input_values_f inputs2
7238: , pay_element_entry_values_f value3
7239: , pay_input_values_f inputs3
7240: , pay_element_entry_values_f value4
7241: , pay_input_values_f inputs4
7242: WHERE assgn.assignment_id = p_assignment_id

Line 7240: , pay_element_entry_values_f value4

7236: , pay_element_entry_values_f value2
7237: , pay_input_values_f inputs2
7238: , pay_element_entry_values_f value3
7239: , pay_input_values_f inputs3
7240: , pay_element_entry_values_f value4
7241: , pay_input_values_f inputs4
7242: WHERE assgn.assignment_id = p_assignment_id
7243: AND link.element_link_id = p_element_link_id
7244: AND (types.processing_type = 'R' OR assgn.payroll_id IS NOT NULL)

Line 7303: , pay_element_entry_values_f value1

7299: FROM per_assignments_f assgn
7300: , pay_element_links_f link
7301: , pay_element_types_f types
7302: , pay_element_entries_f entries
7303: , pay_element_entry_values_f value1
7304: , pay_input_values_f inputs1
7305: , pay_element_entry_values_f value2
7306: , pay_input_values_f inputs2
7307: WHERE assgn.assignment_id = p_assignment_id

Line 7305: , pay_element_entry_values_f value2

7301: , pay_element_types_f types
7302: , pay_element_entries_f entries
7303: , pay_element_entry_values_f value1
7304: , pay_input_values_f inputs1
7305: , pay_element_entry_values_f value2
7306: , pay_input_values_f inputs2
7307: WHERE assgn.assignment_id = p_assignment_id
7308: AND link.element_link_id = p_element_link_id
7309: AND (types.processing_type = 'R' OR assgn.payroll_id IS NOT NULL)