DBA Data[Home] [Help]

APPS.PAY_INTERPRETER_PKG dependencies on PAY_GRADE_RULES_F

Line 4792: from pay_grade_rules_f pgr,

4788: )
4789: is
4790: select /*+ USE_NL(pgr paf)*/
4791: pgr.grade_rule_id
4792: from pay_grade_rules_f pgr,
4793: per_all_assignments_f paf
4794: where paf.assignment_id = p_assignment_id
4795: and paf.grade_id = pgr.grade_or_spinal_point_id
4796: union all

Line 4802: pay_grade_rules_f pgr

4798: pgr.grade_rule_id
4799: from per_spinal_point_placements_f pspp,
4800: per_spinal_point_steps_f psps,
4801: per_spinal_points psp,
4802: pay_grade_rules_f pgr
4803: where psp.spinal_point_id = pgr.grade_or_spinal_point_id
4804: and psp.spinal_point_id = psps.spinal_point_id
4805: and p_assignment_id = pspp.assignment_id
4806: and pspp.step_id = psps.step_id;

Line 4840: if (p_table_name = 'PAY_GRADE_RULES_F') then

4836: begin
4837: --
4838: l_valid_event := 'Y';
4839: --
4840: if (p_table_name = 'PAY_GRADE_RULES_F') then
4841: --
4842: if (g_grd_assignment_id <> p_assignment_id) then
4843: --
4844: g_grade_list.delete();