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 6131: PAY_INPUT_VALUES_F piv,

6127: select peev.screen_entry_value jurisdiction,
6128: peef.effective_start_date start_date
6129: from PAY_ELEMENT_ENTRY_VALUES_F peev,
6130: PAY_ELEMENT_ENTRIES_F peef,
6131: PAY_INPUT_VALUES_F piv,
6132: PAY_ELEMENT_TYPES_F pet
6133: where pet.element_name = 'VERTEX'
6134: and pet.element_type_id = piv.element_type_id
6135: and piv.name = 'Jurisdiction'

Line 6144: -- PAY_INPUT_VALUES_F and

6140: and p_assignment_id = peef.assignment_id
6141: and peef.effective_start_date = p_effective_start_date
6142: and peef.effective_end_date = p_effective_end_date
6143: and peef.effective_start_date between pet.effective_start_date and pet.effective_end_date; -- Bug 3354060 added to remove MJC between
6144: -- PAY_INPUT_VALUES_F and
6145: -- PAY_ELEMENT_ENTRIES_F
6146:
6147: begin
6148:

Line 7060: from PAY_INPUT_VALUES_F piv,

7056: cursor csr_tax_element is
7057: select pet.element_type_id,
7058: piv.input_value_id,
7059: piv.name
7060: from PAY_INPUT_VALUES_F piv,
7061: PAY_ELEMENT_TYPES_F pet
7062: where p_session_date between piv.effective_start_date
7063: and piv.effective_end_date
7064: and pet.element_type_id = piv.element_type_id