DBA Data[Home] [Help]

APPS.HR_RUNGEN dependencies on PAY_CONSOLIDATION_SETS

Line 778: SELECT pay_consolidation_sets_s.nextval

774: -- Create new consolidation set
775: --
776: l_sc_consoset_name := 'Separate Check Consolidation';
777: --
778: SELECT pay_consolidation_sets_s.nextval
779: INTO l_sc_consoset_id
780: FROM sys.dual;
781: --
782: INSERT INTO pay_consolidation_sets (

Line 782: INSERT INTO pay_consolidation_sets (

778: SELECT pay_consolidation_sets_s.nextval
779: INTO l_sc_consoset_id
780: FROM sys.dual;
781: --
782: INSERT INTO pay_consolidation_sets (
783: CONSOLIDATION_SET_ID,
784: BUSINESS_GROUP_ID,
785: CONSOLIDATION_SET_NAME)
786: VALUES ( l_sc_consoset_id,

Line 862: DELETE from pay_consolidation_sets

858: commit;
859: --
860: end loop;
861: --
862: DELETE from pay_consolidation_sets
863: WHERE consolidation_set_id = l_sc_preact_id;
864: --
865: delete_sepcheck_asg_set;
866: --