APPS.PAY_SE_TAX_CARD dependencies on PER_BUSINESS_GROUPS

Line 38: p_business_group_id IN per_business_groups.business_group_id%TYPE,

34: errbuf OUT NOCOPY VARCHAR2,
35: retcode OUT NOCOPY NUMBER,
36: p_file_name IN VARCHAR2,
37: p_effective_date IN VARCHAR2,
38: p_business_group_id IN per_business_groups.business_group_id%TYPE,
39: p_batch_name IN VARCHAR2 DEFAULT NULL ,
40: p_reference IN VARCHAR2 DEFAULT NULL
41: )
42: IS

Line 51: l_legislation_code per_business_groups.legislation_code%TYPE;

47: c_data_exchange_dir CONSTANT VARCHAR2 (30) := 'PER_DATA_EXCHANGE_DIR';
48:
49: -- Procedure name
50: l_proc CONSTANT VARCHAR2 (72) := g_package||'.upload' ;
51: l_legislation_code per_business_groups.legislation_code%TYPE;
52: l_bg_name per_business_groups.name%TYPE;
53:
54: -- File Handling variables
55: l_file_type UTL_FILE.file_type;

Line 52: l_bg_name per_business_groups.name%TYPE;

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

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

125: e_prim_assg_error EXCEPTION;
126: e_element_details EXCEPTION;
127:
128:
129: CURSOR csr_leg (v_bg_id per_business_groups.business_group_id%TYPE)
130: IS
131: SELECT legislation_code, name
132: FROM per_business_groups
133: WHERE business_group_id = v_bg_id;

Line 132: FROM per_business_groups

128:
129: CURSOR csr_leg (v_bg_id per_business_groups.business_group_id%TYPE)
130: IS
131: SELECT legislation_code, name
132: FROM per_business_groups
133: WHERE business_group_id = v_bg_id;
134:
135: CURSOR csr_get_prim_assg
136: ( p_business_group_id per_business_groups.business_group_id%TYPE

Line 136: ( p_business_group_id per_business_groups.business_group_id%TYPE

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