DBA Data[Home] [Help]

APPS.PY_ROLLBACK_PKG dependencies on HR_LOOKUPS

Line 8: action_name hr_lookups.meaning%type,

4: type rollback_rec is record
5: (
6: -- Payroll Action Level Details.
7: pact_id pay_payroll_actions.payroll_action_id%type,
8: action_name hr_lookups.meaning%type,
9: action_type pay_payroll_actions.action_type%type,
10: action_status pay_payroll_actions.action_status%type,
11: sequenced_flag boolean,
12: action_date date,

Line 1106: hr_lookups hrl

1102: p_info.sub_ledger_acc
1103: from pay_payroll_actions pac,
1104: pay_all_payrolls_f pay,
1105: per_business_groups_perf grp,
1106: hr_lookups hrl
1107: where pac.payroll_action_id = p_info.pact_id
1108: and hrl.lookup_code = pac.action_type
1109: and hrl.lookup_type = 'ACTION_TYPE'
1110: and grp.business_group_id = pac.business_group_id + 0

Line 1185: l_action_name hr_lookups.meaning%type;

1181: l_line_sequence number;
1182: l_payroll_id number;
1183: l_source_id number;
1184: l_source_type pay_message_lines.source_type%type;
1185: l_action_name hr_lookups.meaning%type;
1186: begin
1187: g_debug := hr_utility.debug_enabled;
1188: if g_debug then
1189: c_indent := 'py_rollback_pkg.ins_rollback_message';