DBA Data[Home] [Help]

APPS.HR_RO_PERSON_VALIDATE dependencies on PAY_USER_COLUMNS

Line 50: pay_user_columns puc,

46: FROM dual
47: WHERE p_locality IN
48: (SELECT pucif.value
49: FROM pay_user_column_instances_f pucif,
50: pay_user_columns puc,
51: pay_user_tables put,
52: pay_user_rows_f purf
53: WHERE puc.user_column_name = 'LOCALITY'
54: AND puc.legislation_code = 'RO'

Line 69: pay_user_columns puc1,

65: AND purf.row_low_range_or_name IN
66: (SELECT purf1.ROW_LOW_RANGE_OR_NAME
67: FROM pay_user_rows_f purf1,
68: pay_user_column_instances_f pucif1,
69: pay_user_columns puc1,
70: pay_user_column_instances_f pucif2,
71: pay_user_columns puc2,
72: pay_user_rows_f purf2
73: WHERE puc1.user_column_name = 'COUNTY CODE'

Line 71: pay_user_columns puc2,

67: FROM pay_user_rows_f purf1,
68: pay_user_column_instances_f pucif1,
69: pay_user_columns puc1,
70: pay_user_column_instances_f pucif2,
71: pay_user_columns puc2,
72: pay_user_rows_f purf2
73: WHERE puc1.user_column_name = 'COUNTY CODE'
74: AND puc1.legislation_code = 'RO'
75: AND puc1.business_group_id IS NULL