DBA Data[Home] [Help]

APPS.PAY_US_TAX_BALS_ADJ_API dependencies on PAY_INPUT_VALUES_F

Line 236: FROM pay_input_values_f i

232:
233: CURSOR csr_inputs(v_element_type_id IN NUMBER,
234: v_input_name IN VARCHAR2) IS
235: SELECT i.input_value_id
236: FROM pay_input_values_f i
237: WHERE i.element_type_id = v_element_type_id
238: AND (i.business_group_id = p_bg_id
239: OR i.business_group_id IS NULL)
240: AND i.name = v_input_name

Line 1294: PAY_INPUT_VALUES_F i

1290: 'D', fnd_date.date_to_displaydate(fnd_date.canonical_to_date(p_adjustment_date)),
1291: 'ND', To_Char(p_adjustment_date, 'Day')))
1292: ) default_value
1293: FROM HR_LOOKUPS hr,
1294: PAY_INPUT_VALUES_F i
1295: WHERE i.element_type_id = v_element_type_id
1296: AND i.mandatory_flag = 'Y'
1297: AND i.default_value = hr.lookup_code (+)
1298: AND i.lookup_type = hr.lookup_type (+)