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_US_EMP_DT_TAX_RULES dependencies on PAY_ELEMENT_ENTRIES_F

Line 75: PAY_ELEMENT_ENTRIES_F pee

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
79: and pev.effective_end_date

Line 362: from PAY_ELEMENT_ENTRIES_F pee

358: /* Cursor to get the worker's compensation element entry */
359:
360: cursor csr_wc_ele_entry (p_element_link number)is
361: select pee.element_entry_id
362: from PAY_ELEMENT_ENTRIES_F pee
363: where p_session_date between pee.effective_start_date
364: and pee.effective_end_date
365: and pee.element_link_id = p_element_link
366: and pee.assignment_id = p_assignment_id;

Line 6054: PAY_ELEMENT_ENTRIES_F peef,

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'
6058: and pet.element_type_id = piv.element_type_id

Line 6069: -- PAY_ELEMENT_ENTRIES_F

6065: and peef.effective_start_date = p_effective_start_date
6066: and peef.effective_end_date = p_effective_end_date
6067: and peef.effective_start_date between pet.effective_start_date and pet.effective_end_date; -- Bug 3354060 added to remove MJC between
6068: -- PAY_INPUT_VALUES_F and
6069: -- PAY_ELEMENT_ENTRIES_F
6070:
6071: begin
6072:
6073: hr_utility.set_location('pay_us_emp_dt_tax_rules.zero_out_time',1);

Line 6998: PAY_ELEMENT_ENTRIES_F pee

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
7002: and pev.effective_end_date

Line 7103: update PAY_ELEMENT_ENTRIES_F

7099: if p_new_start_date is not null
7100: then
7101:
7102: l_step := 4;
7103: update PAY_ELEMENT_ENTRIES_F
7104: set effective_start_date = p_new_start_date
7105: where element_entry_id = l_element_entry_id
7106: and p_session_date between effective_start_date
7107: and effective_end_date;

Line 7121: update PAY_ELEMENT_ENTRIES_F

7117: if p_new_end_date is not null
7118: then
7119:
7120: l_step := 6;
7121: update PAY_ELEMENT_ENTRIES_F
7122: set effective_end_date = p_new_end_date
7123: where element_entry_id = l_element_entry_id
7124: and p_session_date between effective_start_date
7125: and effective_end_date;

Line 7148: delete PAY_ELEMENT_ENTRIES_F

7144:
7145: /* Delete the element entry values */
7146:
7147: l_step := 9;
7148: delete PAY_ELEMENT_ENTRIES_F
7149: where element_entry_id = l_element_entry_id
7150: and p_session_date between effective_start_date
7151: and effective_end_date;
7152:

Line 7374: from PAY_ELEMENT_ENTRIES_F pee

7370: /* Cursor to get the element entry for the jurisdiction */
7371:
7372: cursor csr_wc_ele_entry (p_element_link number)is
7373: select pee.element_entry_id
7374: from PAY_ELEMENT_ENTRIES_F pee
7375: where pee.assignment_id = p_assignment_id
7376: and p_session_date between pee.effective_start_date
7377: and pee.effective_end_date
7378: and pee.element_link_id = p_element_link;

Line 7444: update PAY_ELEMENT_ENTRIES_F

7440: if p_new_start_date is not null
7441: then
7442:
7443: l_step := 4;
7444: update PAY_ELEMENT_ENTRIES_F
7445: set effective_start_date = p_new_start_date
7446: where element_entry_id = l_element_entry_id
7447: and p_session_date between effective_start_date
7448: and effective_end_date;

Line 7463: update PAY_ELEMENT_ENTRIES_F

7459: if p_new_end_date is not null
7460: then
7461:
7462: l_step := 6;
7463: update PAY_ELEMENT_ENTRIES_F
7464: set effective_end_date = p_new_end_date
7465: where element_entry_id = l_element_entry_id
7466: and p_session_date between effective_start_date
7467: and effective_end_date;

Line 7490: delete PAY_ELEMENT_ENTRIES_F

