APPS.PQH_DE_LOCAL_COST_LIVING_PKG dependencies on PER_GEN_HIERARCHY

Line 106: from per_gen_hierarchy_nodes pghn,

102: pghn.information3, -- Additional amount Further Child
103: pghn.information4, -- Amount if Single
104: pghn.information5, -- Amount if Married
105: pghn.information6 -- Amount if Married and a child
106: from per_gen_hierarchy_nodes pghn,
107: per_gen_hierarchy_versions pghv,
108: per_gen_hierarchy_nodes pghn1,
109: per_gen_hierarchy_nodes pghn2,
110: per_gen_hierarchy pgh

Line 107: per_gen_hierarchy_versions pghv,

103: pghn.information4, -- Amount if Single
104: pghn.information5, -- Amount if Married
105: pghn.information6 -- Amount if Married and a child
106: from per_gen_hierarchy_nodes pghn,
107: per_gen_hierarchy_versions pghv,
108: per_gen_hierarchy_nodes pghn1,
109: per_gen_hierarchy_nodes pghn2,
110: per_gen_hierarchy pgh
111: where pgh.TYPE='LOCAL_COST_OF_LIVING'

Line 108: per_gen_hierarchy_nodes pghn1,

104: pghn.information5, -- Amount if Married
105: pghn.information6 -- Amount if Married and a child
106: from per_gen_hierarchy_nodes pghn,
107: per_gen_hierarchy_versions pghv,
108: per_gen_hierarchy_nodes pghn1,
109: per_gen_hierarchy_nodes pghn2,
110: per_gen_hierarchy pgh
111: where pgh.TYPE='LOCAL_COST_OF_LIVING'
112: and pghv.HIERARCHY_ID=pgh.HIERARCHY_ID

Line 109: per_gen_hierarchy_nodes pghn2,

105: pghn.information6 -- Amount if Married and a child
106: from per_gen_hierarchy_nodes pghn,
107: per_gen_hierarchy_versions pghv,
108: per_gen_hierarchy_nodes pghn1,
109: per_gen_hierarchy_nodes pghn2,
110: per_gen_hierarchy pgh
111: where pgh.TYPE='LOCAL_COST_OF_LIVING'
112: and pghv.HIERARCHY_ID=pgh.HIERARCHY_ID
113: and pghn.HIERARCHY_VERSION_ID=pghv.HIERARCHY_VERSION_ID

Line 110: per_gen_hierarchy pgh

106: from per_gen_hierarchy_nodes pghn,
107: per_gen_hierarchy_versions pghv,
108: per_gen_hierarchy_nodes pghn1,
109: per_gen_hierarchy_nodes pghn2,
110: per_gen_hierarchy pgh
111: where pgh.TYPE='LOCAL_COST_OF_LIVING'
112: and pghv.HIERARCHY_ID=pgh.HIERARCHY_ID
113: and pghn.HIERARCHY_VERSION_ID=pghv.HIERARCHY_VERSION_ID
114: and p_effective_date between pghv.date_from and nvl(pghv.date_to, p_effective_date)

Line 123: l_information1 per_gen_hierarchy_nodes.INFORMATION1%type;

119: and pghn2.entity_id = l_grade_id
120: and pghn1.PARENT_HIERARCHY_NODE_ID = pghn.HIERARCHY_NODE_ID
121: and pghn2.PARENT_HIERARCHY_NODE_ID = pghn1.HIERARCHY_NODE_ID;
122:
123: l_information1 per_gen_hierarchy_nodes.INFORMATION1%type;
124: l_information2 per_gen_hierarchy_nodes.INFORMATION2%type;
125: l_information3 per_gen_hierarchy_nodes.INFORMATION3%type;
126: l_information4 per_gen_hierarchy_nodes.INFORMATION4%type;
127: l_information5 per_gen_hierarchy_nodes.INFORMATION5%type;

Line 124: l_information2 per_gen_hierarchy_nodes.INFORMATION2%type;

