DBA Data[Home] [Help]

APPS.PY_ROLLBACK_PKG dependencies on PAY_LEGISLATION_RULES

Line 18: independent_periods_flag pay_legislation_rules.rule_mode%type,

14: current_date date, -- holds sysdate.
15: payroll_name pay_all_payrolls_f.payroll_name%type,
16: bg_name hr_organization_units.name%type,
17: bg_id hr_organization_units.business_group_id%type,
18: independent_periods_flag pay_legislation_rules.rule_mode%type,
19: date_earned date,
20: purge_phase pay_payroll_actions.purge_phase%type,
21: object_type pay_assignment_actions.object_type%type,
22: retro_definition_id pay_payroll_actions.retro_definition_id%type,

Line 77: l_rule_value pay_legislation_rules.rule_mode%type;

73: */
74: function legislation_rule(p_leg_code in varchar2,
75: p_rule_name in varchar2)
76: return varchar2 is
77: l_rule_value pay_legislation_rules.rule_mode%type;
78: begin
79: --
80: begin
81: --

Line 84: from pay_legislation_rules

80: begin
81: --
82: select rule_mode
83: into l_rule_value
84: from pay_legislation_rules
85: where legislation_code = p_leg_code
86: and rule_type = p_rule_name;
87: --
88: exception