APPS.PY_NO_TAX_CARD dependencies on PAY_ELEMENT_TYPES_F

Line 80: l_element_type_id pay_element_types_f.element_type_id%TYPE;

76: l_element_entry_id NUMBER(15);
77: l_entry_value4 pay_element_entry_values_f.screen_entry_value%TYPE;
78: l_ovn NUMBER(9);
79: l_element_link_id pay_element_links_f.element_link_id%TYPE;
80: l_element_type_id pay_element_types_f.element_type_id%TYPE;
81: l_input_value_id1 pay_input_values_f.input_value_id%TYPE;
82: l_input_value_id2 pay_input_values_f.input_value_id%TYPE;
83: l_input_value_id3 pay_input_values_f.input_value_id%TYPE;
84: l_input_value_id4 pay_input_values_f.input_value_id%TYPE;

Line 104: pay_element_types_f et,

100: MIN(DECODE(iv.name, 'Tax Free Threshold', iv.input_value_id, null)) iv7,
101: MIN(DECODE(iv.name, 'Registration Date', iv.input_value_id, null)) iv8,
102: MIN(DECODE(iv.name, 'Date Returned', iv.input_value_id, null)) iv9
103: FROM
104: pay_element_types_f et,
105: pay_input_values_f iv
106: WHERE et.element_name = 'Tax Card'
107: AND et.legislation_code = 'NO'
108: AND et.business_group_id is null