[Home] [Help]
719: --
720: cursor class_name(p_legislation_code varchar2) is
721: select classification_name,
722: classification_id
723: from pay_element_classifications
724: where (business_group_id = p_business_group_id or
725: legislation_code = p_legislation_code)
726: and parent_classification_id is null
727: order by decode (classification_name, 'Information', 1, 2),
730:
731: cursor c_class_id(p_classification_name varchar2,
732: p_legislation_code varchar2) is
733: select classification_id
734: from pay_element_classifications
735: where classification_name = p_classification_name
736: and (business_group_id = p_business_group_id or
737: legislation_code = p_legislation_code);
738:
1018:
1019: hr_utility.set_location(l_proc, 50);
1020: select ec.default_priority + 1
1021: into l_priority
1022: from pay_element_classifications ec
1023: where upper(ec.classification_name) = upper(l_classification_name)
1024: and ec.parent_classification_id is NULL
1025: and ((ec.legislation_code = l_leg_code) or
1026: (ec.legislation_code is null and
1026: (ec.legislation_code is null and
1027: ec.business_group_id is not null and
1028: ec.business_group_id = p_business_group_id
1029: and not exists (select ''
1030: from pay_element_classifications ec2
1031: where upper(ec2.classification_name) = upper(l_classification_name)
1032: and ec2.parent_classification_id is NULL
1033: and ec2.legislation_code = l_leg_code)
1034: ));
2141: cursor c_class_id(p_classification_name varchar2,
2142: p_business_group_id number,
2143: p_legislation_code varchar2) is
2144: select classification_id
2145: from pay_element_classifications
2146: where classification_name = p_classification_name
2147: and (business_group_id = p_business_group_id or
2148: legislation_code = p_legislation_code);
2149: