APPS.BEN_PRC_BUS dependencies on PER_BUSINESS_GROUPS

Line 2598: from per_business_groups a,

2594: -- Declare cursor
2595: --
2596: cursor csr_leg_code is
2597: select a.legislation_code
2598: from per_business_groups a,
2599: ben_prtt_reimbmt_rqst_f b
2600: where b.prtt_reimbmt_rqst_id = p_prtt_reimbmt_rqst_id
2601: and a.business_group_id = b.business_group_id;
2602: --

Line 2605: l_legislation_code per_business_groups.legislation_code%TYPE; --UTF8 varchar2(150);

2601: and a.business_group_id = b.business_group_id;
2602: --
2603: -- Declare local variables
2604: --
2605: l_legislation_code per_business_groups.legislation_code%TYPE; --UTF8 varchar2(150);
2606: l_proc varchar2(72) := g_package||'return_legislation_code';
2607: --
2608: begin
2609: --