DBA Data[Home] [Help]

APPS.PER_NO_SICKLEAVEMONITORING dependencies on PAY_USER_COLUMNS

Line 16: ,pay_user_columns uc

12: CURSOR csr_default_followup_days(c_date IN DATE DEFAULT SYSDATE
13: ,c_followup IN NUMBER) IS
14: SELECT NVL(to_number(ucf.value),0)
15: FROM pay_user_column_instances_f ucf
16: ,pay_user_columns uc
17: ,pay_user_rows_f ur
18: ,pay_user_tables ut
19: WHERE ut.legislation_code = 'NO'
20: AND ut.user_table_name = 'Sick Leave Monitoring'

Line 79: ,pay_user_columns uc

75: ,'Action Message'
76: ,ucf.value
77: ,0)) message
78: FROM pay_user_column_instances_f ucf
79: ,pay_user_columns uc
80: ,pay_user_rows_f ur
81: ,pay_user_tables ut
82: WHERE ut.legislation_code = 'NO'
83: AND ut.user_table_name = 'Sick Leave Monitoring'