APPS.PAY_US_EMP_DT_TAX_RULES dependencies on PAY_INPUT_VALUES_F

Line 61: from PAY_INPUT_VALUES_F piv,

57: cursor csr_tax_element is
58: select pet.element_type_id,
59: piv.input_value_id,
60: piv.name
61: from PAY_INPUT_VALUES_F piv,
62: PAY_ELEMENT_TYPES_F pet
63: where p_session_date between piv.effective_start_date
64: and piv.effective_end_date
65: and pet.element_type_id = piv.element_type_id

Line 346: from PAY_INPUT_VALUES_F piv,

342: cursor csr_wc_tax_element is
343: select pet.element_type_id,
344: piv.input_value_id,
345: piv.name
346: from PAY_INPUT_VALUES_F piv,
347: PAY_ELEMENT_TYPES_F pet
348: where p_session_date between piv.effective_start_date
349: and piv.effective_end_date
350: and pet.element_type_id = piv.element_type_id

Line 6055: PAY_INPUT_VALUES_F piv,

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
6059: and piv.name = 'Jurisdiction'

Line 6068: -- PAY_INPUT_VALUES_F and

6064: and p_assignment_id = peef.assignment_id
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:

Line 6984: from PAY_INPUT_VALUES_F piv,

6980: cursor csr_tax_element is
6981: select pet.element_type_id,
6982: piv.input_value_id,
6983: piv.name
6984: from PAY_INPUT_VALUES_F piv,
6985: PAY_ELEMENT_TYPES_F pet
6986: where p_session_date between piv.effective_start_date
6987: and piv.effective_end_date
6988: and pet.element_type_id = piv.element_type_id