eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_UPLOAD_USER_TABLE dependencies on PAY_USER_ROWS_F

Line 21: from pay_user_rows_f pur,

17: select pur.rowid ROW_ID,
18: pur.user_row_id,
19: pur.display_sequence,
20: pur.effective_start_date
21: from pay_user_rows_f pur,
22: pay_user_tables put
23: where put.user_table_name='RO_LOCALITY_DETAILS'
24: and put.legislation_code =g_legislation_code
25: and put.business_group_id is null

Line 44: select nvl(max(DISPLAY_SEQUENCE),0)+1 into p_display_sequence from pay_user_rows_f pur,

40: fetch csr_row_id into l_rec;
41: if csr_row_id%NOTFOUND then
42: -- creation
43: hr_utility.trace('Creating new record');
44: select nvl(max(DISPLAY_SEQUENCE),0)+1 into p_display_sequence from pay_user_rows_f pur,
45: pay_user_tables put
46: where put.user_table_name=p_user_table_name
47: and pur.user_table_id=put.user_table_id;
48:

Line 49: insert into pay_user_rows_f(

45: pay_user_tables put
46: where put.user_table_name=p_user_table_name
47: and pur.user_table_id=put.user_table_id;
48:
49: insert into pay_user_rows_f(
50: USER_ROW_ID,
51: EFFECTIVE_START_DATE,
52: EFFECTIVE_END_DATE,
53: BUSINESS_GROUP_ID,

Line 92: update pay_user_rows_f pur

88: p_display_sequence := l_rec.display_sequence;
89: if l_rec.effective_start_date = p_effective_date then
90: -- correction mode
91: hr_utility.trace('Correction mode');
92: update pay_user_rows_f pur
93: set pur.row_low_range_or_name=p_row_low_range_or_name
94: where pur.rowid=l_rec.row_id;
95:
96: else

Line 101: insert into pay_user_rows_f(

97: -- update mode
98: hr_utility.trace('Update mode');
99: l_user_row_id := l_rec.user_row_id;
100: --create new entry
101: insert into pay_user_rows_f(
102: USER_ROW_ID,
103: EFFECTIVE_START_DATE,
104: EFFECTIVE_END_DATE,
105: BUSINESS_GROUP_ID,

Line 132: from pay_user_rows_f pur

128: 1,
129: -1,
130: 1,
131: sysdate
132: from pay_user_rows_f pur
133: where pur.rowid = l_rec.row_id;
134: --end date old entry
135: update pay_user_rows_f pur
136: set pur.effective_end_date=p_effective_date - 1

Line 135: update pay_user_rows_f pur

131: sysdate
132: from pay_user_rows_f pur
133: where pur.rowid = l_rec.row_id;
134: --end date old entry
135: update pay_user_rows_f pur
136: set pur.effective_end_date=p_effective_date - 1
137: where pur.rowid=l_rec.row_id
138: and pur.effective_start_date <> p_effective_date;
139:

Line 161: pay_user_rows_f pur,

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
165: and put.legislation_code=g_legislation_code

Line 219: from pay_user_rows_f pur,

215: 1,
216: -1,
217: 1,
218: sysdate
219: from pay_user_rows_f pur,
220: pay_user_columns puc,
221: pay_user_tables put
222: where put.user_table_name=p_user_table_name
223: and put.legislation_code=g_legislation_code

Line 725: pay_user_rows_f purf,

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,
729: pay_user_column_instances_f pucif2,

Line 726: pay_user_rows_f purf1,

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,
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

Line 728: pay_user_rows_f purf2,

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
732: and pucif.user_column_id = p_user_column_id_loc

Line 754: ,pay_user_rows_f purf3

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'
757: and puc3.legislation_code = 'RO'
758: AND puc3.user_table_id = p_user_table_id