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_INPUT_VALUES_F

Line 29: (input_name pay_input_values_f.name%TYPE

25: -- The following type is declared to store all
26: -- the inputs values of tax elements.
27: --
28: type t_input_values_rec is record
29: (input_name pay_input_values_f.name%TYPE
30: ,input_value_id pay_input_values_f.input_value_id%TYPE
31: ,input_value pay_element_entry_values.screen_entry_value%TYPE);
32:
33: type t_input_values_tab is table of t_input_values_rec

Line 30: ,input_value_id pay_input_values_f.input_value_id%TYPE

26: -- the inputs values of tax elements.
27: --
28: type t_input_values_rec is record
29: (input_name pay_input_values_f.name%TYPE
30: ,input_value_id pay_input_values_f.input_value_id%TYPE
31: ,input_value pay_element_entry_values.screen_entry_value%TYPE);
32:
33: type t_input_values_tab is table of t_input_values_rec
34: index by binary_integer;

Line 567: ,p_input_value_id IN pay_input_values_f.input_value_id%TYPE)

563: FUNCTION get_planned_value
564: (p_assignment_id IN per_assignments_f.assignment_id%TYPE
565: ,p_actual_value IN VARCHAR2
566: ,p_ele_entry_id IN pay_element_entries_f.element_entry_id%TYPE
567: ,p_input_value_id IN pay_input_values_f.input_value_id%TYPE)
568: RETURN VARCHAR2
569: IS
570: --
571: CURSOR csr_entry_value(c_effective_date IN DATE)

Line 694: , pay_input_values_f inputs

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

Line 1131: , pay_input_values_f inputs

1127: IS
1128: SELECT inputs.name
1129: , inputs.input_value_id
1130: FROM pay_element_types_f types
1131: , pay_input_values_f inputs
1132: WHERE types.element_type_id = c_element_type_id
1133: AND inputs.element_type_id = types.element_type_id
1134: AND inputs.legislation_code = g_legislation_code
1135: AND sysdate BETWEEN types.effective_start_date

Line 3350: , pay_input_values_f inputs1

3346: , pay_element_links_f link
3347: , pay_element_types_f types
3348: , pay_element_entries_f entries
3349: , pay_element_entry_values_f value1
3350: , pay_input_values_f inputs1
3351: , pay_element_entry_values_f value2
3352: , pay_input_values_f inputs2
3353: WHERE assgn.assignment_id = p_assignment_id
3354: AND link.element_link_id = pay_in_utils.get_element_link_id(p_assignment_id

Line 3352: , pay_input_values_f inputs2

3348: , pay_element_entries_f entries
3349: , pay_element_entry_values_f value1
3350: , pay_input_values_f inputs1
3351: , pay_element_entry_values_f value2
3352: , pay_input_values_f inputs2
3353: WHERE assgn.assignment_id = p_assignment_id
3354: AND link.element_link_id = pay_in_utils.get_element_link_id(p_assignment_id
3355: ,c_effective_date
3356: ,types.element_type_id

Line 3387: pay_input_values_f piv,

3383: CURSOR c_screen_entry_value(p_effective_date DATE)
3384: IS
3385: SELECT peev.screen_entry_value
3386: FROM pay_element_entries_f peef,
3387: pay_input_values_f piv,
3388: pay_element_entry_values_f peev
3389: WHERE peef.element_entry_id = p_element_entry_id
3390: AND piv.element_type_id = peef.element_type_id
3391: AND piv.name = 'Component Name'

Line 6255: , pay_input_values_f inputs1

6251: , pay_element_links_f link
6252: , pay_element_types_f types
6253: , pay_element_entries_f entries
6254: , pay_element_entry_values_f value1
6255: , pay_input_values_f inputs1
6256: , pay_element_entry_values_f value2
6257: , pay_input_values_f inputs2
6258: , pay_element_entry_values_f value3
6259: , pay_input_values_f inputs3

Line 6257: , pay_input_values_f inputs2

6253: , pay_element_entries_f entries
6254: , pay_element_entry_values_f value1
6255: , pay_input_values_f inputs1
6256: , pay_element_entry_values_f value2
6257: , pay_input_values_f inputs2
6258: , pay_element_entry_values_f value3
6259: , pay_input_values_f inputs3
6260: WHERE assgn.assignment_id = p_assignment_id
6261: AND link.element_link_id = p_element_link_id-- Changed for bug 4774108

Line 6259: , pay_input_values_f inputs3

6255: , pay_input_values_f inputs1
6256: , pay_element_entry_values_f value2
6257: , pay_input_values_f inputs2
6258: , pay_element_entry_values_f value3
6259: , pay_input_values_f inputs3
6260: WHERE assgn.assignment_id = p_assignment_id
6261: AND link.element_link_id = p_element_link_id-- Changed for bug 4774108
6262: AND (types.processing_type = 'R' OR assgn.payroll_id IS NOT NULL)
6263: AND link.business_group_id = assgn.business_group_id

Line 6312: , pay_input_values_f inputs1

6308: , pay_element_links_f link
6309: , pay_element_types_f types
6310: , pay_element_entries_f entries
6311: , pay_element_entry_values_f value1
6312: , pay_input_values_f inputs1
6313: , pay_element_entry_values_f value2
6314: , pay_input_values_f inputs2
6315: WHERE assgn.assignment_id = p_assignment_id
6316: AND link.element_link_id = p_element_link_id

Line 6314: , pay_input_values_f inputs2

6310: , pay_element_entries_f entries
6311: , pay_element_entry_values_f value1
6312: , pay_input_values_f inputs1
6313: , pay_element_entry_values_f value2
6314: , pay_input_values_f inputs2
6315: WHERE assgn.assignment_id = p_assignment_id
6316: AND link.element_link_id = p_element_link_id
6317: AND (types.processing_type = 'R' OR assgn.payroll_id IS NOT NULL)
6318: AND link.business_group_id = assgn.business_group_id

Line 6359: , pay_input_values_f inputs1

6355: , pay_element_links_f link
6356: , pay_element_types_f types
6357: , pay_element_entries_f entries
6358: , pay_element_entry_values_f value1
6359: , pay_input_values_f inputs1
6360: , pay_element_entry_values_f value2
6361: , pay_input_values_f inputs2
6362: WHERE assgn.assignment_id = p_assignment_id
6363: AND link.element_link_id = p_element_link_id

Line 6361: , pay_input_values_f inputs2

6357: , pay_element_entries_f entries
6358: , pay_element_entry_values_f value1
6359: , pay_input_values_f inputs1
6360: , pay_element_entry_values_f value2
6361: , pay_input_values_f inputs2
6362: WHERE assgn.assignment_id = p_assignment_id
6363: AND link.element_link_id = p_element_link_id
6364: AND (types.processing_type = 'R' OR assgn.payroll_id IS NOT NULL)
6365: AND link.business_group_id = assgn.business_group_id

Line 6408: , pay_input_values_f inputs1

6404: , pay_element_links_f link
6405: , pay_element_types_f types
6406: , pay_element_entries_f entries
6407: , pay_element_entry_values_f value1
6408: , pay_input_values_f inputs1
6409: , pay_element_entry_values_f value2
6410: , pay_input_values_f inputs2
6411: WHERE assgn.assignment_id = p_assignment_id
6412: AND link.element_link_id = p_element_link_id

Line 6410: , pay_input_values_f inputs2

6406: , pay_element_entries_f entries
6407: , pay_element_entry_values_f value1
6408: , pay_input_values_f inputs1
6409: , pay_element_entry_values_f value2
6410: , pay_input_values_f inputs2
6411: WHERE assgn.assignment_id = p_assignment_id
6412: AND link.element_link_id = p_element_link_id
6413: AND (types.processing_type = 'R' OR assgn.payroll_id IS NOT NULL)
6414: AND link.business_group_id = assgn.business_group_id