APPS.HRDYNDBI dependencies on PAY_RATES

Line 5942: l_rate_type pay_rates.rate_type%type;

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

Line 5943: l_name pay_rates.name%type;

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

Line 5965: from pay_rates

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

Line 6071: from pay_rates r

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

Line 6101: from pay_rates;

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