DBA Data[Home] [Help]

APPS.PAY_STANDARD_CHECK dependencies on PAY_INPUT_VALUES_F

Line 7: from pay_input_values_f piv,

3:
4: cursor csr_relevant_total_chk(l_batch_id in number,
5: l_meaning in varchar2) is
6: select 'X'
7: from pay_input_values_f piv,
8: hr_lookups hrl,
9: pay_batch_lines pbl
10:
11: where l_meaning = piv.name -- restrict to input value parameter

Line 81: from pay_input_values_f piv

77: -- pay_batch_lines columns
78:
79: cursor csr_ordered_input_values(l_element_type_id in number) is
80: select piv.name
81: from pay_input_values_f piv
82: where piv.element_type_id = l_element_type_id
83: and sysdate between piv.effective_start_date and piv.effective_end_date
84: order by piv.display_sequence, piv.name;
85: