DBA Data[Home] [Help]

APPS.PAY_DYNDBI_CHANGES_PKG dependencies on PAY_INPUT_VALUES_F

Line 72: from pay_input_values_f iv

68: cursor csr_input_values
69: (p_element_type_id in number
70: ) is
71: select iv.input_value_id
72: from pay_input_values_f iv
73: where iv.element_type_id = p_element_type_id
74: and iv.generate_db_items_flag = 'Y'
75: and iv.effective_end_date =
76: (

Line 78: from pay_input_values_f iv1

74: and iv.generate_db_items_flag = 'Y'
75: and iv.effective_end_date =
76: (
77: select max(iv1.effective_end_date)
78: from pay_input_values_f iv1
79: where iv1.input_value_id = iv.input_value_id
80: )
81: ;
82: begin

Line 128: from pay_input_values_f iv

124: ,p_languages in dbms_sql.varchar2s
125: ) is
126: cursor csr_input_value(p_input_value_id in number) is
127: select null
128: from pay_input_values_f iv
129: where iv.input_value_id = p_input_value_id
130: and iv.generate_db_items_flag = 'Y'
131: and iv.effective_end_date =
132: (

Line 134: from pay_input_values_f iv1

130: and iv.generate_db_items_flag = 'Y'
131: and iv.effective_end_date =
132: (
133: select max(iv1.effective_end_date)
134: from pay_input_values_f iv1
135: where iv1.input_value_id = p_input_value_id
136: )
137: ;
138: --