405: (
406: SELECT pptt.person_type_id
407: FROM pay_user_tables put
408: ,pay_user_tables_tl putt
409: ,pay_user_columns puc
410: ,pay_user_columns_tl puct
411: ,pay_user_rows_f purf
412: ,pay_user_column_instances_f pucif
413: ,per_person_types_tl pptt
406: SELECT pptt.person_type_id
407: FROM pay_user_tables put
408: ,pay_user_tables_tl putt
409: ,pay_user_columns puc
410: ,pay_user_columns_tl puct
411: ,pay_user_rows_f purf
412: ,pay_user_column_instances_f pucif
413: ,per_person_types_tl pptt
414: WHERE put.business_group_id = papf.business_group_id
477: (
478: SELECT pptt.person_type_id
479: FROM pay_user_tables put
480: ,pay_user_tables_tl putt
481: ,pay_user_columns puc
482: ,pay_user_columns_tl puct
483: ,pay_user_rows_f purf
484: ,pay_user_column_instances_f pucif
485: ,per_person_types_tl pptt
478: SELECT pptt.person_type_id
479: FROM pay_user_tables put
480: ,pay_user_tables_tl putt
481: ,pay_user_columns puc
482: ,pay_user_columns_tl puct
483: ,pay_user_rows_f purf
484: ,pay_user_column_instances_f pucif
485: ,per_person_types_tl pptt
486: WHERE put.business_group_id = papf.business_group_id
550: (
551: SELECT paatt.absence_attendance_type_id
552: FROM pay_user_tables put
553: ,pay_user_tables_tl putt
554: ,pay_user_columns puc
555: ,pay_user_columns_tl puct
556: ,pay_user_rows_f purf
557: ,pay_user_column_instances_f pucif
558: ,per_absence_attendance_types paat
551: SELECT paatt.absence_attendance_type_id
552: FROM pay_user_tables put
553: ,pay_user_tables_tl putt
554: ,pay_user_columns puc
555: ,pay_user_columns_tl puct
556: ,pay_user_rows_f purf
557: ,pay_user_column_instances_f pucif
558: ,per_absence_attendance_types paat
559: ,per_abs_attendance_types_tl paatt
609: (
610: SELECT paatt.absence_attendance_type_id
611: FROM pay_user_tables put
612: ,pay_user_tables_tl putt
613: ,pay_user_columns puc
614: ,pay_user_columns_tl puct
615: ,pay_user_rows_f purf
616: ,pay_user_column_instances_f pucif
617: ,per_absence_attendance_types paat
610: SELECT paatt.absence_attendance_type_id
611: FROM pay_user_tables put
612: ,pay_user_tables_tl putt
613: ,pay_user_columns puc
614: ,pay_user_columns_tl puct
615: ,pay_user_rows_f purf
616: ,pay_user_column_instances_f pucif
617: ,per_absence_attendance_types paat
618: ,per_abs_attendance_types_tl paatt