DBA Data[Home] [Help]

APPS.PER_NO_SICKLEAVEMONITORING dependencies on PAY_USER_COLUMN_INSTANCES_F

Line 15: FROM pay_user_column_instances_f ucf

11:
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'

Line 78: FROM pay_user_column_instances_f ucf

74: ,max (decode (uc.user_column_name
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'