DBA Data[Home] [Help]

APPS.PQP_PENSION_EXTRACTS dependencies on PER_BUSINESS_GROUPS_PERF

Line 453: FROM per_business_groups_perf

449: (p_business_group_id IN NUMBER) RETURN VARCHAR2 IS
450:
451: CURSOR csr_bg_code (c_business_group_id IN NUMBER)IS
452: SELECT legislation_code
453: FROM per_business_groups_perf
454: WHERE business_group_id = c_business_group_id;
455: l_proc_name CONSTANT VARCHAR2(150) := g_proc_name ||'Get_Leg_Code';
456:
457: BEGIN

Line 4050: FROM per_business_groups_perf pbg

4046: -- Get the Legislation Code and Curreny Code
4047: CURSOR csr_leg_code (c_business_group_id IN NUMBER) IS
4048: SELECT pbg.legislation_code
4049: ,pbg.currency_code
4050: FROM per_business_groups_perf pbg
4051: WHERE pbg.business_group_id = c_business_group_id;
4052:
4053: -- Check the eligibility to the person enrolled for pension for passed values.
4054: CURSOR csr_chk_asg