APPS.PAY_FI_TC_DP_UPLOAD dependencies on PER_BUSINESS_GROUPS

Line 30: p_business_group_id IN per_business_groups.business_group_id%TYPE,

26: errbuf OUT NOCOPY VARCHAR2,
27: retcode OUT NOCOPY NUMBER,
28: p_file_name IN VARCHAR2,
29: p_effective_date IN VARCHAR2,
30: p_business_group_id IN per_business_groups.business_group_id%TYPE,
31: p_batch_name IN VARCHAR2 DEFAULT NULL ,
32: p_reference IN VARCHAR2 DEFAULT NULL
33: )
34: IS

Line 44: l_legislation_code per_business_groups.legislation_code%TYPE;

40:
41:
42: -- Procedure name
43: l_proc CONSTANT VARCHAR2 (72) := g_package||'.upload' ;
44: l_legislation_code per_business_groups.legislation_code%TYPE;
45: l_bg_name per_business_groups.name%TYPE;
46:
47: -- File Handling variables
48: l_file_type UTL_FILE.file_type;

Line 45: l_bg_name per_business_groups.name%TYPE;

41:
42: -- Procedure name
43: l_proc CONSTANT VARCHAR2 (72) := g_package||'.upload' ;
44: l_legislation_code per_business_groups.legislation_code%TYPE;
45: l_bg_name per_business_groups.name%TYPE;
46:
47: -- File Handling variables
48: l_file_type UTL_FILE.file_type;
49: l_filename VARCHAR2 (240);

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

129: --Flag variables
130: l_element_link_found VARCHAR2(30);
131: l_prim_assg_found VARCHAR2(30);
132:
133: CURSOR csr_leg (v_bg_id per_business_groups.business_group_id%TYPE)
134: IS
135: SELECT legislation_code, name
136: FROM per_business_groups
137: WHERE business_group_id = v_bg_id;

Line 136: FROM per_business_groups

132:
133: CURSOR csr_leg (v_bg_id per_business_groups.business_group_id%TYPE)
134: IS
135: SELECT legislation_code, name
136: FROM per_business_groups
137: WHERE business_group_id = v_bg_id;
138:
139: CURSOR csr_get_prim_assg( p_business_group_id per_business_groups.business_group_id%TYPE
140: ,p_ni per_all_people_f.national_identifier%TYPE

Line 139: CURSOR csr_get_prim_assg( p_business_group_id per_business_groups.business_group_id%TYPE

135: SELECT legislation_code, name
136: FROM per_business_groups
137: WHERE business_group_id = v_bg_id;
138:
139: CURSOR csr_get_prim_assg( p_business_group_id per_business_groups.business_group_id%TYPE
140: ,p_ni per_all_people_f.national_identifier%TYPE
141: ,p_employer_org_no HR_ORGANIZATION_INFORMATION.org_information2%TYPE)
142: IS
143: SELECT PAA.ASSIGNMENT_ID

Line 180: CURSOR csr_get_all_assg( p_business_group_id per_business_groups.business_group_id%TYPE

176: and fnd_date.canonical_to_date(p_effective_date) <= nvl(o1.DATE_TO, fnd_date.canonical_to_date(p_effective_date)));
177:
178:
179:
180: CURSOR csr_get_all_assg( p_business_group_id per_business_groups.business_group_id%TYPE
181: ,p_ni per_all_people_f.national_identifier%TYPE
182: ,p_employer_org_no HR_ORGANIZATION_INFORMATION.org_information2%TYPE)
183: IS
184: SELECT PAA.ASSIGNMENT_ID