DBA Data[Home] [Help]

APPS.PAY_MAG_UTILS dependencies on HR_LOOKUPS

Line 663: -- Inserts lookups into the hr_lookups table. It firstly checks if the lookup

659: -----------------------------------------------------------------------------
660: -- Name
661: -- Insert_Lookups
662: -- Purpose
663: -- Inserts lookups into the hr_lookups table. It firstly checks if the lookup
664: -- exists before inserting it thus avoiding duplication.
665: -- Arguments
666: -- p_lookup_code - lookup code to add
667: -- p_lookup_type - lookup type to add

Line 687: FROM HR_LOOKUPS HR

683: l_dummy VARCHAR2(1);
684: --
685: CURSOR c1 IS
686: SELECT NULL
687: FROM HR_LOOKUPS HR
688: WHERE HR.lookup_type = p_lookup_type
689: AND HR.lookup_code = p_lookup_code;
690: --
691: BEGIN

Line 700: INSERT INTO hr_lookups

696: IF c1%notfound THEN
697: --
698: -- insert the lookup
699: --
700: INSERT INTO hr_lookups
701: (lookup_code,
702: lookup_type,
703: application_id,
704: created_by,