APPS.PAY_STANDARD_CHECK dependencies on HR_LOOKUPS

Line 8: hr_lookups hrl,

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
12: and piv.name = hrl.meaning -- join piv-hrl on name of input value

Line 94: -- for the (translated) meanings from hr_lookups

90: -- for the dynamic sql statements used in totalling
91: l_sql_stat varchar2(1000);
92: -- for a single batch line
93: l_batch_line pay_batch_lines%rowtype;
94: -- for the (translated) meanings from hr_lookups
95: l_meaning hr_lookups.meaning%TYPE := null;
96: -- for the number of lines in a batch
97: l_n_lines number := 0;
98: -- for the column of pay_batch_lines holding the values to be summed

Line 95: l_meaning hr_lookups.meaning%TYPE := null;

91: l_sql_stat varchar2(1000);
92: -- for a single batch line
93: l_batch_line pay_batch_lines%rowtype;
94: -- for the (translated) meanings from hr_lookups
95: l_meaning hr_lookups.meaning%TYPE := null;
96: -- for the number of lines in a batch
97: l_n_lines number := 0;
98: -- for the column of pay_batch_lines holding the values to be summed
99: l_value_number number;

Line 117: from hr_lookups hlk

113: --
114: -- Control code exists (as checked in calling routine) so we can select the meaning
115: --
116: select hlk.meaning into l_meaning
117: from hr_lookups hlk
118: where hlk.lookup_type = 'CONTROL_TYPE'
119: and hlk.lookup_code = p_control_type;
120:
121: -- Deal with special values of p_control_type