APPS.PAY_GB_WORKING_TAX_CREDIT dependencies on PAY_INPUT_VALUES_F

Line 59: l_daily_amt_iv_id pay_input_values_f.input_value_id%TYPE;

55: return number is
56:
57: l_function_name VARCHAR2(17) := 'calculate_payable';
58:
59: l_daily_amt_iv_id pay_input_values_f.input_value_id%TYPE;
60:
61: l_calc_start_date DATE;
62: l_calc_end_date DATE;
63:

Line 74: from pay_input_values_f piv,

70: /* Get input value id for Daily Amount */
71: -- BUG 3221422 Changed Query for improving performance
72: cursor csr_daily_amt_iv_id is
73: select piv.input_value_id
74: from pay_input_values_f piv,
75: pay_element_types_f petf
76: where petf.element_type_id = piv.element_type_id
77: and petf.element_name = 'Working Tax Credit'
78: and piv.name = 'Daily Amount'