DBA Data[Home] [Help]

APPS.HR_PDE_BUS dependencies on HR_PERSON_DEPLYMT_EITS

Line 30: , hr_person_deplymt_eits pde

26: --
27: cursor csr_leg_code is
28: select pbg.legislation_code
29: from per_business_groups_perf pbg
30: , hr_person_deplymt_eits pde
31: , hr_person_deployments pdt
32: where pde.person_deplymt_eit_id = p_person_deplymt_eit_id
33: and pde.person_deployment_id = pdt.person_deployment_id
34: and pbg.business_group_id = pdt.to_business_group_id;

Line 196: (p_person_deployment_id in hr_person_deplymt_eits.person_deployment_id%type

192: -- {End of Comments}
193: --
194: -- ---------------------------------------------------------------------------
195: Procedure chk_person_deployment_id
196: (p_person_deployment_id in hr_person_deplymt_eits.person_deployment_id%type
197: ) is
198: --
199: l_proc varchar2(72) := g_package||'chk_person_deployment_id';
200: l_dummy number;

Line 260: (p_person_extra_info_id in hr_person_deplymt_eits.person_extra_info_id%type

256: -- {End of Comments}
257: --
258: -- ---------------------------------------------------------------------------
259: Procedure chk_person_extra_info_id
260: (p_person_extra_info_id in hr_person_deplymt_eits.person_extra_info_id%type
261: ,p_person_deployment_id in hr_person_deplymt_eits.person_deployment_id%type
262: ) is
263: --
264: l_proc varchar2(72) := g_package||'chk_person_extra_info_id';

Line 261: ,p_person_deployment_id in hr_person_deplymt_eits.person_deployment_id%type

257: --
258: -- ---------------------------------------------------------------------------
259: Procedure chk_person_extra_info_id
260: (p_person_extra_info_id in hr_person_deplymt_eits.person_extra_info_id%type
261: ,p_person_deployment_id in hr_person_deplymt_eits.person_deployment_id%type
262: ) is
263: --
264: l_proc varchar2(72) := g_package||'chk_person_extra_info_id';
265: l_dummy number;