120: and pghn1.PARENT_HIERARCHY_NODE_ID = pghn.HIERARCHY_NODE_ID
121: and pghn2.PARENT_HIERARCHY_NODE_ID = pghn1.HIERARCHY_NODE_ID;
122:
123: l_information1 per_gen_hierarchy_nodes.INFORMATION1%type;
124: l_information2 per_gen_hierarchy_nodes.INFORMATION2%type;
125: l_information3 per_gen_hierarchy_nodes.INFORMATION3%type;
126: l_information4 per_gen_hierarchy_nodes.INFORMATION4%type;
127: l_information5 per_gen_hierarchy_nodes.INFORMATION5%type;
128: l_information6 per_gen_hierarchy_nodes.INFORMATION6%type;

Line 125: l_information3 per_gen_hierarchy_nodes.INFORMATION3%type;

121: and pghn2.PARENT_HIERARCHY_NODE_ID = pghn1.HIERARCHY_NODE_ID;
122:
123: l_information1 per_gen_hierarchy_nodes.INFORMATION1%type;
124: l_information2 per_gen_hierarchy_nodes.INFORMATION2%type;
125: l_information3 per_gen_hierarchy_nodes.INFORMATION3%type;
126: l_information4 per_gen_hierarchy_nodes.INFORMATION4%type;
127: l_information5 per_gen_hierarchy_nodes.INFORMATION5%type;
128: l_information6 per_gen_hierarchy_nodes.INFORMATION6%type;
129: l_sum_amount number(15,2):=0.00;

Line 126: l_information4 per_gen_hierarchy_nodes.INFORMATION4%type;

122:
123: l_information1 per_gen_hierarchy_nodes.INFORMATION1%type;
124: l_information2 per_gen_hierarchy_nodes.INFORMATION2%type;
125: l_information3 per_gen_hierarchy_nodes.INFORMATION3%type;
126: l_information4 per_gen_hierarchy_nodes.INFORMATION4%type;
127: l_information5 per_gen_hierarchy_nodes.INFORMATION5%type;
128: l_information6 per_gen_hierarchy_nodes.INFORMATION6%type;
129: l_sum_amount number(15,2):=0.00;
130: total number(15,2) :=0.00;

Line 127: l_information5 per_gen_hierarchy_nodes.INFORMATION5%type;

123: l_information1 per_gen_hierarchy_nodes.INFORMATION1%type;
124: l_information2 per_gen_hierarchy_nodes.INFORMATION2%type;
125: l_information3 per_gen_hierarchy_nodes.INFORMATION3%type;
126: l_information4 per_gen_hierarchy_nodes.INFORMATION4%type;
127: l_information5 per_gen_hierarchy_nodes.INFORMATION5%type;
128: l_information6 per_gen_hierarchy_nodes.INFORMATION6%type;
129: l_sum_amount number(15,2):=0.00;
130: total number(15,2) :=0.00;
131: n_further_count number(15) :=0;

Line 128: l_information6 per_gen_hierarchy_nodes.INFORMATION6%type;

124: l_information2 per_gen_hierarchy_nodes.INFORMATION2%type;
125: l_information3 per_gen_hierarchy_nodes.INFORMATION3%type;
126: l_information4 per_gen_hierarchy_nodes.INFORMATION4%type;
127: l_information5 per_gen_hierarchy_nodes.INFORMATION5%type;
128: l_information6 per_gen_hierarchy_nodes.INFORMATION6%type;
129: l_sum_amount number(15,2):=0.00;
130: total number(15,2) :=0.00;
131: n_further_count number(15) :=0;
132: l_marital_status varchar2(30);

Line 134: l_alimony_amount per_gen_hierarchy_nodes.INFORMATION1%type;

130: total number(15,2) :=0.00;
131: n_further_count number(15) :=0;
132: l_marital_status varchar2(30);
133: l_grade_id number(15);
134: l_alimony_amount per_gen_hierarchy_nodes.INFORMATION1%type;
135:
136: count_child NUMBER(15):=0;
137:
138: p_person_id NUMBER(10);