APPS.HR_FR_SEED_PKG dependencies on PAY_USER_TABLES

Line 21: PAY_USER_TABLES_PKG.INSERT_ROW

17:
18: v_table_rowid := NULL;
19: v_user_table_id := NULL;
20:
21: PAY_USER_TABLES_PKG.INSERT_ROW
22: (P_ROWID => v_table_rowid,
23: P_USER_TABLE_ID => v_user_table_id,
24: P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID_ITD,
25: P_LEGISLATION_CODE => P_LEGISLATION_CODE_ITD,

Line 51: FROM pay_user_tables

47: IS
48: -- ensures table not already created for business group
49: CURSOR user_table_name_csr IS
50: SELECT user_table_name
51: FROM pay_user_tables
52: WHERE business_group_id = P_BUSINESS_GROUP_ID_CT
53: AND user_table_name = P_USER_TABLE_NAME_CT;
54:
55: v_legislation_code per_business_groups.legislation_code%TYPE;

Line 111: FROM pay_user_tables

107: SELECT user_column_id
108: FROM pay_user_columns
109: WHERE user_table_id =
110: (SELECT user_table_id
111: FROM pay_user_tables
112: WHERE business_group_id = P_BUSINESS_GROUP_ID_CC
113: AND user_table_name = P_USER_TABLE_NAME_CC)
114: AND user_column_name = P_USER_COLUMN_NAME_CC;
115:

Line 122: FROM pay_user_tables

118: hr_utility.trace ('PROCEDURE create column entered.');
119:
120: SELECT user_table_id
121: INTO v_user_table_id
122: FROM pay_user_tables
123: WHERE user_table_name = P_USER_TABLE_NAME_CC
124: AND business_group_id = P_BUSINESS_GROUP_ID_CC;
125: --
126: SELECT legislation_code

Line 181: FROM pay_user_tables

177: CURSOR user_row_id_csr IS
178: SELECT user_row_id
179: FROM pay_user_rows_f
180: WHERE user_table_id = (SELECT user_table_id
181: FROM pay_user_tables
182: WHERE user_table_name = P_USER_TABLE_NAME_CR
183: AND business_group_id = P_BUSINESS_GROUP_ID_CR)
184: AND P_ROW_LOW_RANGE_OR_NAME_CR = row_low_range_or_name;
185:

Line 202: FROM pay_user_tables

198: hr_utility.trace ('PROCEDURE create row entered.');
199: --
200: SELECT user_table_id, legislation_code
201: INTO v_user_table_id, v_legislation_code
202: FROM pay_user_tables
203: WHERE user_table_name = P_USER_TABLE_NAME_CR
204: AND business_group_id = P_BUSINESS_GROUP_ID_CR;
205: --
206: OPEN user_row_id_csr;

Line 3061: , pay_user_tables t

3057: ,p_where_clause => 'from hr_soft_coding_keyflex scl
3058: , pay_user_column_instances_f i
3059: , pay_user_columns c
3060: , pay_user_rows_f r
3061: , pay_user_tables t
3062: , per_all_people_f p
3063: , per_all_assignments_f a
3064: where a.soft_coding_keyflex_id = scl.soft_coding_keyflex_id(+)
3065: and (p.effective_start_date,a.effective_start_date) =