DBA Data[Home] [Help]

APPS.HR_RO_PERSON_VALIDATE dependencies on PAY_USER_COLUMN_INSTANCES_F

Line 49: FROM pay_user_column_instances_f pucif,

45: SELECT 1
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'

Line 68: pay_user_column_instances_f pucif1,

64: AND purf.business_group_id = p_business_group_id
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

Line 70: pay_user_column_instances_f pucif2,

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'
74: AND puc1.legislation_code = 'RO'