DBA Data[Home] [Help]

APPS.PAY_JP_ISDF_ARCHIVE_PKG dependencies on PER_BUSINESS_GROUPS_PERF

Line 36: g_legislation_code per_business_groups_perf.legislation_code%type;

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

Line 72: per_business_groups_perf pbg

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