[Home] [Help]
46: function get_business_group_id(p_legislation_code in varchar2) return varchar2
47: is
48: l_business_group_id number;
49: --
50: -- Do not use per_business_groups_perf which does not return
51: -- "Disabled" business groups.
52: --
53: cursor csr_bg is
54: select organization_id
336: l_person_id number;
337: l_effective_date date;
338: --
339: l_party_id number;
340: -- l_bg_name per_business_groups_perf.name%type;
341: l_full_name per_all_people_f.full_name%type;
342: --
343: cursor csr_ee is
344: select employment_income,
450: into l_party_id,
451: -- l_bg_name,
452: l_full_name
453: from per_all_people_f per,
454: per_business_groups_perf bg
455: where per.person_id = l_person_id
456: and l_effective_date
457: between per.effective_start_date and per.effective_end_date
458: and bg.business_group_id = per.business_group_id;
594: USE_NL(PEL PEE)
595: INDEX(PEL PAY_ELEMENT_LINKS_F_FK11)
596: INDEX(PEE PAY_ELEMENT_ENTRIES_F_N4) */
597: null
598: from per_business_groups_perf bg,
599: pay_element_links_f pel,
600: pay_element_entries_f pee
601: where bg.legislation_code = p_legislation_code
602: and pel.business_group_id = bg.business_group_id
608: INDEX(PPA PAY_PAYROLL_ACTIONS_FK1)
609: INDEX(PAA PAY_ASSIGNMENT_ACTIONS_N50)
610: INDEX(PRR PAY_RUN_RESULTS_N50) */
611: null
612: from per_business_groups_perf bg,
613: pay_payroll_actions ppa,
614: pay_assignment_actions paa,
615: pay_run_results prr
616: where bg.legislation_code = p_legislation_code
2870: where upgrade_definition_id = p_upgrade_definition_id
2871: and business_group_id is null
2872: and legislation_code = p_legislation_code;
2873: --
2874: -- Do not use per_business_groups_perf which does not return
2875: -- "Disabled" business groups.
2876: --
2877: cursor csr_bg is
2878: select organization_id