DBA Data[Home] [Help]

APPS.PAY_ACCRUAL_PLANS_PKG dependencies on HR_LOOKUPS

Line 558: from hr_lookups hl

554: --l_post_termination_rule := 'Final Close';
555: begin
556: select hl.meaning
557: into l_post_termination_rule
558: from hr_lookups hl
559: where hl.lookup_type='TERMINATION_RULE'
560: and hl.lookup_code='F';
561: exception
562: when no_data_found then

Line 761: hr_lookups hrl

757: WHERE input_value_id =
758: ( SELECT piv.input_value_id
759: FROM pay_input_values_f piv,
760: pay_accrual_plans pap,
761: hr_lookups hrl
762: WHERE pap.accrual_plan_id = p_accrual_plan_id
763: AND pap.accrual_plan_element_type_id = piv.element_type_id
764: AND piv.name = hrl.meaning
765: AND hrl.lookup_code = 'PAY VALUE'