DBA Data[Home] [Help]

APPS.HR_ENTRY dependencies on PAY_RUN_RESULT_VALUES

Line 3751: insert into pay_run_result_values

3747: else
3748: v_amount:=peev.value;
3749: end if;
3750: --
3751: insert into pay_run_result_values
3752: (input_value_id,
3753: run_result_id,
3754: result_value)
3755: values

Line 3779: insert into pay_run_result_values

3775: hr_utility.set_location('hr_entry.ins_3p_entry_values', 8);
3776: end if;
3777: begin
3778: --
3779: insert into pay_run_result_values
3780: (input_value_id,
3781: run_result_id,
3782: result_value)
3783: select

Line 4107: -- PAY_RUN_RESULT_VALUES (If nonrecurring, and exist).

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
4110: --
4111:

Line 4288: delete from pay_run_result_values rrv

4284: if g_debug then
4285: hr_utility.set_location('hr_entry.del_3p_entry_values', 2);
4286: end if;
4287: begin
4288: delete from pay_run_result_values rrv
4289: where rrv.run_result_id =
4290: (select rr.run_result_id
4291: from pay_run_results rr
4292: where rr.element_type_id + 0 = p_element_type_id

Line 4598: UPDATE PAY_RUN_RESULT_VALUES PRRV1

4594: if g_debug then
4595: hr_utility.set_location('hr_entry.upd_3p_entry_values', 3);
4596: end if;
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

Line 4680: -- PAY_RUN_RESULT_VALUES (If nonrecurring).

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 !
4683: --
4684: procedure upd_3p_entry_values

Line 4759: -- PAY_RUN_RESULT_VALUES (If nonrecurring).

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 !
4762: --
4763: procedure upd_3p_entry_values