eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_USER_COLUMN_INSTA_MATRIX dependencies on PAY_USER_TABLES

Line 137: from pay_user_tables

133:
134: cursor csr_get_user_table_id( c_user_table_name varchar2,c_business_group_id number)
135: is
136: select user_table_id
137: from pay_user_tables
138: where user_table_name = c_user_table_name
139: and (business_group_id is null or business_group_id = c_business_group_id)
140: and (legislation_code is null or legislation_code = hr_api.return_legislation_code(c_business_group_id));
141:

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 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 651: ,c_user_table_name pay_user_tables.user_table_name%type)

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
654: from pay_user_columns puc,
655: per_business_groups pbg,

Line 656: pay_user_tables put

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))
659: and pbg.name = c_business_group
660: and puc.user_column_name = c_user_column_name

Line 728: ,c_user_table_name pay_user_tables.user_table_name%type)

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
730: select pur.user_row_id
731: from pay_user_rows_f pur,
732: per_business_groups pbg,

Line 733: pay_user_tables put

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))
736: and pbg.name = c_business_group
737: and c_effective_date between pur.effective_start_date and pur.effective_end_date

Line 801: l_user_table_id pay_user_tables.user_table_id%type;

797: ,p_user_table_name varchar2
798: )
799: is
800:
801: l_user_table_id pay_user_tables.user_table_id%type;
802: l_user_key_value varchar2(240);
803: l_user_key_id number;
804:
805: cursor csr_get_user_table_id( c_user_key_value varchar2

Line 807: ,c_user_table_name pay_user_tables.user_table_name%type)

803: l_user_key_id number;
804:
805: cursor csr_get_user_table_id( c_user_key_value varchar2
806: ,c_business_group hr_organization_units.name%type
807: ,c_user_table_name pay_user_tables.user_table_name%type)
808: is
809: select put.user_table_id
810: from pay_user_tables put,per_business_groups pbg
811: where user_table_name = c_user_table_name

Line 810: from pay_user_tables put,per_business_groups pbg

806: ,c_business_group hr_organization_units.name%type
807: ,c_user_table_name pay_user_tables.user_table_name%type)
808: is
809: select put.user_table_id
810: from pay_user_tables put,per_business_groups pbg
811: where user_table_name = c_user_table_name
812: and pbg.name = c_business_group
813: and (put.business_group_id is null or put.business_group_id = pbg.business_group_id)
814: and (put.legislation_code is null or put.legislation_code= hr_api.return_legislation_code(pbg.business_group_id));

Line 892: from pay_user_tables

888:
889: cursor csr_get_user_table_id (c_business_group_id number, c_user_table_name varchar2)
890: is
891: select user_table_id
892: from pay_user_tables
893: where (business_group_id is null or business_group_id = c_business_group_id )
894: and (legislation_code is null or legislation_code = hr_api.return_legislation_code(c_business_group_id))
895: and user_table_name = c_user_table_name;
896: