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.PER_MX_SSAFFL_ARCHIVE dependencies on PAY_USER_COLUMNS

Line 864: pay_user_columns puc

860:
861: cursor c_rww(cp_workschedule in varchar2) is
862: select sum(decode(to_number(puci.value),0,0,1))
863: from pay_user_column_instances_f puci,
864: pay_user_columns puc
865: where puc.user_column_name = cp_workschedule
866: and puc.legislation_code='MX'
867: and puc.user_column_id = puci.user_column_id ;
868:

Line 1170: pay_user_columns puc

1166: ,national_identifier CURP
1167: from per_all_assignments_f paf,
1168: per_all_people_f ppf,
1169: hr_soft_coding_keyflex hsc,
1170: pay_user_columns puc
1171: where paf.assignment_id = cp_assignment_id
1172: and paf.person_id = ppf.person_id
1173: and paf.soft_coding_keyflex_id = hsc.soft_coding_keyflex_id (+)
1174: and hsc.segment4 = puc.user_column_id(+)