APPS.PER_ZA_UTILITY_PKG dependencies on PAY_USER_TABLES

Line 129: pay_user_tables put

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
131: and puc.user_table_id = put.user_table_id
132: and pur.user_table_id = put.user_table_id
133: and puci.user_row_id = pur.user_row_id

Line 251: l_range_or_match pay_user_tables.range_or_match%type;

247: , p_effective_date IN DATE
248: ) RETURN VARCHAR2
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

Line 252: l_table_id pay_user_tables.user_table_id%type;

248: ) RETURN VARCHAR2
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: -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -

Line 279: from pay_user_tables tab

275: select tab.range_or_match
276: , tab.user_table_id
277: into l_range_or_match
278: , l_table_id
279: from pay_user_tables tab
280: where upper(tab.user_table_name) = upper(p_table_name)
281: and tab.legislation_code = g_leg_code;
282: --
283: if (l_range_or_match = 'M') then -- matched

Line 291: , pay_user_tables TAB

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
293: and C.user_table_id = TAB.user_table_id
294: and C.legislation_code = g_leg_code
295: and upper (C.user_column_name) = upper (p_col_name)

Line 336: , pay_user_tables TAB

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
338: and C.user_table_id = TAB.user_table_id
339: and C.legislation_code = g_leg_code
340: and upper (C.user_column_name) = upper (p_col_name)

Line 382: l_range_or_match pay_user_tables.range_or_match%type;

378: , p_business_group_id IN VARCHAR2
379: ) RETURN VARCHAR2
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

Line 383: l_table_id pay_user_tables.user_table_id%type;

379: ) RETURN VARCHAR2
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: -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -

Line 410: from pay_user_tables tab

406: select tab.range_or_match
407: , tab.user_table_id
408: into l_range_or_match
409: , l_table_id
410: from pay_user_tables tab
411: where upper(tab.user_table_name) = upper(p_table_name)
412: and tab.legislation_code = g_leg_code;
413: --
414: if (l_range_or_match = 'M') then -- matched

Line 422: , pay_user_tables TAB

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
424: and C.user_table_id = TAB.user_table_id
425: and C.legislation_code = g_leg_code
426: and upper (C.user_column_name) = upper (p_col_name)

Line 467: , pay_user_tables TAB

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
469: and C.user_table_id = TAB.user_table_id
470: and C.legislation_code = g_leg_code
471: and upper (C.user_column_name) = upper (p_col_name)