APPS.PAY_LOAD_PARAMETERS dependencies on PAY_PARAMETER_QUALIFIERS

Line 39: -- Procedure used to upload seed data for the table PAY_PARAMETER_QUALIFIERS

35: -- |-----------------------< load_parameter_qualifiers >----------------------|
36: -- ----------------------------------------------------------------------------
37: --
38: -- Description:
39: -- Procedure used to upload seed data for the table PAY_PARAMETER_QUALIFIERS
40: --
41: -- ----------------------------------------------------------------------------
42: procedure load_parameter_qualifiers
43: ( p_qualifier in varchar2

Line 50: from pay_parameter_qualifiers ppq

46: ) AS
47:
48: cursor ppq_exits(p_qualifier_name varchar2) is
49: select qualifier
50: from pay_parameter_qualifiers ppq
51: where ppq.qualifier = p_qualifier_name;
52: --
53:
54: found boolean;

Line 70: UPDATE PAY_PARAMETER_QUALIFIERS SET

66: hr_utility.trace('After getting qualifier_name : '||l_qualifier);
67:
68: if(found = TRUE) then
69:
70: UPDATE PAY_PARAMETER_QUALIFIERS SET
71: description = p_description
72: , LAST_UPDATED_BY = decode(p_owner,'SEED',1,0)
73: , LAST_UPDATE_DATE = SYSDATE
74: , LAST_UPDATE_LOGIN = fnd_global.login_id

Line 81: INSERT INTO PAY_PARAMETER_QUALIFIERS (

77: else
78:
79: hr_utility.trace('Inserting new qualifier : '||p_qualifier);
80:
81: INSERT INTO PAY_PARAMETER_QUALIFIERS (
82: qualifier
83: , description
84: ,LAST_UPDATED_BY
85: ,LAST_UPDATE_DATE