APPS.HR_DE_GENERAL dependencies on PAY_USER_COLUMN_INSTANCES_F

Line 8: from pay_user_column_instances_f uci, pay_user_rows_f ur,

4: FUNCTION get_three_digit_code(p_legislation_code in varchar2)
5: RETURN varchar2 is
6: cursor csr_three_digit_code (l_legislation_code in varchar2) is
7: select uci.value
8: from pay_user_column_instances_f uci, pay_user_rows_f ur,
9: pay_user_tables ut
10: where ut.user_table_name = 'HR_DE_COUNTRY_CODE'
11: and ur.row_low_range_or_name = l_legislation_code
12: and ur.user_table_id = ut.user_table_id

Line 15: l_three_digit_code pay_user_column_instances_f.value%type;

11: and ur.row_low_range_or_name = l_legislation_code
12: and ur.user_table_id = ut.user_table_id
13: and ur.user_row_id = uci.user_row_id;
14:
15: l_three_digit_code pay_user_column_instances_f.value%type;
16: BEGIN
17: open csr_three_digit_code(p_legislation_code);
18: fetch csr_three_digit_code into l_three_digit_code;
19: if csr_three_digit_code%found then

Line 337: FROM pay_user_column_instances_f uci

333: ,p_user_table_id NUMBER
334: ,p_user_row_id NUMBER
335: ,p_user_column_name VARCHAR2) IS
336: SELECT value
337: FROM pay_user_column_instances_f uci
338: ,pay_user_columns uc
339: WHERE uc.user_table_id = p_user_table_id
340: AND uc.user_column_name = p_user_column_name
341: AND uci.user_row_id = p_user_row_id

Line 346: l_uci_value pay_user_column_instances_f.value%TYPE := NULL;

342: AND uci.user_column_id = uc.user_column_id
343: AND p_effective_date BETWEEN uci.effective_start_date
344: AND uci.effective_end_date;
345: --
346: l_uci_value pay_user_column_instances_f.value%TYPE := NULL;
347: BEGIN
348: --
349: OPEN c_uci_value
350: (p_effective_date => p_effective_date