APPS.PAY_STATUS_RULES_PKG dependencies on PAY_INPUT_VALUES_F

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 373: pay_input_values_f IV

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
377: and translate(upper(iv_tl.name),' ','_') in

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

Line 384: pay_input_values_f IV,

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
388: and userenv('LANG') = iv_tl.language

Line 401: -- from pay_input_values_f IV

397: -- Cursors rewritten for bug 436741
398: -- and exists ( -- input value with matching data type
399: --
400: -- select 1
401: -- from pay_input_values_f IV
402: -- where iv.element_type_id = p_element_type_id
403: -- and translate (upper(iv.name),' ','_')
404: -- = translate (upper(fdi.item_name),' ','_')
405: -- and ((fdi.data_type = 'D' and iv.uom = 'D')