18: ,P_COND_EXT_DATA_ELMT_IN_RCD_ID in NUMBER
19: ,P_EFFECTIVE_DATE in DATE
20: )is
21: begin
22: hr_utility.set_location('Entering: BEN_EXT_WHERE_CLAUSE_BK1.CREATE_EXT_WHERE_CLAUSE_A', 10);
23: hr_utility.set_location(' Leaving: BEN_EXT_WHERE_CLAUSE_BK1.CREATE_EXT_WHERE_CLAUSE_A', 20);
24: end CREATE_EXT_WHERE_CLAUSE_A;
25: procedure CREATE_EXT_WHERE_CLAUSE_B
26: (P_SEQ_NUM in NUMBER
19: ,P_EFFECTIVE_DATE in DATE
20: )is
21: begin
22: hr_utility.set_location('Entering: BEN_EXT_WHERE_CLAUSE_BK1.CREATE_EXT_WHERE_CLAUSE_A', 10);
23: hr_utility.set_location(' Leaving: BEN_EXT_WHERE_CLAUSE_BK1.CREATE_EXT_WHERE_CLAUSE_A', 20);
24: end CREATE_EXT_WHERE_CLAUSE_A;
25: procedure CREATE_EXT_WHERE_CLAUSE_B
26: (P_SEQ_NUM in NUMBER
27: ,P_OPER_CD in VARCHAR2
36: ,P_COND_EXT_DATA_ELMT_IN_RCD_ID in NUMBER
37: ,P_EFFECTIVE_DATE in DATE
38: )is
39: begin
40: hr_utility.set_location('Entering: BEN_EXT_WHERE_CLAUSE_BK1.CREATE_EXT_WHERE_CLAUSE_B', 10);
41: hr_utility.set_location(' Leaving: BEN_EXT_WHERE_CLAUSE_BK1.CREATE_EXT_WHERE_CLAUSE_B', 20);
42: end CREATE_EXT_WHERE_CLAUSE_B;
43: end BEN_EXT_WHERE_CLAUSE_BK1;
37: ,P_EFFECTIVE_DATE in DATE
38: )is
39: begin
40: hr_utility.set_location('Entering: BEN_EXT_WHERE_CLAUSE_BK1.CREATE_EXT_WHERE_CLAUSE_B', 10);
41: hr_utility.set_location(' Leaving: BEN_EXT_WHERE_CLAUSE_BK1.CREATE_EXT_WHERE_CLAUSE_B', 20);
42: end CREATE_EXT_WHERE_CLAUSE_B;
43: end BEN_EXT_WHERE_CLAUSE_BK1;