7486:
7487: /* Delete the element entry values */
7488:
7489: l_step := 9;
7490: delete PAY_ELEMENT_ENTRIES_F
7491: where element_entry_id = l_element_entry_id
7492: and p_session_date between effective_start_date
7493: and effective_end_date;
7494: end if;

Line 7679: from PAY_ELEMENT_ENTRIES_F pee

7675:
7676: /* cursor to get the effective end date of the next element entry record */
7677: cursor csr_get_next_date (p_element_link number, p_date date)is
7678: select pee.effective_end_date
7679: from PAY_ELEMENT_ENTRIES_F pee
7680: where pee.assignment_id = p_assignment_id
7681: and p_date between pee.effective_start_date
7682: and pee.effective_end_date
7683: and pee.element_link_id = p_element_link

Line 7960: from pay_element_entries_f pef

7956: /* Cursor to check for multiple date effective records of the vertex
7957: element entries */
7958: cursor csr_multiple_rec(p_def_date date, p_ele_link number) is
7959: select 'Y'
7960: from pay_element_entries_f pef
7961: where pef.assignment_id = p_assignment_id
7962: and pef.element_link_id = p_ele_link
7963: and pef.effective_start_date >= p_def_date
7964: and exists (select null

Line 7965: from pay_element_entries_f pee

7961: where pef.assignment_id = p_assignment_id
7962: and pef.element_link_id = p_ele_link
7963: and pef.effective_start_date >= p_def_date
7964: and exists (select null
7965: from pay_element_entries_f pee
7966: where pee.assignment_id = p_assignment_id
7967: and pee.element_entry_id = pef.element_entry_id
7968: and pee.effective_start_date >= p_def_date
7969: and pee.effective_start_date <> pef.effective_start_date);

Line 7977: from PAY_ELEMENT_ENTRIES_F pee

7973: cursor csr_ele_entry (p_element_link number)is
7974: select pee.effective_start_date,
7975: pee.effective_end_date,
7976: pee.effective_start_date -1
7977: from PAY_ELEMENT_ENTRIES_F pee
7978: where pee.assignment_id = p_assignment_id
7979: and p_session_date between pee.effective_start_date
7980: and pee.effective_end_date
7981: and pee.element_link_id = p_element_link

Line 7998: from PAY_ELEMENT_ENTRIES_F pee

7994:
7995: /* cursor to get the effective end date of the next element entry record */
7996: cursor csr_get_next_date (p_element_link number, p_date date)is
7997: select pee.effective_end_date
7998: from PAY_ELEMENT_ENTRIES_F pee
7999: where pee.assignment_id = p_assignment_id
8000: and p_date between pee.effective_start_date
8001: and pee.effective_end_date
8002: and pee.element_link_id = p_element_link

Line 8037: from PAY_ELEMENT_ENTRIES_F pee

8033:
8034: /* cursor to get the effective start date of the previous element entry record */
8035: cursor csr_get_prev_date (p_element_link number, p_date date)is
8036: select pee.effective_start_date
8037: from PAY_ELEMENT_ENTRIES_F pee
8038: where pee.assignment_id = p_assignment
8039: and pee.element_link_id = p_element_link
8040: and p_date between pee.effective_start_date
8041: and pee.effective_end_date

Line 9007: from PAY_ELEMENT_ENTRIES_F pef

9003: cursor csr_get_dates(p_element_link number, p_session_dt date) is
9004: select pef.effective_start_date,
9005: pef.effective_end_date,
9006: pef.effective_end_date + 1
9007: from PAY_ELEMENT_ENTRIES_F pef
9008: where pef.assignment_id = p_assignment_id
9009: and p_session_dt between pef.effective_start_date
9010: and pef.effective_end_date
9011: and pef.element_link_id = p_element_link

Line 9026: from PAY_ELEMENT_ENTRIES_F pee

9022:
9023: /* cursor to get the effective end date of the next element entry record */
9024: cursor csr_get_next_date (p_element_link number, p_date date)is
9025: select pee.effective_end_date
9026: from PAY_ELEMENT_ENTRIES_F pee
9027: where pee.assignment_id = p_assignment_id
9028: and p_date between pee.effective_start_date
9029: and pee.effective_end_date
9030: and pee.element_link_id = p_element_link