APPS.PAY_NO_TC_DP_UPLOAD dependencies on PER_BUSINESS_GROUPS

Line 33: p_business_group_id IN per_business_groups.business_group_id%TYPE,

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

Line 47: l_legislation_code per_business_groups.legislation_code%TYPE;

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

Line 48: l_bg_name per_business_groups.name%TYPE;

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

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

119:
120: --Flag variables
121: l_element_link_found VARCHAR2(30);
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
127: WHERE business_group_id = v_bg_id;

Line 126: FROM per_business_groups

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
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
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_ni per_all_people_f.national_identifier%TYPE
132: )
133: IS
134: SELECT PAA.ASSIGNMENT_ID