DBA Data[Home] [Help]

APPS.PAY_JP_DEF_ARCHIVE dependencies on PER_BUSINESS_GROUPS_PERF

Line 15: g_legislation_code per_business_groups_perf.legislation_code%type;

11: --
12: g_payroll_action_id number;
13: g_business_group_id number;
14: g_effective_date date;
15: g_legislation_code per_business_groups_perf.legislation_code%type;
16: g_payroll_id number;
17: g_organization_id number;
18: g_process_assignments_flag varchar2(1);
19: --

Line 33: from per_business_groups_perf bg,

29: select ppa.business_group_id,
30: ppa.effective_date,
31: ppa.legislative_parameters,
32: bg.legislation_code
33: from per_business_groups_perf bg,
34: pay_payroll_actions ppa
35: where ppa.payroll_action_id = p_payroll_action_id
36: and bg.business_group_id = ppa.business_group_id;
37: l_rec csr%rowtype;