APPS.PAY_DYN_TRIGGERS dependencies on PAY_FUNCTIONAL_USAGES

Line 758: Inserts/Updates the PAY_FUNCTIONAL_USAGES table.

754: /*
755: NAME
756: create_func_usage
757: NOTES
758: Inserts/Updates the PAY_FUNCTIONAL_USAGES table.
759: */
760: procedure create_func_usage (p_area_name varchar2
761: ,p_usage_id varchar2
762: ,p_business_group_name varchar2

Line 815: insert into pay_functional_usages

811: else
812: hr_general2.init_fndload(800,-1);
813: end if;
814:
815: insert into pay_functional_usages
816: (
817: usage_id,
818: area_id,
819: business_group_id,

Line 831: from pay_functional_usages

827: p_legislation_code,
828: l_payroll_id
829: from sys.dual
830: where not exists( select 'X'
831: from pay_functional_usages
832: where area_id = l_area_id
833: and usage_id =to_number(p_usage_id)
834: );
835: