DBA Data[Home] [Help]

APPS.HR_DE_ORGANIZATION_UPLOAD dependencies on HR_DE_SOCINS_PROV_DEFINITION_V

Line 29: FROM hr_de_socins_prov_definition_v

25: ,health_insurance_type
26: ,LPAD(east_betriebesnumber, 8, '0') east_betriebesnumber
27: ,LPAD(west_betriebesnumber, 8, '0') west_betriebesnumber
28: ,pension_insurance_type
29: FROM hr_de_socins_prov_definition_v
30: WHERE provider_type = NVL(p_provider_type, provider_type)
31: ORDER BY hr_general.decode_lookup('DE_ORG_UPLOAD_PROV_TYPES', provider_type);
32: --
33: --

Line 1046: -- HR_DE_SOCINS_PROV_DEFINITION_V.

1042: -- in the HRMS system.
1043: --
1044: -- The definitions for the social insurance providers are held in a user table
1045: -- named HR_DE_SOC_INS_PROV_DEFINITION which can be seen by using a view named
1046: -- HR_DE_SOCINS_PROV_DEFINITION_V.
1047: --
1048: -- The parameters are defined as follows...
1049: --
1050: -- p_business_group_id: the business group for which this upload is being run.