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_ENTRY_VALUES_F

Line 3403: -- PAY_ELEMENT_ENTRY_VALUES_F (Entry Values are always inserted).

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: --
3407: --

Line 3425: pay_element_entry_values_f peev

3421: select peev.input_value_id,
3422: piv.uom,
3423: peev.screen_entry_value value
3424: from pay_input_values_f piv,
3425: pay_element_entry_values_f peev
3426: where peev.element_entry_id = p_element_entry_id
3427: and piv.input_value_id = peev.input_value_id
3428: and p_session_date between peev.effective_start_date
3429: and peev.effective_end_date

Line 3547: insert into pay_element_entry_values_f

3543: -- Bug 4347283. Changed to use forall for bulk insert.
3544: --
3545: forall v_loop in 1..p_num_entry_values
3546: --
3547: insert into pay_element_entry_values_f
3548: (element_entry_value_id,
3549: effective_start_date,
3550: effective_end_date,
3551: input_value_id,

Line 3573: -- index PAY_ELEMENT_ENTRY_VALUES_F_N1

3569: --
3570: --
3571: -- WWbug 273821
3572: -- Added + 0 to eev.input_value_id to disable the use of
3573: -- index PAY_ELEMENT_ENTRY_VALUES_F_N1
3574: --
3575: insert into pay_element_entry_values_f
3576: (element_entry_value_id,
3577: effective_start_date,

Line 3575: insert into pay_element_entry_values_f

3571: -- WWbug 273821
3572: -- Added + 0 to eev.input_value_id to disable the use of
3573: -- index PAY_ELEMENT_ENTRY_VALUES_F_N1
3574: --
3575: insert into pay_element_entry_values_f
3576: (element_entry_value_id,
3577: effective_start_date,
3578: effective_end_date,
3579: input_value_id,

Line 3589: from pay_element_entry_values_f eev

3585: v_effective_end_date,
3586: eev.input_value_id,
3587: p_element_entry_id,
3588: p_entry_value_tbl(v_loop)
3589: from pay_element_entry_values_f eev
3590: where eev.element_entry_id = p_element_entry_id
3591: and eev.input_value_id + 0 = p_input_value_id_tbl(v_loop)
3592: and p_session_date - 1 between eev.effective_start_date
3593: and eev.effective_end_date;

Line 3666: from pay_element_entry_values_f eev,

3662: -- First get the Jurisdiction if one exists.
3663: begin
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

Line 3787: from pay_element_entry_values_f peev

3783: select
3784: peev.input_value_id,
3785: v_run_result_id,
3786: peev.screen_entry_value
3787: from pay_element_entry_values_f peev
3788: where peev.element_entry_id = v_element_entry_id
3789: and p_session_date between peev.effective_start_date
3790: and peev.effective_end_date;
3791: --

Line 4105: -- PAY_ELEMENT_ENTRY_VALUES_F (Entry Values are always deleted).

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)
4109: -- BEN_BENEFICIARIES_F

Line 4329: delete from pay_element_entry_values_f eev

4325: if g_debug then
4326: hr_utility.set_location('hr_entry.del_3p_entry_values', 4);
4327: end if;
4328: begin
4329: delete from pay_element_entry_values_f eev
4330: where eev.element_entry_id = p_element_entry_id;
4331: end;
4332: else
4333: --

Line 4346: delete from pay_element_entry_values_f eev

4342: if g_debug then
4343: hr_utility.set_location('hr_entry.del_3p_entry_values', 5);
4344: end if;
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

Line 4406: update pay_element_entry_values_f eev

4402: if g_debug then
4403: hr_utility.set_location('hr_entry.del_3p_entry_values', 8);
4404: end if;
4405: begin
4406: update pay_element_entry_values_f eev
4407: set eev.effective_end_date = p_session_date
4408: where eev.element_entry_id = p_element_entry_id
4409: and p_session_date between eev.effective_start_date
4410: and eev.effective_end_date;

Line 4423: delete from pay_element_entry_values_f eev

4419: if g_debug then
4420: hr_utility.set_location('hr_entry.del_3p_entry_values', 9);
4421: end if;
4422: begin
4423: delete from pay_element_entry_values_f eev
4424: where eev.element_entry_id = p_element_entry_id
4425: and eev.effective_start_date >= p_validation_start_date;
4426: end;
4427: --

Line 4441: delete from pay_element_entry_values_f eev

4437: if g_debug then
4438: hr_utility.set_location('hr_entry.del_3p_entry_values', 9);
4439: end if;
4440: begin
4441: delete from pay_element_entry_values_f eev
4442: where eev.element_entry_id = p_element_entry_id
4443: and (
4444: (eev.effective_end_date between p_validation_start_date
4445: and p_validation_end_date)

Line 4457: update pay_element_entry_values_f eev

4453: if g_debug then
4454: hr_utility.set_location('hr_entry.del_3p_entry_values', 10);
4455: end if;
4456: begin
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

Line 4560: -- index PAY_ELEMENT_ENTRY_VALUES_F_N1

4556: --
4557: --
4558: -- WWbug 273821
4559: -- Added + 0 to eev.input_value_id to disable the use of
4560: -- index PAY_ELEMENT_ENTRY_VALUES_F_N1
4561: --
4562: update pay_element_entry_values_f eev
4563: set eev.screen_entry_value = p_entry_value_tbl(v_loop)
4564: where eev.element_entry_id = p_element_entry_id

Line 4562: update pay_element_entry_values_f eev

4558: -- WWbug 273821
4559: -- Added + 0 to eev.input_value_id to disable the use of
4560: -- index PAY_ELEMENT_ENTRY_VALUES_F_N1
4561: --
4562: update pay_element_entry_values_f eev
4563: set eev.screen_entry_value = p_entry_value_tbl(v_loop)
4564: where eev.element_entry_id = p_element_entry_id
4565: and eev.input_value_id + 0 = p_input_value_id_tbl(v_loop)
4566: and p_validation_start_date between eev.effective_start_date

Line 4601: FROM PAY_ELEMENT_ENTRY_VALUES_F PEEV1

4597: begin
4598: UPDATE PAY_RUN_RESULT_VALUES PRRV1
4599: SET PRRV1.RESULT_VALUE =
4600: (SELECT PEEV1.SCREEN_ENTRY_VALUE
4601: FROM PAY_ELEMENT_ENTRY_VALUES_F PEEV1
4602: WHERE p_session_date
4603: BETWEEN PEEV1.EFFECTIVE_START_DATE
4604: AND PEEV1.EFFECTIVE_END_DATE
4605: AND PEEV1.ELEMENT_ENTRY_ID = p_element_entry_id

Line 4631: UPDATE PAY_ELEMENT_ENTRY_VALUES_F PEEV1

4627: if g_debug then
4628: hr_utility.set_location('hr_entry.upd_3p_entry_values', 4);
4629: end if;
4630: begin
4631: UPDATE PAY_ELEMENT_ENTRY_VALUES_F PEEV1
4632: SET PEEV1.EFFECTIVE_END_DATE = p_validation_start_date - 1
4633: WHERE PEEV1.ELEMENT_ENTRY_ID = p_element_entry_id
4634: AND p_session_date
4635: BETWEEN PEEV1.EFFECTIVE_START_DATE AND PEEV1.EFFECTIVE_END_DATE;

Line 4653: DELETE FROM PAY_ELEMENT_ENTRY_VALUES_F PEEV1

4649: if g_debug then
4650: hr_utility.set_location('hr_entry.upd_3p_entry_values', 5);
4651: end if;
4652: begin
4653: DELETE FROM PAY_ELEMENT_ENTRY_VALUES_F PEEV1
4654: WHERE PEEV1.ELEMENT_ENTRY_ID = p_element_entry_id
4655: AND PEEV1.EFFECTIVE_START_DATE >= p_validation_start_date;
4656: end;
4657: end if;

Line 4678: -- PAY_ELEMENT_ENTRY_VALUES_F

4674: -- hr_entry.upd_3p_entry_values
4675: --
4676: -- DESCRIPTION
4677: -- This procedure is used for third party updates into:
4678: -- PAY_ELEMENT_ENTRY_VALUES_F
4679: -- PAY_RUN_RESULTS (If nonrecurring).
4680: -- PAY_RUN_RESULT_VALUES (If nonrecurring).
4681: --
4682: -- NB. this procedure is OVERLOADED !

Line 4757: -- PAY_ELEMENT_ENTRY_VALUES_F

4753: -- hr_entry.upd_3p_entry_values
4754: --
4755: -- DESCRIPTION
4756: -- This procedure is used for third party updates into:
4757: -- PAY_ELEMENT_ENTRY_VALUES_F
4758: -- PAY_RUN_RESULTS (If nonrecurring).
4759: -- PAY_RUN_RESULT_VALUES (If nonrecurring).
4760: --
4761: -- NB. this Procedure is OVERLOADED !