APPS.PAY_USER_COLUMN_INSTA_MATRIX dependencies on PAY_USER_COLUMNS

Line 146: from pay_user_columns

142:
143: cursor csr_get_user_column_id( c_user_column_name varchar2,c_user_table_id number)
144: is
145: select user_column_id
146: from pay_user_columns
147: where user_table_id = c_user_table_id
148: and user_column_name = c_user_column_name;
149:
150: cursor csr_get_user_row_id( c_user_row_name varchar2,c_user_table_id number,c_effective_date date)

Line 358: from pay_user_columns puc,pay_user_tables put

354:
355: l_statement :=
356: 'select qualifier ,p_user_column_user_key
357: from (select ''LIVE'' qualifier,''PAY_USER_COLUMN:'' || :1 || '':'' || :2 || ''#'' ||user_column_name p_user_column_user_key
358: from pay_user_columns puc,pay_user_tables put
359: where put.user_table_name= :3
360: and puc.user_table_id=put.user_table_id
361: and (put.business_group_id is null or put.business_group_id = :4)
362: and (put.legislation_code is null or put.legislation_code = hr_api.return_legislation_code(:5))

Line 644: l_user_column_id pay_user_columns.user_column_id%type;

640: )
641: is
642:
643: l_user_key_value varchar2(240);
644: l_user_column_id pay_user_columns.user_column_id%type;
645: l_user_key_id number;
646:
647:
648: cursor csr_get_user_column_id (c_business_group hr_organization_units.name%type

Line 649: ,c_user_column_name pay_user_columns.user_column_name%type

645: l_user_key_id number;
646:
647:
648: cursor csr_get_user_column_id (c_business_group hr_organization_units.name%type
649: ,c_user_column_name pay_user_columns.user_column_name%type
650: ,c_user_key_value varchar2
651: ,c_user_table_name pay_user_tables.user_table_name%type)
652: is
653: select puc.user_column_id

Line 654: from pay_user_columns puc,

650: ,c_user_key_value varchar2
651: ,c_user_table_name pay_user_tables.user_table_name%type)
652: is
653: select puc.user_column_id
654: from pay_user_columns puc,
655: per_business_groups pbg,
656: pay_user_tables put
657: where (put.business_group_id is null or put.business_group_id = pbg.business_group_id)
658: and (put.legislation_code is null or put.legislation_code= hr_api.return_legislation_code(pbg.business_group_id))

Line 929: from pay_user_columns puc

925:
926: l_statement :='select user_column_name, rownum
927: from (select * from
928: (select user_column_name
929: from pay_user_columns puc
930: where puc.user_table_id = :1
931:
932: Union
933:

Line 959: pay_user_columns puc,

955: || p_row_low_range_or_name;
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