DBA Data[Home] [Help]

APPS.PAY_ELEMENT_LINK_API dependencies on PAY_LINK_INPUT_VALUES_F

Line 1273: from pay_link_input_values_f pliv

1269: and effective_end_date;
1270:
1271: cursor csr_all_inputs_for_link is
1272: select link_input_value_id, object_version_number
1273: from pay_link_input_values_f pliv
1274: where element_link_id = p_element_link_id
1275: and p_effective_date between effective_start_date
1276: and effective_end_date;
1277:

Line 1283: from pay_link_input_values_f pliv

1279: select link_input_value_id
1280: ,object_version_number
1281: ,effective_start_date
1282: ,effective_end_date
1283: from pay_link_input_values_f pliv
1284: where element_link_id = p_element_link_id
1285: and effective_end_date >= p_effective_date
1286: and not exists
1287: (select null

Line 1288: from pay_link_input_values_f pliv2

1284: where element_link_id = p_element_link_id
1285: and effective_end_date >= p_effective_date
1286: and not exists
1287: (select null
1288: from pay_link_input_values_f pliv2
1289: where pliv2.element_link_id = pliv.element_link_id
1290: and pliv2.input_value_id = pliv.input_value_id
1291: and pliv2.effective_start_date > pliv.effective_start_date);
1292: