APPS.PAY_IN_TAX_DECLARATION dependencies on PAY_INPUT_VALUES_F

Line 30: (input_name pay_input_values_f.name%TYPE

26: -- The following type is declared to store all
27: -- the inputs values of tax elements.
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

Line 31: ,input_value_id pay_input_values_f.input_value_id%TYPE

27: -- the inputs values of tax elements.
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;

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

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

Line 695: , pay_input_values_f inputs

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
699: ,types.element_type_id

Line 1145: , pay_input_values_f inputs

1141: IS
1142: SELECT inputs.name
1143: , inputs.input_value_id
1144: FROM pay_element_types_f types
1145: , pay_input_values_f inputs
1146: WHERE types.element_type_id = c_element_type_id
1147: AND inputs.element_type_id = types.element_type_id
1148: AND inputs.legislation_code = g_legislation_code
1149: AND sysdate BETWEEN types.effective_start_date

Line 3737: , pay_input_values_f inputs1

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
3741: AND link.element_link_id = pay_in_utils.get_element_link_id(p_assignment_id

Line 3739: , pay_input_values_f inputs2

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
3743: ,types.element_type_id

Line 3774: pay_input_values_f piv,

3770: CURSOR c_screen_entry_value(p_effective_date DATE)
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'

Line 7129: , pay_input_values_f inputs1

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
7133: , pay_input_values_f inputs3

Line 7131: , pay_input_values_f inputs2

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
7135: AND link.element_link_id = p_element_link_id-- Changed for bug 4774108

Line 7133: , pay_input_values_f inputs3

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)
7137: AND link.business_group_id = assgn.business_group_id

Line 7186: , pay_input_values_f inputs1

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
7190: AND link.element_link_id = p_element_link_id

Line 7188: , pay_input_values_f inputs2

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)
7192: AND link.business_group_id = assgn.business_group_id

Line 7235: , pay_input_values_f inputs1

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
7239: , pay_input_values_f inputs3

Line 7237: , pay_input_values_f inputs2

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
7241: , pay_input_values_f inputs4

Line 7239: , pay_input_values_f inputs3

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
7243: AND link.element_link_id = p_element_link_id

Line 7241: , pay_input_values_f inputs4

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)
7245: AND link.business_group_id = assgn.business_group_id

Line 7304: , pay_input_values_f inputs1

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
7308: AND link.element_link_id = p_element_link_id

Line 7306: , pay_input_values_f inputs2

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)
7310: AND link.business_group_id = assgn.business_group_id