DBA Data[Home] [Help]

APPS.PAY_NO_ABS_VALIDATION dependencies on PAY_USER_COLUMNS

Line 15: ,pay_user_columns uc

11: CURSOR csr_default_rule_value(c_rule IN VARCHAR2
12: ,c_date IN DATE) IS
13: SELECT to_number(NVL(ucf.value,0)) DefaultValue
14: FROM pay_user_column_instances_f ucf
15: ,pay_user_columns uc
16: ,pay_user_rows_f ur
17: ,pay_user_tables ut
18: WHERE ut.legislation_code = 'NO'
19: AND ut.user_table_name = 'Self Certification Rules'

Line 66: ,pay_user_columns uc

62: ,'Maximum'
63: ,ucf.value
64: ,0)) MaxValue
65: FROM pay_user_column_instances_f ucf
66: ,pay_user_columns uc
67: ,pay_user_rows_f ur
68: ,pay_user_tables ut
69: WHERE ut.legislation_code = 'NO'
70: AND ut.user_table_name = 'Self Certification Rules'