DBA Data[Home] [Help]

APPS.PAY_US_TAX_BALS_ADJ_PKG dependencies on PAY_INPUT_VALUES_F

Line 321: FROM PAY_INPUT_VALUES_F i

317:
318: CURSOR csr_inputs(v_element_type_id NUMBER,
319: v_input_name VARCHAR2) IS
320: SELECT i.input_value_id
321: FROM PAY_INPUT_VALUES_F i
322: WHERE i.element_type_id = v_element_type_id
323: and (i.business_group_id = p_bg_id
324: or i.business_group_id IS NULL
325: )

Line 858: PAY_INPUT_VALUES_F i

854: 'D', fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_adjustment_date)),
855: 'ND', To_Char(p_adjustment_date, 'Day')))
856: ) default_value
857: FROM HR_LOOKUPS hr,
858: PAY_INPUT_VALUES_F i
859: WHERE i.element_type_id = v_element_type_id
860: and i.mandatory_flag = 'Y'
861: and i.default_value = hr.lookup_code (+)
862: and i.lookup_type = hr.lookup_type (+)