APPS.PAY_STATUS_RULES_PKG dependencies on PAY_INPUT_VALUES_F_TL

Line 372: from pay_input_values_f_tl IV_TL,

368: -- and the element
369: --
370: cursor csr_number_of_input_values is
371: select count( distinct iv.name)
372: from pay_input_values_f_tl IV_TL,
373: pay_input_values_f IV
374: where iv_tl.input_value_id = iv.input_value_id
375: and iv.element_type_id = p_element_type_id
376: and userenv('LANG') = iv_tl.language

Line 383: from pay_input_values_f_tl IV_TL,

379: where formula_id = p_formula_id);
380:
381: cursor csr_matching_data_types is
382: select count(distinct fdi.ITEM_NAME)
383: from pay_input_values_f_tl IV_TL,
384: pay_input_values_f IV,
385: ff_fdi_usages_f FDI
386: where iv_tl.input_value_id = iv.input_value_id
387: and fdi.formula_id = p_formula_id