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 14: g_target_entry_id pay_element_entries_f.target_entry_id%type;

10: -- If the assignment has not been terminated then the returned
11: -- actual_termination_date date will be null.
12: --
13: g_debug boolean := hr_utility.debug_enabled;
14: g_target_entry_id pay_element_entries_f.target_entry_id%type;
15: function return_termination_date(p_assignment_id in number,
16: p_session_date in date)
17: return date is
18: l_actual_termination_date date;

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

288: select 'Y'
289: into v_overlap_occurred
290: from sys.dual
291: where exists
292: (select /*+ INDEX(ee, pay_element_entries_f_n51) */ null
293: from pay_element_entries_f ee
294: where ee.entry_type = 'E'
295: and ee.element_entry_id <> nvl(p_element_entry_id,0)
296: and ee.assignment_id = p_assignment_id

Line 293: from pay_element_entries_f ee

289: into v_overlap_occurred
290: from sys.dual
291: where exists
292: (select /*+ INDEX(ee, pay_element_entries_f_n51) */ null
293: from pay_element_entries_f ee
294: where ee.entry_type = 'E'
295: and ee.element_entry_id <> nvl(p_element_entry_id,0)
296: and ee.assignment_id = p_assignment_id
297: and ee.element_link_id = p_element_link_id

Line 480: -- PAY_ELEMENT_ENTRIES_F base table.

476: -- hr_entry.generate_entry_id
477: --
478: -- DESCRIPTION
479: -- Generates then next sequence value for inserting an element entry into the
480: -- PAY_ELEMENT_ENTRIES_F base table.
481: --
482: FUNCTION generate_entry_id return number is
483: v_element_entry_id number;
484: --

Line 1985: from pay_element_entries_f e

1981: end if;
1982: begin
1983: select e.effective_end_date
1984: into v_current_effective_end_date
1985: from pay_element_entries_f e
1986: where e.element_entry_id = p_element_entry_id
1987: and p_session_date
1988: between e.effective_start_date
1989: and e.effective_end_date;

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

2003: hr_utility.set_location('hr_entry.recurring_entry_end_date', 1);
2004: end if;
2005: begin
2006: -- INDEX hint added following NHS project recommendation
2007: select /*+ INDEX(pee, pay_element_entries_f_n51) */
2008: nvl(min(pee.effective_start_date) - 1, hr_general.end_of_time)
2009: into v_future_recurring_end_date
2010: from pay_element_entries_f pee
2011: where pee.entry_type = 'E'

Line 2010: from pay_element_entries_f pee

2006: -- INDEX hint added following NHS project recommendation
2007: select /*+ INDEX(pee, pay_element_entries_f_n51) */
2008: nvl(min(pee.effective_start_date) - 1, hr_general.end_of_time)
2009: into v_future_recurring_end_date
2010: from pay_element_entries_f pee
2011: where pee.entry_type = 'E'
2012: and pee.assignment_id = p_assignment_id
2013: and pee.element_link_id = p_element_link_id
2014: and pee.element_entry_id <> nvl(p_element_entry_id,0)

Line 3074: from pay_element_entries_f

3070: v_element_effective_start_date date;
3071: --
3072: cursor c_element_start_date is
3073: select effective_start_date
3074: from pay_element_entries_f
3075: where element_entry_id = p_target_entry_id;
3076: --
3077: cursor c_cwk_element_check is
3078: -- Should not allow these PTO elements for CWKs

Line 3411: ,p_base_table_name => 'pay_element_entries_f'

3407: if p_usage = 'INSERT' then
3408: dt_api.validate_dt_mode(
3409: p_effective_date => p_session_date --*
3410: ,p_datetrack_mode => 'INSERT' --*
3411: ,p_base_table_name => 'pay_element_entries_f'
3412: ,p_base_key_column => 'element_entry_id'
3413: ,p_base_key_value => p_element_entry_id --*
3414: ,p_parent_table_name1 => 'per_all_assignments_f'
3415: ,p_parent_key_column1 => 'assignment_id'

Line 3515: INDEX(pee, pay_element_entries_f_n51 */ 1

3511: into v_error_flag
3512: from sys.dual
3513: where exists
3514: (select /*+ FIRST_ROWS(1)
3515: INDEX(pee, pay_element_entries_f_n51 */ 1
3516: from pay_element_entries_f pee
3517: where pee.entry_type = p_entry_type
3518: and pee.assignment_id = p_assignment_id
3519: and pee.element_link_id = p_element_link_id

Line 3516: from pay_element_entries_f pee

3512: from sys.dual
3513: where exists
3514: (select /*+ FIRST_ROWS(1)
3515: INDEX(pee, pay_element_entries_f_n51 */ 1
3516: from pay_element_entries_f pee
3517: where pee.entry_type = p_entry_type
3518: and pee.assignment_id = p_assignment_id
3519: and pee.element_link_id = p_element_link_id
3520: and pee.effective_start_date >= v_period_start_date

Line 3553: INDEX(pee, pay_element_entries_f_n51 */ 1

3549: into v_error_flag
3550: from sys.dual
3551: where exists
3552: (select /*+ FIRST_ROWS(1)
3553: INDEX(pee, pay_element_entries_f_n51 */ 1
3554: from pay_element_entries_f pee
3555: where pee.target_entry_id = p_element_entry_id
3556: and pee.element_link_id = p_element_link_id
3557: and pee.assignment_id = p_assignment_id

Line 3554: from pay_element_entries_f pee

3550: from sys.dual
3551: where exists
3552: (select /*+ FIRST_ROWS(1)
3553: INDEX(pee, pay_element_entries_f_n51 */ 1
3554: from pay_element_entries_f pee
3555: where pee.target_entry_id = p_element_entry_id
3556: and pee.element_link_id = p_element_link_id
3557: and pee.assignment_id = p_assignment_id
3558: and pee.effective_start_date <= v_validation_end_date

Line 3589: INDEX(pee, pay_element_entries_f_n51 */ 1

3585: into v_error_flag
3586: from sys.dual
3587: where exists
3588: (select /*+ FIRST_ROWS(1)
3589: INDEX(pee, pay_element_entries_f_n51 */ 1
3590: from pay_element_entries_f pee
3591: where pee.entry_type = 'S'
3592: and pee.assignment_id = p_assignment_id
3593: and pee.element_link_id = p_element_link_id

Line 3590: from pay_element_entries_f pee

3586: from sys.dual
3587: where exists
3588: (select /*+ FIRST_ROWS(1)
3589: INDEX(pee, pay_element_entries_f_n51 */ 1
3590: from pay_element_entries_f pee
3591: where pee.entry_type = 'S'
3592: and pee.assignment_id = p_assignment_id
3593: and pee.element_link_id = p_element_link_id
3594: and pee.effective_start_date >= v_period_start_date

Line 3619: INDEX(pee, pay_element_entries_f_n51 */ 1

3615: into v_error_flag
3616: from sys.dual
3617: where exists
3618: (select /*+ FIRST_ROWS(1)
3619: INDEX(pee, pay_element_entries_f_n51 */ 1
3620: from pay_element_entries_f pee
3621: where pee.entry_type in ('R','A')
3622: and pee.assignment_id = p_assignment_id
3623: and pee.element_link_id = p_element_link_id

Line 3620: from pay_element_entries_f pee

3616: from sys.dual
3617: where exists
3618: (select /*+ FIRST_ROWS(1)
3619: INDEX(pee, pay_element_entries_f_n51 */ 1
3620: from pay_element_entries_f pee
3621: where pee.entry_type in ('R','A')
3622: and pee.assignment_id = p_assignment_id
3623: and pee.element_link_id = p_element_link_id
3624: and pee.effective_start_date >= v_period_start_date

Line 3665: from pay_element_entries_f pee

3661: into v_error_flag
3662: from sys.dual
3663: where not exists
3664: (select /*+ FIRST_ROWS(1) */ 1
3665: from pay_element_entries_f pee
3666: where pee.assignment_id = p_assignment_id
3667: and pee.element_entry_id = p_target_entry_id
3668: having min(pee.effective_start_date) <=
3669: v_validation_start_date

Line 3694: INDEX(pee, pay_element_entries_f_n51 */ 1

3690: into v_error_flag
3691: from sys.dual
3692: where exists
3693: (select /*+ FIRST_ROWS(1)
3694: INDEX(pee, pay_element_entries_f_n51 */ 1
3695: from pay_element_entries_f pee
3696: where pee.entry_type = 'S'
3697: and pee.assignment_id = p_assignment_id
3698: and pee.element_link_id = p_element_link_id

Line 3695: from pay_element_entries_f pee

3691: from sys.dual
3692: where exists
3693: (select /*+ FIRST_ROWS(1)
3694: INDEX(pee, pay_element_entries_f_n51 */ 1
3695: from pay_element_entries_f pee
3696: where pee.entry_type = 'S'
3697: and pee.assignment_id = p_assignment_id
3698: and pee.element_link_id = p_element_link_id
3699: and pee.effective_start_date >= v_period_start_date

Line 3724: from pay_element_entries_f pee

3720: into v_error_flag
3721: from sys.dual
3722: where exists
3723: (select /*+ FIRST_ROWS(1) */ 1
3724: from pay_element_entries_f pee
3725: where pee.entry_type in ('R','A')
3726: and pee.assignment_id = p_assignment_id
3727: and pee.target_entry_id = p_target_entry_id
3728: and pee.effective_start_date >= v_period_start_date

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

3774: -- hr_entry.ins_3p_ent_values
3775: --
3776: -- DESCRIPTION
3777: -- This function is used for third party inserts into:
3778: -- PAY_ELEMENT_ENTRIES_F (If an abscence, or DT functions are being used).
3779: -- PAY_ELEMENT_ENTRY_VALUES_F (Entry Values are always inserted).
3780: -- PAY_RUN_RESULTS (If nonrecurring).
3781: -- PAY_RUN_RESULT_VBALUES (If nonrecurring).
3782: --

Line 3863: from pay_element_entries_f ee,

3859: v_element_type_id,
3860: v_processing_type,
3861: v_input_currency_code,
3862: v_output_currency_code
3863: from pay_element_entries_f ee,
3864: pay_element_links_f el,
3865: pay_element_types_f et
3866: where ee.element_entry_id = p_element_entry_id
3867: and el.element_link_id = ee.element_link_id

Line 3909: from pay_element_entries_f ee

3905: -- then the the entry is being updated otherwise it is being inserted.
3906: begin
3907: select count(*)
3908: into v_entry_count
3909: from pay_element_entries_f ee
3910: where ee.element_entry_id = p_element_entry_id;
3911: exception
3912: when no_data_found then null;
3913: end;

Line 4044: pay_element_entries_f pee

4040: select eev.screen_entry_value
4041: into v_jurisdiction
4042: from pay_element_entry_values_f eev,
4043: pay_input_values_f piv,
4044: pay_element_entries_f pee
4045: where pee.element_entry_id = v_element_entry_id
4046: and eev.element_entry_id = pee.element_entry_id
4047: and eev.input_value_id = piv.input_value_id
4048: and piv.name = 'Jurisdiction'

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

4476: -- hr_entry.del_3p_entry_values
4477: --
4478: -- DESCRIPTION
4479: -- This procedure is used for third party deletes from:
4480: -- PAY_ELEMENT_ENTRIES_F (If an abscence, or DT functions are being used).
4481: -- PAY_ELEMENT_ENTRY_VALUES_F (Entry Values are always deleted).
4482: -- PAY_RUN_RESULTS (If nonrecurring, and exist).
4483: -- PAY_RUN_RESULT_VALUES (If nonrecurring, and exist).
4484: -- BEN_COVERED_DEPENDENTS_F (sic)

Line 4725: from pay_element_entries_f ee

4721: begin
4722: delete from pay_element_entry_values_f eev
4723: where eev.element_entry_id in
4724: (select ee.element_entry_id
4725: from pay_element_entries_f ee
4726: where ee.creator_type = p_creator_type
4727: and ee.creator_id = p_creator_id
4728: and ee.entry_type = p_entry_type
4729: and ee.element_link_id = p_element_link_id

Line 4748: delete from pay_element_entries_f ee

4744: if g_debug then
4745: hr_utility.set_location('hr_entry.del_3p_entry_values', 6);
4746: end if;
4747: begin
4748: delete from pay_element_entries_f ee
4749: where ee.element_entry_id = p_element_entry_id;
4750: exception
4751: when NO_DATA_FOUND then NULL;
4752: end;

Line 4763: delete from pay_element_entries_f ee

4759: if g_debug then
4760: hr_utility.set_location('hr_entry.del_3p_entry_values', 7);
4761: end if;
4762: begin
4763: delete from pay_element_entries_f ee
4764: where ee.creator_type = p_creator_type
4765: and ee.creator_id = p_creator_id
4766: and ee.entry_type = p_entry_type
4767: and ee.element_link_id = p_element_link_id

Line 4837: from pay_element_entries_f

4833: update pay_element_entry_values_f eev
4834: -- bug 384948. Changed set clouse to supply effective_end_date of the
4835: -- element entry as opposite to p_validation_end_date.
4836: set eev.effective_end_date = (select effective_end_date
4837: from pay_element_entries_f
4838: where element_entry_id = p_element_entry_id
4839: and effective_start_date = eev.effective_start_date)
4840: where eev.element_entry_id = p_element_entry_id
4841: and p_session_date between eev.effective_start_date

Line 6184: from pay_element_entries_f pee

6180: end if;
6181: begin
6182: select 'Y'
6183: into l_overridden
6184: from pay_element_entries_f pee
6185: where p_session_date
6186: between pee.effective_start_date
6187: and pee.effective_end_date
6188: and pee.entry_type = 'S'

Line 6207: from pay_element_entries_f pee

6203: end if;
6204: begin
6205: select 'Y'
6206: into p_adjustment
6207: from pay_element_entries_f pee
6208: where p_session_date
6209: between pee.effective_start_date
6210: and pee.effective_end_date
6211: and (pee.entry_type = 'R'

Line 6325: from pay_element_entries_f pee

6321: into l_error_flag
6322: from sys.dual
6323: where exists
6324: (select 1
6325: from pay_element_entries_f pee
6326: where pee.element_entry_id = p_element_entry_id
6327: and pee.creator_type = 'SP'
6328: and pee.effective_start_date >= p_validation_start_date);
6329: exception