APPS.PER_ZA_UTILITY_PKG dependencies on PAY_USER_COLUMN_INSTANCES_F

Line 126: from pay_user_column_instances_f puci,

122: --for the specified Business group id.
123: begin
124: select pur.row_low_range_or_name
125: into l_meaning
126: from pay_user_column_instances_f puci,
127: pay_user_columns puc ,
128: pay_user_rows_f pur ,
129: pay_user_tables put
130: where put.user_table_name = p_table_name

Line 253: l_value pay_user_column_instances_f.value%type;

249: AS
250: l_effective_date date;
251: l_range_or_match pay_user_tables.range_or_match%type;
252: l_table_id pay_user_tables.user_table_id%type;
253: l_value pay_user_column_instances_f.value%type;
254:
255: begin
256: -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -
257: --

Line 288: from pay_user_column_instances_f CINST

284: begin
285: hr_utility.set_location ('hruserdt.get_table_value', 4);
286: select CINST.value
287: into l_value
288: from pay_user_column_instances_f CINST
289: , pay_user_columns C
290: , pay_user_rows_f R
291: , pay_user_tables TAB
292: where TAB.user_table_id = l_table_id

Line 333: from pay_user_column_instances_f CINST

329: begin
330: hr_utility.set_location ('hruserdt.get_table_value', 5);
331: select CINST.value
332: into l_value
333: from pay_user_column_instances_f CINST
334: , pay_user_columns C
335: , pay_user_rows_f R
336: , pay_user_tables TAB
337: where TAB.user_table_id = l_table_id

Line 384: l_value pay_user_column_instances_f.value%type;

380: AS
381: l_effective_date date;
382: l_range_or_match pay_user_tables.range_or_match%type;
383: l_table_id pay_user_tables.user_table_id%type;
384: l_value pay_user_column_instances_f.value%type;
385:
386: begin
387: -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -
388: --

Line 419: from pay_user_column_instances_f CINST

415: begin
416: hr_utility.set_location ('hruserdt.get_table_value', 4);
417: select CINST.value
418: into l_value
419: from pay_user_column_instances_f CINST
420: , pay_user_columns C
421: , pay_user_rows_f R
422: , pay_user_tables TAB
423: where TAB.user_table_id = l_table_id

Line 464: from pay_user_column_instances_f CINST

460: begin
461: hr_utility.set_location ('hruserdt.get_table_value', 5);
462: select CINST.value
463: into l_value
464: from pay_user_column_instances_f CINST
465: , pay_user_columns C
466: , pay_user_rows_f R
467: , pay_user_tables TAB
468: where TAB.user_table_id = l_table_id