APPS.HRDYNDBI dependencies on PAY_RATES

Line 5939: l_rate_type pay_rates.rate_type%type;

5935: p_rate_id in number
5936: ) is
5937: l_grade_route_name varchar2(50) := 'GRADE_RATE_ROUTE';
5938: l_spine_route_name varchar2(50) := 'SPINE_RATE_ROUTE';
5939: l_rate_type pay_rates.rate_type%type;
5940: l_name pay_rates.name%type;
5941: l_business_group_id number;
5942: l_created_by number;
5943: l_last_login number;

Line 5940: l_name pay_rates.name%type;

5936: ) is
5937: l_grade_route_name varchar2(50) := 'GRADE_RATE_ROUTE';
5938: l_spine_route_name varchar2(50) := 'SPINE_RATE_ROUTE';
5939: l_rate_type pay_rates.rate_type%type;
5940: l_name pay_rates.name%type;
5941: l_business_group_id number;
5942: l_created_by number;
5943: l_last_login number;
5944: l_record_inserted boolean;

Line 5962: from pay_rates

5958: l_name,
5959: l_business_group_id,
5960: l_created_by,
5961: l_last_login
5962: from pay_rates
5963: where rate_id = p_rate_id;
5964: --
5965: if (l_rate_type = 'G') then -- grade
5966: --

Line 6068: from pay_rates r

6064: exist.
6065: */
6066: procedure refresh_grade_spine_rates is
6067: cursor c1 is select rate_id
6068: from pay_rates r
6069: where not exists (select null from ff_user_entities u
6070: where u.creator_id = r.rate_id
6071: and u.creator_type = 'G');
6072: begin

Line 6098: from pay_rates;

6094: exist.
6095: */
6096: procedure delete_grade_spine_rates is
6097: cursor c1 is select rate_id
6098: from pay_rates;
6099: begin
6100: --
6101: -- delete the grade/ spine rates
6102: --