APPS.PAY_USER_COLUMN_INSTA_MATRIX dependencies on PAY_USER_ROWS_F

Line 153: from pay_user_rows_f

149:
150: cursor csr_get_user_row_id( c_user_row_name varchar2,c_user_table_id number,c_effective_date date)
151: is
152: select user_row_id
153: from pay_user_rows_f
154: where row_low_range_or_name = c_user_row_name
155: and user_table_id = c_user_table_id
156: and c_effective_date between effective_start_date and effective_end_date;
157:

Line 327: l_statement := 'select 1 from pay_user_rows_f pur,pay_user_tables put where row_low_range_or_name = :1 and

323: fetch csr_get_business_group_id into l_business_group_id;
324: close csr_get_business_group_id;
325:
326:
327: l_statement := 'select 1 from pay_user_rows_f pur,pay_user_tables put where row_low_range_or_name = :1 and
328: (put.business_group_id is null or put.business_group_id = :2)
329: and (put.legislation_code is null or put.legislation_code = hr_api.return_legislation_code(:3))
330: and put.user_table_id = pur.user_table_id and
331: put.user_table_name = :4';

Line 720: l_user_row_id pay_user_rows_f.user_row_id%type;

716: )
717: is
718:
719: l_user_key_value varchar2(240);
720: l_user_row_id pay_user_rows_f.user_row_id%type;
721: l_user_key_id number;
722:
723: cursor csr_get_user_row_id(
724: c_business_group hr_organization_units.name%type

Line 725: ,c_user_row_name pay_user_rows_f.row_low_range_or_name%type

721: l_user_key_id number;
722:
723: cursor csr_get_user_row_id(
724: c_business_group hr_organization_units.name%type
725: ,c_user_row_name pay_user_rows_f.row_low_range_or_name%type
726: ,c_effective_date date
727: ,c_user_key_value varchar2
728: ,c_user_table_name pay_user_tables.user_table_name%type)
729: is

Line 731: from pay_user_rows_f pur,

727: ,c_user_key_value varchar2
728: ,c_user_table_name pay_user_tables.user_table_name%type)
729: is
730: select pur.user_row_id
731: from pay_user_rows_f pur,
732: per_business_groups pbg,
733: pay_user_tables put
734: where (put.business_group_id is null or put.business_group_id= pbg.business_group_id)
735: and (put.legislation_code is null or put.legislation_code = hr_api.return_legislation_code(pbg.business_group_id))

Line 960: pay_user_rows_f pur

956:
957: l_statement := '(select puc.user_column_name || '':'' || pui.value qualified_value
958: from pay_user_column_instances_f pui,
959: pay_user_columns puc,
960: pay_user_rows_f pur
961: where pur.row_low_range_or_name = :1
962: and pur.user_table_id = :2
963: and puc.user_table_id = pur.user_table_id
964: and pui.user_column_id = puc.user_column_id