APPS.OTAFRUDT dependencies on PER_BUSINESS_GROUPS

Line 58: v_legislation_code per_business_groups.legislation_code%TYPE;

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

Line 66: FROM per_business_groups

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

Line 105: v_legislation_code per_business_groups.legislation_code%TYPE;

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

Line 129: FROM per_business_groups

125: AND business_group_id = P_BUSINESS_GROUP_ID_CC;
126: --
127: SELECT legislation_code
128: INTO v_legislation_code
129: FROM per_business_groups
130: WHERE business_group_id = P_BUSINESS_GROUP_ID_CC;
131: --
132: OPEN user_column_id_csr;
133: 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 := TO_DATE ('01/01/1900', 'DD/MM/YYYY');
168: v_end_date date := TO_DATE ('31/12/4712', 'DD/MM/YYYY');
169: --
170: v_user_table_id number;