DBA Data[Home] [Help]

APPS.HR_DE_GENERAL dependencies on PAY_USER_ROWS_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