APPS.HR_FR_SEED_PKG dependencies on PER_BUSINESS_GROUPS

Line 55: v_legislation_code per_business_groups.legislation_code%TYPE;

51: FROM pay_user_tables
52: WHERE business_group_id = P_BUSINESS_GROUP_ID_CT
53: AND user_table_name = P_USER_TABLE_NAME_CT;
54:
55: v_legislation_code per_business_groups.legislation_code%TYPE;
56: v_user_table_name varchar (100);
57: BEGIN
58:
59: hr_utility.trace ('PROCEDURE create table entered.');

Line 63: FROM per_business_groups

59: hr_utility.trace ('PROCEDURE create table entered.');
60:
61: SELECT legislation_code
62: INTO v_legislation_code
63: FROM per_business_groups
64: WHERE business_group_id = P_BUSINESS_GROUP_ID_CT;
65: --
66: OPEN user_table_name_csr;
67: FETCH user_table_name_csr INTO v_user_table_name;

Line 103: v_legislation_code per_business_groups.legislation_code%TYPE;

99: v_column_row_id varchar2 (100) := NULL;
100: v_user_column_id number := NULL;
101:
102: v_user_table_id number;
103: v_legislation_code per_business_groups.legislation_code%TYPE;
104: v_user_column_name varchar2 (100);
105:
106: CURSOR user_column_id_csr IS
107: SELECT user_column_id

Line 128: FROM per_business_groups

124: AND business_group_id = P_BUSINESS_GROUP_ID_CC;
125: --
126: SELECT legislation_code
127: INTO v_legislation_code
128: FROM per_business_groups
129: WHERE business_group_id = P_BUSINESS_GROUP_ID_CC;
130: --
131: OPEN user_column_id_csr;
132: FETCH user_column_id_csr INTO v_user_column_id;

Line 166: v_legislation_code per_business_groups.legislation_code%TYPE;

162: P_ROW_LOW_RANGE_OR_NAME_CR IN varchar2,
163: P_DISPLAY_SEQUENCE_CR IN number,
164: P_VALUE_CR IN varchar2)
165: IS
166: v_legislation_code per_business_groups.legislation_code%TYPE;
167: v_start_date date;
168: v_end_date date;
169: --
170: v_user_table_id number;