APPS.PER_UPLOAD_USER_TABLE dependencies on PAY_USER_COLUMN_INSTANCES_F

Line 160: from pay_user_column_instances_f puci,

156: select puci.rowid ROW_ID,
157: puci.user_column_instance_id,
158: puci.effective_start_date,
159: puci.value
160: from pay_user_column_instances_f puci,
161: pay_user_rows_f pur,
162: pay_user_columns puc,
163: pay_user_tables put
164: where put.user_table_name=p_user_table_name

Line 190: insert into pay_user_column_instances_f(

186: fetch csr_instance_id into l_rec;
187: if csr_instance_id%NOTFOUND then
188: -- create new record
189: hr_utility.trace('Creating new record');
190: insert into pay_user_column_instances_f(
191: USER_COLUMN_INSTANCE_ID,
192: EFFECTIVE_START_DATE,
193: EFFECTIVE_END_DATE,
194: USER_ROW_ID,

Line 242: update pay_user_column_instances_f puci

238: hr_utility.trace('Updaing record');
239: if l_rec.effective_start_date = p_effective_date then
240: -- correction mode
241: hr_utility.trace('Correction mode');
242: update pay_user_column_instances_f puci
243: set puci.value=p_value
244: where puci.rowid=l_rec.row_id;
245:
246: else

Line 250: insert into pay_user_column_instances_f(

246: else
247: -- update mode
248: -- entering new record
249: hr_utility.trace('Update mode');
250: insert into pay_user_column_instances_f(
251: USER_COLUMN_INSTANCE_ID,
252: EFFECTIVE_START_DATE,
253: EFFECTIVE_END_DATE,
254: USER_ROW_ID,

Line 279: from pay_user_column_instances_f puci

275: 1,
276: -1,
277: 1,
278: sysdate
279: from pay_user_column_instances_f puci
280: where puci.rowid=l_rec.row_id;
281: -- end dating older entry
282: update pay_user_column_instances_f puci
283: set puci.effective_end_date = p_effective_date - 1

Line 282: update pay_user_column_instances_f puci

278: sysdate
279: from pay_user_column_instances_f puci
280: where puci.rowid=l_rec.row_id;
281: -- end dating older entry
282: update pay_user_column_instances_f puci
283: set puci.effective_end_date = p_effective_date - 1
284: where puci.rowid=l_rec.row_id
285: and puci.effective_start_date <> p_effective_date;
286: end if;

Line 724: from pay_user_column_instances_f pucif,

720: l_eff_date DATE := to_date('0001-01-01','RRRR-MM-DD');
721: cursor csr_get_locality(p_user_table_id NUMBER,p_user_column_id_loc NUMBER,p_user_column_id_con NUMBER,p_user_column_id_pin NUMBER)
722: IS
723: (select distinct pucif.VALUE ,pucif2.VALUE, hr.meaning
724: from pay_user_column_instances_f pucif,
725: pay_user_rows_f purf,
726: pay_user_rows_f purf1,
727: pay_user_column_instances_f pucif1,
728: pay_user_rows_f purf2,

Line 727: pay_user_column_instances_f pucif1,

723: (select distinct pucif.VALUE ,pucif2.VALUE, hr.meaning
724: from pay_user_column_instances_f pucif,
725: pay_user_rows_f purf,
726: pay_user_rows_f purf1,
727: pay_user_column_instances_f pucif1,
728: pay_user_rows_f purf2,
729: pay_user_column_instances_f pucif2,
730: (select lookup_code,meaning from hr_lookups where lookup_type = 'RO_PER_COUNTIES' and enabled_flag='Y') hr
731: where purf.user_table_id = p_user_table_id

Line 729: pay_user_column_instances_f pucif2,

725: pay_user_rows_f purf,
726: pay_user_rows_f purf1,
727: pay_user_column_instances_f pucif1,
728: pay_user_rows_f purf2,
729: pay_user_column_instances_f pucif2,
730: (select lookup_code,meaning from hr_lookups where lookup_type = 'RO_PER_COUNTIES' and enabled_flag='Y') hr
731: where purf.user_table_id = p_user_table_id
732: and pucif.user_column_id = p_user_column_id_loc
733: and pucif.user_row_id = purf.user_row_id

Line 752: FROM pay_user_column_instances_f pucif3

748: and purf.row_low_range_or_name = purf2.row_low_range_or_name
749: and purf1.row_low_range_or_name = purf2.row_low_range_or_name
750: and purf.row_low_range_or_name in
751: (SELECT purf3.row_low_range_or_name
752: FROM pay_user_column_instances_f pucif3
753: ,pay_user_columns puc3
754: ,pay_user_rows_f purf3
755: WHERE purf3.user_table_id = p_user_table_id
756: AND puc3.user_column_name = 'LEVEL'