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.HR_ENTRY dependencies on PAY_ELEMENT_ENTRIES_F

Line 261: (select /+ INDEX(ee, pay_element_entries_f_n51) / null

257: select 'Y'
258: into v_overlap_occurred
259: from sys.dual
260: where exists
261: (select /*+ INDEX(ee, pay_element_entries_f_n51) */ null
262: from pay_element_entries_f ee
263: where ee.entry_type = 'E'
264: and ee.element_entry_id <> nvl(p_element_entry_id,0)
265: and ee.assignment_id = p_assignment_id

Line 262: from pay_element_entries_f ee

258: into v_overlap_occurred
259: from sys.dual
260: where exists
261: (select /*+ INDEX(ee, pay_element_entries_f_n51) */ null
262: from pay_element_entries_f ee
263: where ee.entry_type = 'E'
264: and ee.element_entry_id <> nvl(p_element_entry_id,0)
265: and ee.assignment_id = p_assignment_id
266: and ee.element_link_id = p_element_link_id

Line 443: -- PAY_ELEMENT_ENTRIES_F base table.

439: -- hr_entry.generate_entry_id
440: --
441: -- DESCRIPTION
442: -- Generates then next sequence value for inserting an element entry into the
443: -- PAY_ELEMENT_ENTRIES_F base table.
444: --
445: FUNCTION generate_entry_id return number is
446: v_element_entry_id number;
447: --

Line 1762: from pay_element_entries_f e

1758: end if;
1759: begin
1760: select e.effective_end_date
1761: into v_current_effective_end_date
1762: from pay_element_entries_f e
1763: where e.element_entry_id = p_element_entry_id
1764: and p_session_date
1765: between e.effective_start_date
1766: and e.effective_end_date;

Line 1782: select /+ INDEX(pee, pay_element_entries_f_n51) /

1778: hr_utility.set_location('hr_entry.recurring_entry_end_date', 1);
1779: end if;
1780: begin
1781: -- INDEX hint added following NHS project recommendation
1782: select /*+ INDEX(pee, pay_element_entries_f_n51) */
1783: nvl(min(pee.effective_start_date) - 1, hr_general.end_of_time)
1784: into v_future_recurring_end_date
1785: from pay_element_entries_f pee
1786: where pee.entry_type = 'E'

Line 1785: from pay_element_entries_f pee

1781: -- INDEX hint added following NHS project recommendation
1782: select /*+ INDEX(pee, pay_element_entries_f_n51) */
1783: nvl(min(pee.effective_start_date) - 1, hr_general.end_of_time)
1784: into v_future_recurring_end_date
1785: from pay_element_entries_f pee
1786: where pee.entry_type = 'E'
1787: and pee.assignment_id = p_assignment_id
1788: and pee.element_link_id = p_element_link_id
1789: and pee.element_entry_id <> nvl(p_element_entry_id,0)

Line 2798: from pay_element_entries_f

2794: v_element_effective_start_date date;
2795: --
2796: cursor c_element_start_date is
2797: select effective_start_date
2798: from pay_element_entries_f
2799: where element_entry_id = p_target_entry_id;
2800: --
2801: cursor c_cwk_element_check is
2802: -- Should not allow these PTO elements for CWKs

Line 3040: ,p_base_table_name => 'pay_element_entries_f'

3036: if p_usage = 'INSERT' then
3037: dt_api.validate_dt_mode(
3038: p_effective_date => p_session_date --*
3039: ,p_datetrack_mode => 'INSERT' --*
3040: ,p_base_table_name => 'pay_element_entries_f'
3041: ,p_base_key_column => 'element_entry_id'
3042: ,p_base_key_value => p_element_entry_id --*
3043: ,p_parent_table_name1 => 'per_all_assignments_f'
3044: ,p_parent_key_column1 => 'assignment_id'

Line 3139: INDEX(pee, pay_element_entries_f_n51 */ 1

3135: into v_error_flag
3136: from sys.dual
3137: where exists
3138: (select /*+ FIRST_ROWS(1)
3139: INDEX(pee, pay_element_entries_f_n51 */ 1
3140: from pay_element_entries_f pee
3141: where pee.entry_type = p_entry_type
3142: and pee.assignment_id = p_assignment_id
3143: and pee.element_link_id = p_element_link_id

Line 3140: from pay_element_entries_f pee

3136: from sys.dual
3137: where exists
3138: (select /*+ FIRST_ROWS(1)
3139: INDEX(pee, pay_element_entries_f_n51 */ 1
3140: from pay_element_entries_f pee
3141: where pee.entry_type = p_entry_type
3142: and pee.assignment_id = p_assignment_id
3143: and pee.element_link_id = p_element_link_id
3144: and pee.effective_start_date >= v_period_start_date

Line 3177: INDEX(pee, pay_element_entries_f_n51 */ 1

3173: into v_error_flag
3174: from sys.dual
3175: where exists
3176: (select /*+ FIRST_ROWS(1)
3177: INDEX(pee, pay_element_entries_f_n51 */ 1
3178: from pay_element_entries_f pee
3179: where pee.target_entry_id = p_element_entry_id
3180: and pee.element_link_id = p_element_link_id
3181: and pee.assignment_id = p_assignment_id

Line 3178: from pay_element_entries_f pee

3174: from sys.dual
3175: where exists
3176: (select /*+ FIRST_ROWS(1)
3177: INDEX(pee, pay_element_entries_f_n51 */ 1
3178: from pay_element_entries_f pee
3179: where pee.target_entry_id = p_element_entry_id
3180: and pee.element_link_id = p_element_link_id
3181: and pee.assignment_id = p_assignment_id
3182: and pee.effective_start_date <= v_validation_end_date

Line 3213: INDEX(pee, pay_element_entries_f_n51 */ 1

3209: into v_error_flag
3210: from sys.dual
3211: where exists
3212: (select /*+ FIRST_ROWS(1)
3213: INDEX(pee, pay_element_entries_f_n51 */ 1
3214: from pay_element_entries_f pee
3215: where pee.entry_type = 'S'
3216: and pee.assignment_id = p_assignment_id
3217: and pee.element_link_id = p_element_link_id

Line 3214: from pay_element_entries_f pee

3210: from sys.dual
3211: where exists
3212: (select /*+ FIRST_ROWS(1)
3213: INDEX(pee, pay_element_entries_f_n51 */ 1
3214: from pay_element_entries_f pee
3215: where pee.entry_type = 'S'
3216: and pee.assignment_id = p_assignment_id
3217: and pee.element_link_id = p_element_link_id
3218: and pee.effective_start_date >= v_period_start_date

Line 3243: INDEX(pee, pay_element_entries_f_n51 */ 1

3239: into v_error_flag
3240: from sys.dual
3241: where exists
3242: (select /*+ FIRST_ROWS(1)
3243: INDEX(pee, pay_element_entries_f_n51 */ 1
3244: from pay_element_entries_f pee
3245: where pee.entry_type in ('R','A')
3246: and pee.assignment_id = p_assignment_id
3247: and pee.element_link_id = p_element_link_id

Line 3244: from pay_element_entries_f pee

3240: from sys.dual
3241: where exists
3242: (select /*+ FIRST_ROWS(1)
3243: INDEX(pee, pay_element_entries_f_n51 */ 1
3244: from pay_element_entries_f pee
3245: where pee.entry_type in ('R','A')
3246: and pee.assignment_id = p_assignment_id
3247: and pee.element_link_id = p_element_link_id
3248: and pee.effective_start_date >= v_period_start_date

Line 3289: from pay_element_entries_f pee

3285: into v_error_flag
3286: from sys.dual
3287: where not exists
3288: (select /*+ FIRST_ROWS(1) */ 1
3289: from pay_element_entries_f pee
3290: where pee.assignment_id = p_assignment_id
3291: and pee.element_entry_id = p_target_entry_id
3292: having min(pee.effective_start_date) <=
3293: v_validation_start_date

Line 3318: INDEX(pee, pay_element_entries_f_n51 */ 1

3314: into v_error_flag
3315: from sys.dual
3316: where exists
3317: (select /*+ FIRST_ROWS(1)
3318: INDEX(pee, pay_element_entries_f_n51 */ 1
3319: from pay_element_entries_f pee
3320: where pee.entry_type = 'S'
3321: and pee.assignment_id = p_assignment_id
3322: and pee.element_link_id = p_element_link_id

Line 3319: from pay_element_entries_f pee

3315: from sys.dual
3316: where exists
3317: (select /*+ FIRST_ROWS(1)
3318: INDEX(pee, pay_element_entries_f_n51 */ 1
3319: from pay_element_entries_f pee
3320: where pee.entry_type = 'S'
3321: and pee.assignment_id = p_assignment_id
3322: and pee.element_link_id = p_element_link_id
3323: and pee.effective_start_date >= v_period_start_date

Line 3348: from pay_element_entries_f pee

3344: into v_error_flag
3345: from sys.dual
3346: where exists
3347: (select /*+ FIRST_ROWS(1) */ 1
3348: from pay_element_entries_f pee
3349: where pee.entry_type in ('R','A')
3350: and pee.assignment_id = p_assignment_id
3351: and pee.target_entry_id = p_target_entry_id
3352: and pee.effective_start_date >= v_period_start_date

Line 3402: -- PAY_ELEMENT_ENTRIES_F (If an abscence, or DT functions are being used).

3398: -- hr_entry.ins_3p_ent_values
3399: --
3400: -- DESCRIPTION
3401: -- This function is used for third party inserts into:
3402: -- PAY_ELEMENT_ENTRIES_F (If an abscence, or DT functions are being used).
3403: -- PAY_ELEMENT_ENTRY_VALUES_F (Entry Values are always inserted).
3404: -- PAY_RUN_RESULTS (If nonrecurring).
3405: -- PAY_RUN_RESULT_VBALUES (If nonrecurring).
3406: --

Line 3487: from pay_element_entries_f ee,

3483: v_element_type_id,
3484: v_processing_type,
3485: v_input_currency_code,
3486: v_output_currency_code
3487: from pay_element_entries_f ee,
3488: pay_element_links_f el,
3489: pay_element_types_f et
3490: where ee.element_entry_id = p_element_entry_id
3491: and el.element_link_id = ee.element_link_id

Line 3533: from pay_element_entries_f ee

3529: -- then the the entry is being updated otherwise it is being inserted.
3530: begin
3531: select count(*)
3532: into v_entry_count
3533: from pay_element_entries_f ee
3534: where ee.element_entry_id = p_element_entry_id;
3535: exception
3536: when no_data_found then null;
3537: end;

Line 3668: pay_element_entries_f pee

3664: select eev.screen_entry_value
3665: into v_jurisdiction
3666: from pay_element_entry_values_f eev,
3667: pay_input_values_f piv,
3668: pay_element_entries_f pee
3669: where pee.element_entry_id = v_element_entry_id
3670: and eev.element_entry_id = pee.element_entry_id
3671: and eev.input_value_id = piv.input_value_id
3672: and piv.name = 'Jurisdiction'

Line 4104: -- PAY_ELEMENT_ENTRIES_F (If an abscence, or DT functions are being used).

4100: -- hr_entry.del_3p_entry_values
4101: --
4102: -- DESCRIPTION
4103: -- This procedure is used for third party deletes from:
4104: -- PAY_ELEMENT_ENTRIES_F (If an abscence, or DT functions are being used).
4105: -- PAY_ELEMENT_ENTRY_VALUES_F (Entry Values are always deleted).
4106: -- PAY_RUN_RESULTS (If nonrecurring, and exist).
4107: -- PAY_RUN_RESULT_VALUES (If nonrecurring, and exist).
4108: -- BEN_COVERED_DEPENDENTS_F (sic)

Line 4349: from pay_element_entries_f ee

4345: begin
4346: delete from pay_element_entry_values_f eev
4347: where eev.element_entry_id in
4348: (select ee.element_entry_id
4349: from pay_element_entries_f ee
4350: where ee.creator_type = p_creator_type
4351: and ee.creator_id = p_creator_id
4352: and ee.entry_type = p_entry_type
4353: and ee.element_link_id = p_element_link_id

Line 4372: delete from pay_element_entries_f ee

4368: if g_debug then
4369: hr_utility.set_location('hr_entry.del_3p_entry_values', 6);
4370: end if;
4371: begin
4372: delete from pay_element_entries_f ee
4373: where ee.element_entry_id = p_element_entry_id;
4374: exception
4375: when NO_DATA_FOUND then NULL;
4376: end;

Line 4387: delete from pay_element_entries_f ee

4383: if g_debug then
4384: hr_utility.set_location('hr_entry.del_3p_entry_values', 7);
4385: end if;
4386: begin
4387: delete from pay_element_entries_f ee
4388: where ee.creator_type = p_creator_type
4389: and ee.creator_id = p_creator_id
4390: and ee.entry_type = p_entry_type
4391: and ee.element_link_id = p_element_link_id

Line 4461: from pay_element_entries_f

4457: update pay_element_entry_values_f eev
4458: -- bug 384948. Changed set clouse to supply effective_end_date of the
4459: -- element entry as opposite to p_validation_end_date.
4460: set eev.effective_end_date = (select effective_end_date
4461: from pay_element_entries_f
4462: where element_entry_id = p_element_entry_id
4463: and effective_start_date = eev.effective_start_date)
4464: where eev.element_entry_id = p_element_entry_id
4465: and p_session_date between eev.effective_start_date

Line 5795: from pay_element_entries_f pee

5791: end if;
5792: begin
5793: select 'Y'
5794: into l_overridden
5795: from pay_element_entries_f pee
5796: where p_session_date
5797: between pee.effective_start_date
5798: and pee.effective_end_date
5799: and pee.entry_type = 'S'

Line 5818: from pay_element_entries_f pee

5814: end if;
5815: begin
5816: select 'Y'
5817: into p_adjustment
5818: from pay_element_entries_f pee
5819: where p_session_date
5820: between pee.effective_start_date
5821: and pee.effective_end_date
5822: and (pee.entry_type = 'R'

Line 5936: from pay_element_entries_f pee

5932: into l_error_flag
5933: from sys.dual
5934: where exists
5935: (select 1
5936: from pay_element_entries_f pee
5937: where pee.element_entry_id = p_element_entry_id
5938: and pee.creator_type = 'SP'
5939: and pee.effective_start_date >= p_validation_start_date);
5940: exception