DBA Data[Home] [Help]

APPS.PAY_JP_ISDF_ARCHIVE_PKG dependencies on PER_BUSINESS_GROUPS_PERF

Line 33: g_legislation_code per_business_groups_perf.legislation_code%type;

29: c_st_upd_date_2007 constant date := to_date('2007/01/01','YYYY/MM/DD');
30: --
31: g_debug boolean := hr_utility.debug_enabled;
32: g_business_group_id number;
33: g_legislation_code per_business_groups_perf.legislation_code%type;
34: g_payroll_action_id number;
35: g_assignment_action_id number;
36: g_assignment_id number;
37: g_effective_date date;

Line 69: per_business_groups_perf pbg

65: ppa.effective_date,
66: ppa.legislative_parameters,
67: pbg.legislation_code
68: from pay_payroll_actions ppa,
69: per_business_groups_perf pbg
70: where ppa.payroll_action_id = p_payroll_action_id
71: and pbg.business_group_id = ppa.business_group_id;
72: --
73: cursor csr_bg_itax_dpnt_ref_type