APPS.PER_RES_BUS dependencies on PER_CAGR_ENTITLEMENT_RESULTS

Line 29: , per_cagr_entitlement_results res

25: --
26: cursor csr_sec_grp is
27: select pbg.security_group_id
28: from per_business_groups pbg
29: , per_cagr_entitlement_results res
30: where res.cagr_entitlement_result_id = p_cagr_entitlement_result_id
31: and pbg.business_group_id = res.business_group_id;
32: --
33: -- Declare local variables

Line 89: , per_cagr_entitlement_results res

85: --
86: cursor csr_leg_code is
87: select pbg.legislation_code
88: from per_business_groups pbg
89: , per_cagr_entitlement_results res
90: where res.cagr_entitlement_result_id = p_cagr_entitlement_result_id
91: and pbg.business_group_id (+) = res.business_group_id;
92: --
93: -- Declare local variables

Line 432: -- supports update of per_cagr_entitlement_results.

428: -- Description:
429: -- Validates that the value for chosen_flag exists in hr_lookups (lookup_code)
430: -- for the lookup_type 'YES_NO' on the effective date.
431: -- Only called by update_validate since the row_handler deliberately only
432: -- supports update of per_cagr_entitlement_results.
433: --
434: -- Pre-conditions:
435: -- Effective_date must be valid.
436: --

Line 557: -- per_cagr_engine_pkg may write records to the per_cagr_entitlement_results table.

553: Begin
554: hr_utility.set_location('Entering:'||l_proc, 5);
555: --
556: -- Error out - this rowhandler should not be used to insert data as only
557: -- per_cagr_engine_pkg may write records to the per_cagr_entitlement_results table.
558: --
559: hr_utility.set_message(800, 'HR_XXXXX_CAGR_INV_RES_INS');
560: hr_utility.raise_error;
561: --