DBA Data[Home] [Help]

APPS.PAY_ELEMENT_LINK_API dependencies on PAY_LINK_INPUT_VALUES_F

Line 1266: from pay_link_input_values_f pliv

1262: and effective_end_date;
1263:
1264: cursor csr_all_inputs_for_link is
1265: select link_input_value_id, object_version_number
1266: from pay_link_input_values_f pliv
1267: where element_link_id = p_element_link_id
1268: and p_effective_date between effective_start_date
1269: and effective_end_date;
1270:

Line 1276: from pay_link_input_values_f pliv

1272: select link_input_value_id
1273: ,object_version_number
1274: ,effective_start_date
1275: ,effective_end_date
1276: from pay_link_input_values_f pliv
1277: where element_link_id = p_element_link_id
1278: and effective_end_date >= p_effective_date
1279: and not exists
1280: (select null

Line 1281: from pay_link_input_values_f pliv2

1277: where element_link_id = p_element_link_id
1278: and effective_end_date >= p_effective_date
1279: and not exists
1280: (select null
1281: from pay_link_input_values_f pliv2
1282: where pliv2.element_link_id = pliv.element_link_id
1283: and pliv2.input_value_id = pliv.input_value_id
1284: and pliv2.effective_start_date > pliv.effective_start_date);
1285: