APPS.PAY_DK_TC_DP_UPLOAD dependencies on PER_BUSINESS_GROUPS

Line 23: p_business_group_id IN per_business_groups.business_group_id%TYPE,

19: errbuf OUT NOCOPY VARCHAR2,
20: retcode OUT NOCOPY NUMBER,
21: p_file_name IN VARCHAR2,
22: p_effective_date IN VARCHAR2,
23: p_business_group_id IN per_business_groups.business_group_id%TYPE,
24: p_batch_name IN VARCHAR2 DEFAULT NULL,
25: p_reference IN VARCHAR2 DEFAULT NULL
26: )
27: IS

Line 37: l_legislation_code per_business_groups.legislation_code%TYPE;

33: c_data_exchange_dir CONSTANT VARCHAR2 (30) := 'PER_DATA_EXCHANGE_DIR';
34:
35: -- Procedure name
36: l_proc CONSTANT VARCHAR2 (72) := g_package||'.upload' ;
37: l_legislation_code per_business_groups.legislation_code%TYPE;
38: l_bg_name per_business_groups.name%TYPE;
39:
40: -- File Handling variables
41: l_file_type UTL_FILE.file_type;

Line 38: l_bg_name per_business_groups.name%TYPE;

34:
35: -- Procedure name
36: l_proc CONSTANT VARCHAR2 (72) := g_package||'.upload' ;
37: l_legislation_code per_business_groups.legislation_code%TYPE;
38: l_bg_name per_business_groups.name%TYPE;
39:
40: -- File Handling variables
41: l_file_type UTL_FILE.file_type;
42: l_filename VARCHAR2 (240);

Line 123: CURSOR csr_leg (v_bg_id per_business_groups.business_group_id%TYPE)

119:
120: cursor get_batch_name(p_batch_name hr_pump_batch_headers.batch_name%type) is
121: select batch_name from hr_pump_batch_headers where batch_name = p_batch_name;
122:
123: CURSOR csr_leg (v_bg_id per_business_groups.business_group_id%TYPE)
124: IS
125: SELECT legislation_code, name
126: FROM per_business_groups_perf
127: WHERE business_group_id = v_bg_id;

Line 126: FROM per_business_groups_perf

122:
123: CURSOR csr_leg (v_bg_id per_business_groups.business_group_id%TYPE)
124: IS
125: SELECT legislation_code, name
126: FROM per_business_groups_perf
127: WHERE business_group_id = v_bg_id;
128:
129: CURSOR csr_get_prim_assg
130: ( p_business_group_id per_business_groups.business_group_id%TYPE

Line 130: ( p_business_group_id per_business_groups.business_group_id%TYPE

126: FROM per_business_groups_perf
127: WHERE business_group_id = v_bg_id;
128:
129: CURSOR csr_get_prim_assg
130: ( p_business_group_id per_business_groups.business_group_id%TYPE
131: ,p_cpr per_all_people_f.national_identifier%TYPE
132: ,p_date per_all_assignments_f.effective_start_date%TYPE)
133: IS
134: SELECT PAA.ASSIGNMENT_ID

Line 170: CURSOR csr_get_legal_employer(v_bg_id per_business_groups.business_group_id%TYPE)

166: SELECT user_key_value, unique_key_id
167: FROM hr_pump_batch_line_user_keys
168: WHERE user_key_value = p_user_key_value;
169:
170: CURSOR csr_get_legal_employer(v_bg_id per_business_groups.business_group_id%TYPE)
171: IS
172: SELECT hoi.org_information1, hoi.org_information5
173: FROM hr_organization_units hru, hr_organization_information hoi
174: WHERE business_group_id = v_bg_id