APPS.PAY_US_EMP_DT_TAX_RULES dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 74: from PAY_ELEMENT_ENTRY_VALUES_F pev,

70: /* Cursor to get the element entry for the jurisdiction */
71:
72: cursor csr_ele_entry (p_element_link number, p_inp_val number)is
73: select pee.element_entry_id
74: from PAY_ELEMENT_ENTRY_VALUES_F pev,
75: PAY_ELEMENT_ENTRIES_F pee
76: where pev.screen_entry_value = p_jurisdiction_code
77: and pev.input_value_id + 0 = p_inp_val
78: and p_session_date between pev.effective_start_date

Line 90: from PAY_ELEMENT_ENTRY_VALUES_F pev

86: /* Cursor to get the current percentage of the element entry */
87:
88: cursor csr_get_curr_percnt (p_ele_entry_id number, p_inp_val number)is
89: select pev.screen_entry_value
90: from PAY_ELEMENT_ENTRY_VALUES_F pev
91: where pev.screen_entry_value is not null
92: and pev.input_value_id + 0 = p_inp_val
93: and p_session_date between pev.effective_start_date
94: and pev.effective_end_date

Line 6053: from PAY_ELEMENT_ENTRY_VALUES_F peev,

6049:
6050: cursor csr_get_jurisdiction is
6051: select peev.screen_entry_value jurisdiction,
6052: peef.effective_start_date start_date
6053: from PAY_ELEMENT_ENTRY_VALUES_F peev,
6054: PAY_ELEMENT_ENTRIES_F peef,
6055: PAY_INPUT_VALUES_F piv,
6056: PAY_ELEMENT_TYPES_F pet
6057: where pet.element_name = 'VERTEX'

Line 6997: from PAY_ELEMENT_ENTRY_VALUES_F pev,

6993: /* Cursor to get the element entry for the jurisdiction */
6994:
6995: cursor csr_ele_entry (p_element_link number, p_inp_val number)is
6996: select pee.element_entry_id
6997: from PAY_ELEMENT_ENTRY_VALUES_F pev,
6998: PAY_ELEMENT_ENTRIES_F pee
6999: where pev.screen_entry_value = p_jurisdiction_code
7000: and pev.input_value_id + 0 = p_inp_val
7001: and p_session_date between pev.effective_start_date

Line 7110: update PAY_ELEMENT_ENTRY_VALUES_F

7106: and p_session_date between effective_start_date
7107: and effective_end_date;
7108:
7109: l_step := 5;
7110: update PAY_ELEMENT_ENTRY_VALUES_F
7111: set effective_start_date = p_new_start_date
7112: where element_entry_id = l_element_entry_id
7113: and p_session_date between effective_start_date
7114: and effective_end_date;

Line 7128: update PAY_ELEMENT_ENTRY_VALUES_F

7124: and p_session_date between effective_start_date
7125: and effective_end_date;
7126:
7127: l_step := 7;
7128: update PAY_ELEMENT_ENTRY_VALUES_F
7129: set effective_end_date = p_new_end_date
7130: where element_entry_id = l_element_entry_id
7131: and p_session_date between effective_start_date
7132: and effective_end_date;

Line 7140: delete PAY_ELEMENT_ENTRY_VALUES_F

7136:
7137: /* Delete the element entries */
7138:
7139: l_step := 8;
7140: delete PAY_ELEMENT_ENTRY_VALUES_F
7141: where element_entry_id = l_element_entry_id
7142: and p_session_date between effective_start_date
7143: and effective_end_date;
7144:

Line 7451: update PAY_ELEMENT_ENTRY_VALUES_F

7447: and p_session_date between effective_start_date
7448: and effective_end_date;
7449:
7450: l_step := 5;
7451: update PAY_ELEMENT_ENTRY_VALUES_F
7452: set effective_start_date = p_new_start_date
7453: where element_entry_id = l_element_entry_id
7454: and p_session_date between effective_start_date
7455: and effective_end_date;

Line 7470: update PAY_ELEMENT_ENTRY_VALUES_F

7466: and p_session_date between effective_start_date
7467: and effective_end_date;
7468:
7469: l_step := 7;
7470: update PAY_ELEMENT_ENTRY_VALUES_F
7471: set effective_end_date = p_new_end_date
7472: where element_entry_id = l_element_entry_id
7473: and p_session_date between effective_start_date
7474: and effective_end_date;

Line 7482: delete PAY_ELEMENT_ENTRY_VALUES_F

7478:
7479: /* Delete the element entry */
7480:
7481: l_step := 8;
7482: delete PAY_ELEMENT_ENTRY_VALUES_F
7483: where element_entry_id = l_element_entry_id
7484: and p_session_date between effective_start_date
7485: and effective_end_date;
7486: