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 3779: -- PAY_ELEMENT_ENTRY_VALUES_F (Entry Values are always inserted).

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

Line 3801: pay_element_entry_values_f peev

3797: select peev.input_value_id,
3798: piv.uom,
3799: peev.screen_entry_value value
3800: from pay_input_values_f piv,
3801: pay_element_entry_values_f peev
3802: where peev.element_entry_id = p_element_entry_id
3803: and piv.input_value_id = peev.input_value_id
3804: and p_session_date between peev.effective_start_date
3805: and peev.effective_end_date

Line 3923: insert into pay_element_entry_values_f

3919: -- Bug 4347283. Changed to use forall for bulk insert.
3920: --
3921: forall v_loop in 1..p_num_entry_values
3922: --
3923: insert into pay_element_entry_values_f
3924: (element_entry_value_id,
3925: effective_start_date,
3926: effective_end_date,
3927: input_value_id,

Line 3949: -- index PAY_ELEMENT_ENTRY_VALUES_F_N1

3945: --
3946: --
3947: -- WWbug 273821
3948: -- Added + 0 to eev.input_value_id to disable the use of
3949: -- index PAY_ELEMENT_ENTRY_VALUES_F_N1
3950: --
3951: insert into pay_element_entry_values_f
3952: (element_entry_value_id,
3953: effective_start_date,

Line 3951: insert into pay_element_entry_values_f

3947: -- WWbug 273821
3948: -- Added + 0 to eev.input_value_id to disable the use of
3949: -- index PAY_ELEMENT_ENTRY_VALUES_F_N1
3950: --
3951: insert into pay_element_entry_values_f
3952: (element_entry_value_id,
3953: effective_start_date,
3954: effective_end_date,
3955: input_value_id,

Line 3965: from pay_element_entry_values_f eev

3961: v_effective_end_date,
3962: eev.input_value_id,
3963: p_element_entry_id,
3964: p_entry_value_tbl(v_loop)
3965: from pay_element_entry_values_f eev
3966: where eev.element_entry_id = p_element_entry_id
3967: and eev.input_value_id + 0 = p_input_value_id_tbl(v_loop)
3968: and p_session_date - 1 between eev.effective_start_date
3969: and eev.effective_end_date;

Line 4042: from pay_element_entry_values_f eev,

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

Line 4163: from pay_element_entry_values_f peev

4159: select
4160: peev.input_value_id,
4161: v_run_result_id,
4162: peev.screen_entry_value
4163: from pay_element_entry_values_f peev
4164: where peev.element_entry_id = v_element_entry_id
4165: and p_session_date between peev.effective_start_date
4166: and peev.effective_end_date;
4167: --

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

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

Line 4705: delete from pay_element_entry_values_f eev

4701: if g_debug then
4702: hr_utility.set_location('hr_entry.del_3p_entry_values', 4);
4703: end if;
4704: begin
4705: delete from pay_element_entry_values_f eev
4706: where eev.element_entry_id = p_element_entry_id;
4707: end;
4708: else
4709: --

Line 4722: delete from pay_element_entry_values_f eev

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

Line 4782: update pay_element_entry_values_f eev

4778: if g_debug then
4779: hr_utility.set_location('hr_entry.del_3p_entry_values', 8);
4780: end if;
4781: begin
4782: update pay_element_entry_values_f eev
4783: set eev.effective_end_date = p_session_date
4784: where eev.element_entry_id = p_element_entry_id
4785: and p_session_date between eev.effective_start_date
4786: and eev.effective_end_date;

Line 4799: delete from pay_element_entry_values_f eev

4795: if g_debug then
4796: hr_utility.set_location('hr_entry.del_3p_entry_values', 9);
4797: end if;
4798: begin
4799: delete from pay_element_entry_values_f eev
4800: where eev.element_entry_id = p_element_entry_id
4801: and eev.effective_start_date >= p_validation_start_date;
4802: end;
4803: --

Line 4817: delete from pay_element_entry_values_f eev

4813: if g_debug then
4814: hr_utility.set_location('hr_entry.del_3p_entry_values', 9);
4815: end if;
4816: begin
4817: delete from pay_element_entry_values_f eev
4818: where eev.element_entry_id = p_element_entry_id
4819: and (
4820: (eev.effective_end_date between p_validation_start_date
4821: and p_validation_end_date)

Line 4833: update pay_element_entry_values_f eev

4829: if g_debug then
4830: hr_utility.set_location('hr_entry.del_3p_entry_values', 10);
4831: end if;
4832: begin
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

Line 4936: -- index PAY_ELEMENT_ENTRY_VALUES_F_N1

4932: --
4933: --
4934: -- WWbug 273821
4935: -- Added + 0 to eev.input_value_id to disable the use of
4936: -- index PAY_ELEMENT_ENTRY_VALUES_F_N1
4937: --
4938: update pay_element_entry_values_f eev
4939: set eev.screen_entry_value = p_entry_value_tbl(v_loop)
4940: where eev.element_entry_id = p_element_entry_id

Line 4938: update pay_element_entry_values_f eev

4934: -- WWbug 273821
4935: -- Added + 0 to eev.input_value_id to disable the use of
4936: -- index PAY_ELEMENT_ENTRY_VALUES_F_N1
4937: --
4938: update pay_element_entry_values_f eev
4939: set eev.screen_entry_value = p_entry_value_tbl(v_loop)
4940: where eev.element_entry_id = p_element_entry_id
4941: and eev.input_value_id + 0 = p_input_value_id_tbl(v_loop)
4942: and p_validation_start_date between eev.effective_start_date

Line 4977: FROM PAY_ELEMENT_ENTRY_VALUES_F PEEV1

4973: begin
4974: UPDATE PAY_RUN_RESULT_VALUES PRRV1
4975: SET PRRV1.RESULT_VALUE =
4976: (SELECT PEEV1.SCREEN_ENTRY_VALUE
4977: FROM PAY_ELEMENT_ENTRY_VALUES_F PEEV1
4978: WHERE p_session_date
4979: BETWEEN PEEV1.EFFECTIVE_START_DATE
4980: AND PEEV1.EFFECTIVE_END_DATE
4981: AND PEEV1.ELEMENT_ENTRY_ID = p_element_entry_id

Line 5007: UPDATE PAY_ELEMENT_ENTRY_VALUES_F PEEV1

5003: if g_debug then
5004: hr_utility.set_location('hr_entry.upd_3p_entry_values', 4);
5005: end if;
5006: begin
5007: UPDATE PAY_ELEMENT_ENTRY_VALUES_F PEEV1
5008: SET PEEV1.EFFECTIVE_END_DATE = p_validation_start_date - 1
5009: WHERE PEEV1.ELEMENT_ENTRY_ID = p_element_entry_id
5010: AND p_session_date
5011: BETWEEN PEEV1.EFFECTIVE_START_DATE AND PEEV1.EFFECTIVE_END_DATE;

Line 5029: DELETE FROM PAY_ELEMENT_ENTRY_VALUES_F PEEV1

5025: if g_debug then
5026: hr_utility.set_location('hr_entry.upd_3p_entry_values', 5);
5027: end if;
5028: begin
5029: DELETE FROM PAY_ELEMENT_ENTRY_VALUES_F PEEV1
5030: WHERE PEEV1.ELEMENT_ENTRY_ID = p_element_entry_id
5031: AND PEEV1.EFFECTIVE_START_DATE >= p_validation_start_date;
5032: end;
5033: end if;

Line 5054: -- PAY_ELEMENT_ENTRY_VALUES_F

5050: -- hr_entry.upd_3p_entry_values
5051: --
5052: -- DESCRIPTION
5053: -- This procedure is used for third party updates into:
5054: -- PAY_ELEMENT_ENTRY_VALUES_F
5055: -- PAY_RUN_RESULTS (If nonrecurring).
5056: -- PAY_RUN_RESULT_VALUES (If nonrecurring).
5057: --
5058: -- NB. this procedure is OVERLOADED !

Line 5133: -- PAY_ELEMENT_ENTRY_VALUES_F

5129: -- hr_entry.upd_3p_entry_values
5130: --
5131: -- DESCRIPTION
5132: -- This procedure is used for third party updates into:
5133: -- PAY_ELEMENT_ENTRY_VALUES_F
5134: -- PAY_RUN_RESULTS (If nonrecurring).
5135: -- PAY_RUN_RESULT_VALUES (If nonrecurring).
5136: --
5137: -- NB. this Procedure is OVERLOADED !